SQL Installation problems

New Member Joined: Mar 16, 2006 Posts: 16

When running the installSQL.php, I get the following error message:

Quote:

ERROR! The exact error message that your MySQL server reported is You have an error in your SQL syntax near '; ' at line 1.

The Script also says:

Quote:

MySQL Database Connectivity Test Results

config.php file found!
Successfully connected to localhost as user thesimswarehouse and assigned password!
Database ******* found!

Can you shed any light?

registered · Posted: Thu Mar 16, 2006 2:53 pm

Please search these forums first as this has been addressed in other threads. Maybe a Google Search within this site using "The exact error message that your MySQL server reported".

Posted: Sun Mar 19, 2006 8:56 am

No, I've tried replacing the -- with ##, but I still get the same error message. Any ideas?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Remove all comments from the file and try it again.

Posted: Sun Mar 19, 2006 9:44 am

All comments removed - same problem, same error message. Example of SQL file:

Code:







DROP TABLE IF EXISTS `nuke_authors`;


CREATE TABLE `nuke_authors` ( `aid` varchar(25) NOT NULL default '', `name` varchar(50) default NULL, `url` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `pwd` varchar(40) default NULL, `counter` int(11) NOT NULL default '0', `radminsuper` tinyint(1) NOT NULL default '1', `admlanguage` varchar(30) NOT NULL default '', PRIMARY KEY  (`aid`) ) TYPE=MyISAM;





DROP TABLE IF EXISTS `nuke_autonews`;


CREATE TABLE `nuke_autonews` ( `anid` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `aid` varchar(25) NOT NULL default '', `title` varchar(80) NOT NULL default '', `time` varchar(19) NOT NULL default '', `hometext` text NOT NULL, `bodytext` text NOT NULL, `topic` int(3) NOT NULL default '1', `informant` varchar(25) NOT NULL default '', `notes` text NOT NULL, `ihome` int(1) NOT NULL default '0', `alanguage` varchar(30) NOT NULL default '', `acomm` int(1) NOT NULL default '0', `associated` text NOT NULL, PRIMARY KEY  (`anid`) ) TYPE=MyISAM;








DROP TABLE IF EXISTS `nuke_banned_ip`;


CREATE TABLE `nuke_banned_ip` ( `id` int(11) NOT NULL auto_increment, `ip_address` varchar(15) NOT NULL default '', `reason` varchar(255) NOT NULL default '', `date` date NOT NULL default '0000-00-00', PRIMARY KEY  (`id`) ) TYPE=MyISAM;

Posted: Sun Mar 19, 2006 9:45 am

I also imagine I'm going to get the UNIQUE/NOT NULL error message when I finally get this working... Rolling Eyes

Posted: Sun Mar 19, 2006 1:03 pm

What version of MySQL are you using?

Have you tried changing TYPE=MyISAM to ENGINE=MyISAM?

Also, a very easy way to really know what the error is is to run the query in phpMyAdmin. The error will be much more explicit Wink

Posted: Mon Mar 20, 2006 4:13 pm

I'm using PhpMyadmin now - it gets further that your installer script, but stalls at the subscriptions table. Error message is as follows:

Code:




Error





SQL-query : 





CREATE TABLE `nuke_subscriptions` (


`id` int( 10 ) NOT NULL AUTO_INCREMENT ,


`userid` int( 10 ) default '0',


`subscription_expire` varchar( 50 ) NOT NULL default '',


PRIMARY KEY `id` ( `id` , `userid` )


) TYPE = MYISAM





MySQL said: 





#1171 - All parts of a PRIMARY KEY must be NOT NULL;  If you need NULL in a key, use UNIQUE instead

Server info:
MySQL 3.23.58 on Linux

Posted: Mon Mar 20, 2006 4:22 pm

Change this line
`userid` int( 10 ) default '0',
to
`userid` int( 10 ) NOT NULL default '0',

I would HIGHLY recommend you upgrade your MySQL version to at least 4.0.25.

Posted: Mon Mar 20, 2006 7:38 pm

Raven,

I've decided to upgrade my MySQL instead of mucking about with changing scripts, mods... etc. I've upgraded to MySQL 4.0.23 and your GUI installation script works like a dream now.

I was reluctant to upgrade because the MySQL server is heavily used with several very important and profitable websites running from it. Also, I didnt fancy playing with MySQL 5 just yet.

Raven, apart from security fixes, are the any performance advantages of this newer version of MySQL that I'm running?

Posted: Mon Mar 20, 2006 7:50 pm

Oh yes. You need to consult the change logs at http://mysql.com to read the plethora of changes Smile

Posted: Wed Mar 22, 2006 5:36 am

Just letting you know that I split out the "for hire" portion of this thread to the "For Hire".