MyBB Community Forums

Tried to make a new category:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1264 - Out of range value adjusted for column 'pid' at row 1
Query:
    INSERT INTO mybb_forums (`name`,`description`,`linkto`,`type`,`pid`,`parentlist`,`disporder`,`active`,`open`,`allowhtml`,`allowmycode`,`allowsmilies`,`allowimgcode`,`allowpicons`,`allowtratings`,`usepostcounts`,`password`,`showinjump`,`modposts`,`modthreads`,`mod_edit_posts`,`modattachments`,`style`,`overridestyle`,`rulestype`,`rulestitle`,`rules`,`defaultdatecut`,`defaultsortby`,`defaultsortorder`) VALUES ('category 2','','','c','-1','','1','1','1','0','1','1','1','1','1','1','','1','0','0','0','0','0','0','0','','','0','','') 

Try uploading this to admin/modules/forum/management.php and see if it fixes the problem.

Resulted with another error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1364 - Field 'parentlist' doesn't have a default value
Query:
    INSERT INTO mybb_forums (`name`,`description`,`linkto`,`type`,`pid`,`disporder`,`active`,`open`,`allowhtml`,`allowmycode`,`allowsmilies`,`allowimgcode`,`allowpicons`,`allowtratings`,`usepostcounts`,`password`,`showinjump`,`modposts`,`modthreads`,`mod_edit_posts`,`modattachments`,`style`,`overridestyle`,`rulestype`,`rulestitle`,`rules`,`defaultdatecut`,`defaultsortby`,`defaultsortorder`) VALUES ('cateogry 2','','','c','0','1','1','1','0','1','1','1','1','1','1','','1','0','0','0','0','0','0','0','','','0','','') 

If you can, please try disabling MySQL strict mode:
http://forum.mambo-foundation.org/showth...hp?p=24856

You may need to ask your webhost if you can do this.

This would work around this and probably other SQL errors you may encounter.

It's on my local machine. I'll work on that soon.