| Author |
Message |
dad7732
RavenNuke(tm) Development Team
Joined: Mar 18, 2007
Posts: 1242
|
 Posted:
Tue Oct 13, 2009 11:41 am |
|
Ok, I forgot the fix ... 
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
Site Admin
Joined: Mar 30, 2006
Posts: 2583
Location: Pittsburgh, Pennsylvania
|
| Posted:
Tue Oct 13, 2009 12:19 pm |
|
Are you upgrading or doing a fresh install? |
_________________
"Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it." — Brian W. Kernighan. |
|
|
|
|
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
Former Moderator in Good Standing
Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY
|
| 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 ...
Also, I have never had to deal with "latin1", etc. previously.
Cheers |
| |
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 17088
|
| 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;
|
|
Last edited by Raven on Tue Oct 13, 2009 6:43 pm; edited 1 time in total |
|
|
|
|
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. |
| |
|
|
|
|
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 http://rnwiki.ravennuke.com/wiki/RavenNuke2:About |
| |
|
|
|
|
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 |
| |
|
|
|
|
|
|
![[Valid RSS]](https://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
