New with programming

**JGiannotti** · 04-13-2008, 11:03 PM

http://sourceforge.net/projects/wtfo/

I am trying to install this script on my server, but when I try to import the MySQL tables file in PHPmyadmin I get this error:

Error

SQL query:

#
# Table structure for table 'comments'
#
CREATE TABLE comments(
id int( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
user tinyint( 4 ) DEFAULT '0' NOT NULL ,
record date DEFAULT '0000-00-00' NOT NULL ,
comments text,
PRIMARY KEY ( id ) ,
KEY user( user, record )
);

MySQL said: Documentation
#1067 - Invalid default value for 'id'

Obviously the script is pretty old, but is the only of it's kind that I can find.

How can I fix this problem?

Thanks guys - your help is always appreciated!

**Gilligan** · 04-14-2008, 08:33 AM

I think if its auto_increment then there shouldn't be a default value. I'm not sure though

**GeorgeB** · 04-14-2008, 08:35 AM

Quote:

Originally Posted by Gilligan

I think if its auto_increment then there shouldn't be a default value. I'm not sure though

That's precisely right

**Gilligan** · 04-14-2008, 08:54 AM

sweet

My PHP and MySQL programming skills are increasing

**JGiannotti** · 04-14-2008, 01:25 PM

Awesome! Thanks for the info guys.

So should I just remove DEFAULT '0' from the sql file?

**Gilligan** · 04-14-2008, 02:53 PM

only for the id column.

Code:

 id int( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,

replace that with this:

Code:

 id int( 11 ) NOT NULL AUTO_INCREMENT ,

**JGiannotti** · 04-15-2008, 11:02 PM

Wow, thanks a bunch guys! Works great! Now I just have to install the graph system. http://www.aditus.nu/jpgraph/index.php is the graph system I'm using. For some reason nothing is being displayed on the graph page. I need a little more assistance. http://www.tampabodybuilding.net/log...eight&type=bar is just showing an image cannot be displayed square.

I may have the source written incorrectly on the config page:
$jpgraph_path = "/user/public_html/logs/src/";

It is all uploaded to my /logs/src/ directory though