Simple SEO URL (OLD version) [support thread]

[CoolCarPartsOnline]

Under links_aliases field there is
id
link_url
link_alias
status
alias_type
referring_id
permanent_link

They are not unique keys. Should I delete link_url and link_alias?

Hey Country if you get this mod to work would you let me know how you did it. I just installed this mod 4 weeks ago on a different site and it worked fine till I start using the currency conversion when I start getting all kinds of error. I went to install it today and its a whole new files and structure. I am not sure why there is a new version almost every week.

[countrycharm]

I think we will get there someday. My data base is telling me that
#1071 - Specified key was too long; max key length is 1000 bytes
ALTER TABLE `links_aliases` ADD UNIQUE `link_url` ( `link_url` , `link_alias` ) ;

[countrycharm]

Thank you yellow for your help on this problem I was having upgrading. By dropping the links_aliases table in phpmyadmin and using the code you gave me work like a charm. Thank you again. I will let you know if the cron job work tomorrow. I have it set to run twice an hour.

[xordox]

Hello yellow1912!
after a little war in Israel, I'm back and ready to TEST :)

[yellow1912]

Hello yellow1912!
after a little war in Israel, I'm back and ready to TEST :)

Hi xordox, I'm very sorry to hear about that. And it's great to see you are back.

[xordox]

Yellow,
I try to upgrade ssu to 3.6.3. but got error:

1071 Specified key was too long; max key length is 1000 bytes
in:
[ALTER TABLE links_aliases ADD UNIQUE link_url ( link_url , link_alias );]

I try to do it ( ALTER TABLE `links_aliases` ADD UNIQUE `link_url` ( `link_url` , `link_alias` ); ) by differents way, but no luck
Please tell me how I can resolve it?

[yellow1912]

This is what you can do:

drop the table, the run this (if you run on phpmyadmin, add the prefix to the table name)

REATE TABLE IF NOT EXISTS `links_aliases` (
`id` int(10) NOT NULL auto_increment,
`link_url` varchar(255) NOT NULL default '',
`link_alias` varchar(255) NOT NULL default '',
`status` tinyint(1) unsigned NOT NULL default '1',
`alias_type` varchar(100) NOT NULL default 'none',
`referring_id` int(10) NOT NULL default '0',
`permanent_link` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `link_url` (`link_url`,`link_alias`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Then go to module_version_tracker table and manually change SSU to patch 14. I will now investigate why the alter command in the new patch always cause some problem.

[xordox]

I just upgrade ssu to 3.6.3, the problem was in "collation" :
when it was :
link_url varchar(255) utf8_general_ci
link_alias varchar(255) utf8_general_ci
I got this error:
1071 Specified key was too long; max key length is 1000 bytes

When I changed to :
link_url varchar(255) latin1_swedish_ci
link_alias varchar(255) latin1_swedish_ci
I got:
Warning Your module needs to be upgraded
Success 3 statements processed.
Success Upgraded database to patch level 14
Please tell me can I now change back to utf8_general_ci ?

[yellow1912]

ahh, I see, but actually you can use utf8 since you may want to have some special utf8 alias in that, Just drop the unique key pair is okie, I'm changing the code a bit so that the "unique" checking will be done in php instead, this will avoid having to do this check in mysql

Regards

Raine

[xordox]

Yellow,
I try to use ssu 3.6.3, and have some questions:
1. when I set SSU Multi Language Status to true it make 301 redirect (from www.site.com to www.site.com/en) I think its not good for google.
when I turn off it and set Language Selector to Default instead browser, the 301 redirection are dissapear, but how to fix next problem:
when I open the site I got:
www.site.com
when I change the language I got:
www.site.com/index/language/ru
how to change it to
www.site.com/ru?