Simple SEO URL (OLD version) [support thread]

slitter:

Yes, the prefix is zen_ for all my tables thats why I tried to manualy run the script to the zen_configuration table.
Actually the module should pick up the prefix and auto appends it, which it doesnt do for some reason.

Go to admin/includes/classes/sqlpatch_class.php and edit this file, you should find this line

if (!defined('DB_PREFIX')) define('DB_PREFIX','');

Replace by:

if (!defined('DB_PREFIX')) define('DB_PREFIX','zen_');

OK I am getting the same error and when I go to the module manager I get the following message
Failed: 1
ERROR: Cannot create table module_version_tracker because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
Failed to set up version tracker table

slitter:

OK I am getting the same error and when I go to the module manager I get the following message
Failed: 1
ERROR: Cannot create table module_version_tracker because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
Failed to set up version tracker table
TROUBLESHOOTING: After installing itself, this module writes a file named ".keep" in admin\includes\module_installation, if your server doesnt allow it to do so, it may make the module attempting to install itself everytime. The fix is easy though, just manually create a .keep file there (after the module has already installed itself, of course)

mmm, still getting the 1146 Table 'satur_zc1.configuration' doesn't exist" message at extra-> will continue later on tonight after thoroughly goin over everything again thanks for the help so far..

slitter:

mmm, still getting the 1146 Table 'satur_zc1.configuration' doesn't exist" message at extra-> will continue later on tonight after thoroughly goin over everything again thanks for the help so far..
There is a way to do it, tho it kills the purpose of having the manager do it automatically for you:

Go thru each and every patch, apply them manually. After you do that we will have to update the tracker table to let it know all the patches are applied. If you let me know your zc and server details maybe we can figure something else. its a bit weird. Did you download the manager rev15 from google?

I will install each patch, but don't know how to update the tracker and yes I used the latest manager I d/l from the zen site.
I have sent you a pm with the info if you want to take a look at it first..

ueee thank you I did it, I've installed solving all problems by myself reading in this thread.

Only one thing, I see all, but don't rewrite.

I have my store (a demo store because I am doing a restyle of my site) in folder demosugar

maybe I insert a wrong .htaccess?
hxxp://www.giocattoliamo.it/demosugar/

please if you have some ideas help me, then I have finished with your great mods.

Thanks in advance
:smile:

giuly:

ueee thank you I did it, I've installed solving all problems by myself reading in this thread.

Only one thing, I see all, but don't rewrite.

I have my store (a demo store because I am doing a restyle of my site) in folder demosugar

maybe I insert a wrong .htaccess?
hxxp://www.giocattoliamo.it/demosugar/

please if you have some ideas help me, then I have finished with your great mods.

Thanks in advance
:smile:
Did you turn it on via admin? This module is off by default, because there are some settings you need to set first.

how I turn on?
I see all via admin, but not the option to activate???

sorry I'm stupid please sorry
Now I have turn on, SSU I didn't think on abbreviation.
Pleas sorry
and a great thanks for your mod that I will use.

:clap:

1. Visit admin→extras→ssu manager (you should see notice saying that the database patches have been applied)

2. Under admin->confuration you should see Simple Seo Url

You will see the settings there

slitter:

I will install each patch, but don't know how to update the tracker and yes I used the latest manager I d/l from the zen site.
I have sent you a pm with the info if you want to take a look at it first..
For whatever reason, your server setting makes it impossible to run any query via the patch tool if there is a line break in the query, so I had to remove them from all the patches,

example:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('File extension', 'SSU_FILE_EXTENSION', '', 'Set the file extension you want (without the dot). Recommend: leave it blank. For more info please read the docs', @t4, 1, NOW(), NOW(), NULL, NULL),
('Name delimiter', 'SSU_NAME_DELIMITER', '-', 'Set delimiter to replace all non alpha-numeric characters in product/category names', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'-\', \'.\'),'), ('ID delimiter', 'SSU_ID_DELIMITER', '-', 'Set delimiter separate product/category names and their ids', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'-\', \'.\'),');

Note that you are using 3.5.8, that version is stable but does not have auto-alias.

yellow1912:

1. Visit admin→extras→ssu manager (you should see notice saying that the database patches have been applied)

2. Under admin->confuration you should see Simple Seo Url

You will see the settings there

in extras I see
Instruction SSU caches your categories/products names and links in order to reduce the number of sql queries and minimize the performance penalty on your server. That has its drawback, however. If you change your categories/products names, you will need to reset the cache to force SSU reload and update the names. Cache Functions Reset all cache: Click here
Reset alias cache: Click here
Reset only products cache:Click here
Reset only categories cache: Click here
Reset only pages cache: Click here
Alias Functions Manage Aliases: Click here

in configuration I see

the various configuration so true or false and directoryes to exclude.

Thanks a lot, also for rapidity on answers

The configuration are self-explained, you can click on each one to see more details.

If you need more details you can check them here
http://wiki.rubikintegration.com/zencart/modules/ssu/config

To turn SSU on:
Set SSU Status to True

Make sure you change other settings first if you want to, before you turn it on. Which version are you using? If you use 3.6.0 then turn on Link Alias and Auto Alias as well

thank to you very much, I have the 3.5.8
and thank because I see how to add also manufacturers.

:yes:

yellow1912:

For whatever reason, your server setting makes it impossible to run any query via the patch tool if there is a line break in the query, so I had to remove them from all the patches,

Note that you are using 3.5.8, that version is stable but does not have auto-alias.

Thanks a MILLION it works now. So if I am correct I can install SSU on another website on my particular server by first
1.changing the line in /includes/classes/sqlpatch_class.php to
if (!defined('DB_PREFIX')) define('DB_PREFIX','zen_');
2.editing the patches as described above
3.upload and turn on SSU in admin

I presume i do not have to worry about manually updating the tracker table anymore?

I have edited all patches in version 3.5.8+ (make sure you download from the link in my signature) so you dont have to edit the patches again. You may have to edit the sqlpatch_class.php tho

Has anybody gotten this mod to work with WOZ? (Wordpress on Zen Cart)

What did you do to get it to work properly?

Been struggling for days on this.

swamyg1:

Has anybody gotten this mod to work with WOZ? (Wordpress on Zen Cart)

What did you do to get it to work properly?

Been struggling for days on this.
You will have to put the main page of your wordpress to the exclude page list.

yellow1912:

You will have to put the main page of your wordpress to the exclude page list.

Ahhh ok, this is good... thanks much!

swamyg1:

Ahhh ok, this is good... thanks much!
You are welcome. The reason is that this WP module install wordpress as a subfolder of zencart.

Another thing you can do, which you may like better, is to use link alias to get around it
For example if you are having wp in folder 'wordpress", then you can consider creating a link-alias pair like this:
link_url: /wordpress/
link_alias: /blog/