Simple SEO URL (OLD version) [support thread]

[countrycharm]

Yellow I was getting a error like this

1146 Table 'coolcarp_precutcartint.eztpl_links_aliases' doesn't exist
in:
[show index from eztpl_links_aliases]
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.

You said

oops, sorry the db file has some table prefix i forgot to remove.

I downloaded a new package of ssu_beta_3.6.3 re=uploaded the admin and now I'm getting this

1091 Can't DROP 'link_url'; check that column/key exists
in:
[ALTER TABLE links_aliases DROP INDEX link_url;]
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.

What am I missing. Thank you.

[yellow1912]

I think I should use alter ignore just to be safe i guess, since the db may be different, try to run this on your patch tool real quikck

ALTER TABLE `links_aliases` ADD UNIQUE (`link_url`);

Then go back and try the upgrade.

[countrycharm]

Thanks for your help. After I went to admin/tools/install sql patches and installed the code you just gave me it say the same thing when I try to upgrade again.

1091 Can't DROP 'link_url'; check that column/key exists
in:
[ALTER TABLE links_aliases DROP INDEX link_url;]
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]

Weird, okie what if you go to admin/includes/module_installation/yellow1912_ssu/db/14.sql

And remove the first line
ALTER TABLE `links_aliases` DROP INDEX `link_url`;

Thank you for letting me know about this btw, I have a feeling the alter command will not work for some reason.

Thanks for your help. After I went to admin/tools/install sql patches and installed the code you just gave me it say the same thing when I try to upgrade again.

1091 Can't DROP 'link_url'; check that column/key exists
in:
[ALTER TABLE links_aliases DROP INDEX link_url;]
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.

[countrycharm]

After I removed
ALTER TABLE `links_aliases` DROP INDEX `link_url`;

I get this now

1091 Can't DROP 'link_alias'; check that column/key exists
in:
[ALTER TABLE links_aliases DROP INDEX link_alias;]
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]

Well, 14.sql does this:
drop the 2 current unique key, then add a new pair of unique key. This will let the link alias functions properly. I have just tested on my own datbase and it works out without error, so it is strange why it doesnt run on your site.

I guess the fastest way to do it is: if you can access your phpmyadmin, you have to check table link alias, and make sure link_url and link_alias are not unique keys, after that you want to add this new unique key:

ALTER TABLE `links_aliases` ADD UNIQUE `link_url` ( `link_url` , `link_alias` );
If you run via phpmyadmin, make sure you add table prefix if needed.

After that, go to table module_version_tracker and manually set the ssu patch level to 14.

This database change will allow alias to functions properly, and after adding the new unique key pair then the site will work fine again.

[countrycharm]

What do you mean by are not unique keys. Sorry it's getting late here...lol

[yellow1912]

What do you mean by are not unique keys. Sorry it's getting late here...lol

When you view that table structure in phpmyadmin, under
Indexes:

"id" is the only index you should see (before you add the new key pair)

[countrycharm]

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?

[yellow1912]

http://img16.imageshack.us/my.php?image=79770423.png