1146 Tables error after installing ultimate SEO URLs.

[mariellen]

There is no SQL install file. It just prompts me to upload all of the files in the readme. I've looked for the answer in the SEO URLs thread, and nobody seems to have the same problem.

I had the same problem. The user I had set up my site with did not have permission to DROP/CREATE tables.

I just ran this script to create the table manually. There may be more stuff I need to run but for now it seems to be hunky dory.

CREATE TABLE seo_cache (
`cache_id` varchar(32) NOT NULL default '',
`cache_language_id` tinyint(1) NOT NULL default '0',
`cache_name` varchar(255) NOT NULL default '',
`cache_data` mediumtext NOT NULL,
`cache_global` tinyint(1) NOT NULL default '1',
`cache_gzip` tinyint(1) NOT NULL default '1',
`cache_method` varchar(20) NOT NULL default 'RETURN',
`cache_date` datetime NOT NULL default '0000-00-00 00:00:00',
`cache_expires` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY  (`cache_id`,`cache_language_id`),
KEY `cache_id` (`cache_id`),
KEY `cache_language_id` (`cache_language_id`),
KEY `cache_global` (`cache_global`)
) TYPE=MyISAM;

[mcpisik]

Ah yes, also had no table created, so ran the script.
Version 1.3.9 cart and so far so good....so thanks to all above.

[DontBlink7]

Man i'm trying to uninstall ultimate seo urls from my website, can you help me cause iv'e pulled out all the files and it's still there and now my websites down because it's still trying to access seo urls and the files arent there. HELP!!!!!

[dcwd]

Just in case there are any others of you who are experiencing this problem (because I did), the fix is EASY. Ultimate SEO URLs was supposed to create a table in the database called `seo_cache` or if you had a prefix it would be `prefix_seo_cache`.

In my database, it created a table called, `TABLE_SEO_CACHE` which was wrong, so I just changed the table name to `seo_cache` and then it worked perfectly.

This was EXTREMELY helpful!
Thanks so much!

[FiberDawn]

Hi.
Zen cart 1.3.9h
I just installed this Ultimate SEO mod and I also had a problem that the cache table was not created. Turns out the ~/includes/classes/seo.install.php file has TYPE=MyISAM on the create table statement.

I just took the create table ddl and altered it so I could run it from my php Admin, but it would probably work better for someone to change the MyISAM in the download and set it to MySQL (which I think is what most sites are using).

I'm not used to the mods auto-updating the db... I'm used to a separate SQL file that needs to be run as a specific step in the Install instructions. But I'm OK with it. I would suggest that the documentation be updated to say that it will be editing files in the Zen Cart DB. (or maybe I just missed that).

We usually like to know everything that is going to be changed.

Thanks for the mod.. will see how it works for me now. Testing first locally.

[adem.i]

Just in case there are any others of you who are experiencing this problem (because I did), the fix is EASY. Ultimate SEO URLs was supposed to create a table in the database called `seo_cache` or if you had a prefix it would be `prefix_seo_cache`.

In my database, it created a table called, `TABLE_SEO_CACHE` which was wrong, so I just changed the table name to `seo_cache` and then it worked perfectly.

Hi Prattski, just wondering how you searched your SQL database? I've copied over all the files, yet the link doesn't appear in the configuration drop down. Currently trying to troubleshoot, but don't have an extensive knowledge on php. Anyhelp would be appreciated,
thanks

[tracey]

Hi Prattski, just wondering how you searched your SQL database? I've copied over all the files, yet the link doesn't appear in the configuration drop down. Currently trying to troubleshoot, but don't have an extensive knowledge on php. Anyhelp would be appreciated,
thanks

Hi Adem.i,

This might be a bit late to answer your question, but in case anyone else is having the same problem I'll do my best to answer it.

If you can't see the Ultimate SEO URLs here: Admin >> Configuration >> Ultimate SEO URLs then this is related to these files:
_zen_cart_folder_English / includes / classes / seo.install.php
_zen_cart_folder_English / includes / classes / seo.url.php

If you have uploaded these files, and are seeing a blank screen when they are uploaded, then it's possibly a problem with the update to your database. Some of the files uploaded in the install are supposed to alter your database and it's possible that didn't happen correctly as mentioned earlier in this thread.

You can view your database by logging into your hosting account and selecting "phpMyAdmin":



Then you will see the list of "database tables":



Just run the following query, under the "SQL" tab. See original post #11 by Mariellen:

CREATE TABLE seo_cache (
`cache_id` varchar(32) NOT NULL default '',
`cache_language_id` tinyint(1) NOT NULL default '0',
`cache_name` varchar(255) NOT NULL default '',
`cache_data` mediumtext NOT NULL,
`cache_global` tinyint(1) NOT NULL default '1',
`cache_gzip` tinyint(1) NOT NULL default '1',
`cache_method` varchar(20) NOT NULL default 'RETURN',
`cache_date` datetime NOT NULL default '0000-00-00 00:00:00',
`cache_expires` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`cache_id`,`cache_language_id`),
KEY `cache_id` (`cache_id`),
KEY `cache_language_id` (`cache_language_id`),
KEY `cache_global` (`cache_global`)
) TYPE=MyISAM;

If that doesn't work, your PHP might be an older version, as was the case with my site.
Just change the last line from:
) TYPE=MyISAM;

to:
) ENGINE=MyISAM;

Then you should see this screen when you navigate here: Admin >> Configuration >> Ultimate SEO URLs



Hope that helps!

[divinelighting]

This is very disconcerting. Today my site was down with this very problem. What could have caused it? The only change I have made recently is to change configure files to always require https. Also, there is a nightly backup. It is possible it somehow the mod dropped the table?

Fortunately, this was able to solve the problem:

CREATE TABLE seo_cache (
`cache_id` varchar(32) NOT NULL default '',
`cache_language_id` tinyint(1) NOT NULL default '0',
`cache_name` varchar(255) NOT NULL default '',
`cache_data` mediumtext NOT NULL,
`cache_global` tinyint(1) NOT NULL default '1',
`cache_gzip` tinyint(1) NOT NULL default '1',
`cache_method` varchar(20) NOT NULL default 'RETURN',
`cache_date` datetime NOT NULL default '0000-00-00 00:00:00',
`cache_expires` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`cache_id`,`cache_language_id`),
KEY `cache_id` (`cache_id`),
KEY `cache_language_id` (`cache_language_id`),
KEY `cache_global` (`cache_global`)
) ENGINE=MyISAM;

[divinelighting]

More info on what could be the cause of missing seo table
http://www.zen-cart.com/showthread.p...30#post1159230

[divinelighting]

And to fix the problem, change /includes/classes/seo.install.php

near the end

        ) TYPE=MyISAM;"; 

to

        ) ENGINE=MyISAM;";