Loading Core Table Errors

dad7732 · Posted: Tue Oct 13, 2009 11:41 am

Ok, I forgot the fix ... Sad

Was it change "varchar(255)" to 256 in "installSQL.php"?

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 'collate latin1_general_ci NOT NULL, `id` int(11) NOT NULL, `mid

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) collate latin1_general_ci NOT NULL, `id` int(11) NOT NULL, `mid` int(11) NOT NULL, `lang` varchar(30) collate latin1_general_ci NOT NULL, `active` int(1) NOT NULL, `metavalue` text collate latin1_general_ci NOT NULL, PRIMARY KEY (`dhid`), KEY `levelsort` (`levelsort`,`title`,`id`,`mid`)) ENGINE=MyISAM;

Palbin · Posted: Tue Oct 13, 2009 12:19 pm

Are you upgrading or doing a fresh install?

dad7732 · Posted: Tue Oct 13, 2009 12:50 pm

Upgrade but then got the same thing on a fresh install as well

dad7732 · Posted: Tue Oct 13, 2009 1:25 pm

It was a test site anyway so it could have been a lot of things. But .. gonna do a fresh new install, DB and all from ground zero.

fkelly · Posted: Tue Oct 13, 2009 1:28 pm

The code in question is in rn_core.sql in the sql directory under the INSTALLATION directory. And it was not changed from 255 to 256. I just ran a local install and all worked fine. I wonder if you have all the collation sequences installed on your server?

The table nuke_seo_dh is the first one I can see in the rn_core.sql that has this collation code in it. I'm not sure if it is needed or not, someone with more expertise in the seo_dh tables would have to address that. You could edit it out and see if the program runs without it.

dad7732 · Posted: Tue Oct 13, 2009 1:46 pm

Fresh install from absolute scratch produces this error when running installSQL.php to load the core tables.

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 'collate latin1_general_ci NOT NULL, `id` int(11) NOT NULL, `mid

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) collate latin1_general_ci NOT NULL, `id` int(11) NOT NULL, `mid` int(11) NOT NULL, `lang` varchar(30) collate latin1_general_ci NOT NULL, `active` int(1) NOT NULL, `metavalue` text collate latin1_general_ci NOT NULL, PRIMARY KEY (`dhid`), KEY `levelsort` (`levelsort`,`title`,`id`,`mid`)) ENGINE=MyISAM;

I had this before and was given an answer that worked but I don't remember what it was ... Sad

Also, I have never had to deal with "latin1", etc. previously.

Cheers

Raven · Posted: Tue Oct 13, 2009 2:48 pm

Try removing all references to the collation.

Code:

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` text NOT NULL, PRIMARY KEY (`dhid`), KEY `levelsort` (`levelsort`,`title`,`id`,`mid`)) ENGINE=MyISAM;

dad7732 · Posted: Tue Oct 13, 2009 4:03 pm

Edited and used your code above and same error.

fkelly · Posted: Tue Oct 13, 2009 4:44 pm

The table after the one you are working on also has the latin collating sequence. Eliminate the collating sequence from that one also.

dad7732 · Posted: Tue Oct 13, 2009 5:15 pm

There are no instances any longer of "collate" anything and same error.

Palbin · Posted: Tue Oct 13, 2009 5:36 pm

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 'collate latin1_general_ci NOT NULL, `id` int(11) NOT NULL, `mid

This can not be the exact same error. What does it say now.

Raven · Posted: Tue Oct 13, 2009 5:40 pm

What version of MySQL are you using?

dad7732 · Posted: Tue Oct 13, 2009 5:41 pm

I meant the lower error pertaining to seo_dh

dad7732 · Posted: Tue Oct 13, 2009 5:47 pm

Server Version 4.0.27
Client Version 4.1.22

dad7732 · Posted: Tue Oct 13, 2009 5:48 pm

This can not be the exact same error. What does it say now.

I'll have to check again, forgot to copy it. Sad

dad7732 · Posted: Tue Oct 13, 2009 5:50 pm

Here is a fresh error:

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;

fkelly · Posted: Tue Oct 13, 2009 6:08 pm

In the rn_core.sql metavalue is defined as text. That seems to be missing from the code you quoted.

If that's not the problem then what I usually do is copy the code over into a SQL window in phpmyadmin and try to execute it on a test file and see if I get any enlightenment.

dad7732 · Posted: Tue Oct 13, 2009 6:11 pm

That's the code that Raven supplied above. I'll paste it in and see what turns up.

dad7732 · Posted: Tue Oct 13, 2009 6:13 pm

Pasted it in and:

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` ( `

fkelly · Posted: Tue Oct 13, 2009 6:18 pm

Code:

CREATE TABLE IF NOT EXISTS $prefix.`_seo_dh` (`dhid` int(11) NOT NULL auto_increment, `levelsort` int(1) NOT NULL, `title` varchar(255) collate latin1_general_ci NOT NULL, `id` int(11) NOT NULL, `mid` int(11) NOT NULL, `lang` varchar(30) collate latin1_general_ci NOT NULL, `active` int(1) NOT NULL, `metavalue` text collate latin1_general_ci NOT NULL, PRIMARY KEY (`dhid`), KEY `levelsort` (`levelsort`,`title`,`id`,`mid`)) ENGINE=MyISAM;

That's the code from rn_core.sql. Maybe in eliminating the latin1_general.ci Raven inadvertently deleted the 'text' definition of the metavalue field. Try it with that back in.

Even webmasters commit booboos.

dad7732 · Posted: Tue Oct 13, 2009 6:22 pm

using your code above:

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 'collate latin1_general_ci NOT NULL , `id` int( 11 ) NOT NU

Raven · Posted: Tue Oct 13, 2009 6:46 pm

dad7732 wrote:

That's the code that Raven supplied above. I'll paste it in and see what turns up.

I corrected my code above and tested the SQL and it works, however I'm not using the MySQL versions you are. Can't you upgrade? Our minimum version required/supported is 4.1 - See

Only registered users can see links on this board!
Get registered or login to the forums!

dad7732 · Posted: Tue Oct 13, 2009 7:00 pm

Verio VPS, can't upgrade until they do .. bummer.

dad7732 · Posted: Tue Oct 13, 2009 8:01 pm

Just checked with Verio and the current supported version is 5.0.75 and I remember upgrading a few years ago and was a real pain having to backup each DB, removing the old version, installing the new version and then reloading each DB ... yowza!! I "may" get them to do it, may take some convincing tho.

dad7732 · Posted: Mon Oct 19, 2009 6:46 am

Still doesn't work and since my VPS = VPS-2 the MySQL version I am running now:

Server Version 4.0.27
Client Version 4.1.22

I cannot upgrade unless I upgrade to VPS-3 which I am NOT doing, why fix something that ain't broke with over 30 domains running. Migrating to VPS-3 is a royal PIA that I don't have the time to do at this time.

There must be another way to get this SEO DB/Table installed without having to upgrade MySQL.

Cheers