I'm getting this error: Column 'id' cannot be null. I can't figure it out why.
I always Import the tables by using .sql into MyPHPAdmin. I only have 2 tables. One is mypost and the other username. For my .sql file I always have the same format with NOT NULL for all the data but this time around it doesn't work. I try to leave it out but I still get Column 'id' cannot be null
The only thing I always fill in is in the username table which is the username and password.
When I open the admin section and try to login this message pops up column 'id' cannot be null and also when I try to post something this message Column 'id' cannot be null pops up too.
I didn't put anything in the id section for mypost and username.
Here is my tables:
CREATE TABLE `mypost` ( `id` int(15) NOT NULL, `title` varchar(150) NOT NULL, `content` text NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `username` ( `id` int(15) NOT NULL, `username` varchar(25) NOT NULL, `password` varchar(250) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Any Suggestions and explanation why Column 'id' cannot be null pop up and how can I resolve. I appreciate it. Thanks!