Simple SEO URL (OLD version) [support thread]

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

[yellow1912]

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

[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

[yellow1912]

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

[goldenhues]

Hi
done but no change

[yellow1912]

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.

[goldenhues]

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

[starruby]

Hi yellow,
Since I installed SSU, I am facing a problem. When on any product page, "Add to Cart" button is clicked, it takes me to the main page without adding the product to the cart and a message is shown saying "Your Shopping Cart is empty.". What is strange is that the shopping cart works perfectly sometimes but other times no products are added to the cart.

Store url: www.gemsoul.com

Any idea to the root of this problem?

Thanks,
Harshil