phpMyAdmin errors

Guest

Getting the following error with phpMyAdmin:

Code:

Error

SQL-query :

CREATE TABLE nuke_comments(
tid int( 11 ) NOT NULL auto_increment,
pid int( 11 ) default '0',
sid int( 11 ) default '0',
date datetime default NULL ,
name varchar( 60 ) NOT NULL default '',
email varchar( 60 ) default NULL ,
url varchar( 60 ) default NULL ,
host_name varchar( 60 ) default NULL ,
subject varchar( 85 ) NOT NULL default '',
COMMENT text NOT NULL ,
score tinyint( 4 ) NOT NULL default '0',
reason tinyint( 4 ) NOT NULL default '0',
PRIMARY KEY ( tid ) ,
KEY tid( tid ) ,
KEY pid( pid ) ,
KEY sid( sid )
) TYPE = MYISAM

MySQL said:

Column 'pid' is used with UNIQUE or INDEX but is not defined as NOT NULL

Anyone got any ideas? I haven't modified the nuke.sql file at all.

Joined: Jan 31, 2004 Posts: -88

modify it and add NOT NULL before default next to the pid and sid fields

ArtificialIntel

Guest

Thanks, I got it but I had to modify about 10 others too.

What's with that Question

Guest

Wouldn't happen to be cos I am running PHP/4.0.3pl1 would it? Cos it's getting upgraded to 4.3.1 this weekend.

Few other things that might track down the soruce:

Apache/1.3.9
MySQL/3.22.30

Apache is also undergoing an upgrade this weekend, but as far as I know the MySQL ins't, if that's the prob.

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

You certainly are running old versions there.

Guest

I deleted index.php and admin.php right away:

http://www.losersinc.net/analyze.php