Simple SEO URL (OLD version) [support thread]

[yellow1912]

This is on installation of 2.9.7 and the entire site was blank too so I took everything out and uploaded everything again but the same thing happened . So I took it out and am trying to figure it out , I was thinking module manager might have something to do with it or html_output.php

You should run zencart debug and see exactly what kind of error you have, then we can use that to solve the problem

https://www.zen-cart.com/tutorials/index.php?article=82

[goldenhues]

[20-Nov-2008 23:33:40] PHP Warning: main(/usr/home/path/websites/mysite.com/includes/init_includes/init_yclass.php) [<a href='function.main'>function.main</a>]: failed to open stream: No such file or directory in /usr/home/path/websites/mysite.com/admin/includes/init_includes/init_yclass.php on line 2
[20-Nov-2008 23:33:40] PHP Fatal error: main() [<a href='function.require'>function.require</a>]: Failed opening required '/usr/home/path/websites/mysite.com/includes/init_includes/init_yclass.php' (include_path='.:/usr/local/lib/php') in /usr/home/path/websites/mysite.com/admin/includes/init_includes/init_yclass.php on line 2

[yellow1912]

It looks like some files went missing. Perhaps you forgot to install the module manager on this site first?

[goldenhues]

Hi ,
Now after installing accurately , I get this -
1062 Duplicate entry 'SSU_LINK_ALIAS' for key 2
in:
[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 ('Set Link Alias Status', 'SSU_LINK_ALIAS', 'false', 'Link alias allows you to replace any specific link by another link. After setting this to true, you can go to Admin->Extras->Simple SEO URL Manager and set link aliases', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[yellow1912]

This is a bit troublesome with the current version of module manager(which I intends to update soon)

Anyhow, it is pretty easy to fix, first check the module manager, see how many module listed in there, if there is only (SSU), then go to tools->sql patch and run:

TRUNCATE TABLE module_version_tracker;

Now go to module manager to reinstall SSU again, you should be good to go.

[goldenhues]

Hi ,
this is what I get for module manager , I thought it was installed.

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

[yellow1912]

Hi ,
this is what I get for module manager , I thought it was installed.

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)

[goldenhues]

Hi ,
now I get this error message
1064 You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1
in:
[CREATE TABLE IF NOT EXISTS links_aliases ( id int(10) NOT NULL auto_increment, link_url varchar(255) NOT NULL, link_alias varchar(255) NOT NULL, PRIMARY KEY (ID), UNIQUE (link_url) ) ENGINE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[yellow1912]

Hi ,
now I get this error message
1064 You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1
in:
[CREATE TABLE IF NOT EXISTS links_aliases ( id int(10) NOT NULL auto_increment, link_url varchar(255) NOT NULL, link_alias varchar(255) NOT NULL, PRIMARY KEY (ID), UNIQUE (link_url) ) ENGINE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

A pretty annoying server configuration you have there :)

Go to admin/includes/module_installation/yellow1912_ssu/db/6.sql

Replace the whole content by:

DROP TABLE IF EXISTS links_aliases;

CREATE TABLE `links_aliases` (
`id` int(10) NOT NULL auto_increment,
`link_url` varchar(255) NOT NULL,
`link_alias` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `link_url` (`link_url`)
) TYPE=MyISAM;

[goldenhues]

Hi
done but nothing changed , to note , I didn't have 6.sql in the file but added it.