Loading Core Table Errors

fkelly · Posted: Mon Oct 19, 2009 6:52 am

There are two SEO related tables that have that latin collating code in them. Did you remove all instances of it?

dad7732 · Posted: Mon Oct 19, 2009 7:02 am

In the rn_core.sql ?? yes, I removed both and still the core won't load showing the SEO error at the bottom of the page.

dad7732 · Posted: Mon Oct 19, 2009 7:09 am

This is the error at the bottom of the page:

Quote:

The exact error message that your MySQL server reported is:
MySQL Error # 4 at line 117 in file installSQL.php ==> You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, PRIMARY KEY (`dhid`), KEY `levelsort` (`levelsort`,`t

Error in rn_core.sql at line 940:
CREATE TABLE IF NOT EXISTS `nuke_seo_dh` (`dhid` int(11) NOT NULL auto_increment, `levelsort` int(1) NOT NULL, `title` varchar(255) NOT NULL, `id` int(11) NOT NULL, `mid` int(11) NOT NULL, `lang` varchar(30) NOT NULL, `active` int(1) NOT NULL, `metavalue` NOT NULL, PRIMARY KEY (`dhid`), KEY `levelsort` (`levelsort`,`title`,`id`,`mid`)) ENGINE=MyISAM;

I'll try editing the original file again, maybe I removed too much or a typo, who knows.

Cheers

dad7732 · Posted: Mon Oct 19, 2009 7:27 am

Found the problem and of course it was a USER problem. I was removing too much along with the collate rather than JUST the collate latin text. Re-edited the original and now it works, core tables loaded and SEO works now to generate the meta tags, etc.

Cheers