Simple SEO URL (OLD version) [support thread]

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

goldenhues:

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

[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

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

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.

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.

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

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
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)

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.

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.
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;

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

If so, I assume you are on 2.9.6?

Overwrite 3.sql with this

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Simple SEO URL';

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\'),');

I noticed 5.sql and 3.sql have the same language is this the duplicate and is the latest command another duplicate as in 3.sql

goldenhues:

I noticed 5.sql and 3.sql have the same language is this the duplicate and is the latest command another duplicate as in 3.sql
No they are not the same :)

Hi
done but no change

goldenhues:

Hi
done but no change

Can you be more clear? What do you mean with no change?

Go into module manager, list all the modules and see what patch level SSU is currently at.

If you are using 2.9.6, then after that change you dont even have any sql query left that try to install the link_alias table, so you can not possibly have the same error unless:

1. you are not using 2.9.6, you are using 3+
2. your changes were not saved correctly.

it's beta 2.9.6 and it's the only module

I get a blank page now for domain.com/admin/ssu.php

Where do I find if I have the mod_rewrite file added to my Apache server? Where would it usually be located within my FTP site?

Hi Alan

yellow1912:

1. EZ page links are built correctly now

Could you confirm; is Ultimate SEO working okay with EZ-PAGES ?

For example;

"index.php?main_page=page&id=2" are changing to "page.html?id=2" but is it possible for these to change to the EZ-Page names.

Much appreciated as always.