tutorial problem discussionforumswithphp

[parthrpatel80]

Hi,
I just went through your discussion forum tutorial and got an error with first database querry

CREATE TABLE posts (
    ID int(5) DEFAULT '0' NOT NULL auto_increment,
    TopicID int(5) DEFAULT '0' NOT NULL,
    Name varchar(50) NOT NULL,
    Email varchar(50) NOT NULL,
    Password varchar(50) NOT NULL,
    TimeStamp varchar(10) NOT NULL,
    Post text NOT NULL,
    PRIMARY KEY (ID)
 );

error is :

#1067 - Invalid default value for 'ID'

pls provide solution for this

my configuration is:

php version 5.5+
and using phpmyadmin for database work.

using xampp.

[Nepomuk]

Hi parthrpatel80 and welcome to bytes.com!

I don't know the tutorial but I have a guess as to why the above code doesn't work: for both ID and TopicID it expects an integer and you seem to be passing a string. Try the following:

CREATE TABLE posts (
ID int(5) DEFAULT 0 NOT NULL auto_increment,
TopicID int(5) DEFAULT 0 NOT NULL,
Name varchar(50) NOT NULL,
Email varchar(50) NOT NULL,
Password varchar(50) NOT NULL,
TimeStamp varchar(10) NOT NULL,
Post text NOT NULL,
PRIMARY KEY (ID)
);

Mind you, I haven't done any database stuff for a while and haven't tested it, so no promises. ;-)