MyBB Community Forums

Full Version: 1264 - Out of range value for column 'pid' at row 1
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Query:
INSERT INTO mybb_forums (`name`,`description`,`linkto`,`type`,`pid`,`parentlist`,`disporder`,`active`,`open`,`allowhtml`,`allowmycode`,`allowsmilies`,`allowimgcode`,`allowvideocode`,`allowpicons`,`allowtratings`,`usepostcounts`,`usethreadcounts`,`requireprefix`,`password`,`showinjump`,`style`,`overridestyle`,`rulestype`,`rulestitle`,`rules`,`deletedthreads`,`deletedposts`,`defaultdatecut`,`defaultsortby`,`defaultsortorder`,`icon`) VALUES ('test','','','c',-1,'','1','1','1','0','1','1','1','1','1','1','1','1','0','','1','0','0','0','','','0','0','0','','','folder.png')
Please contact the MyBB Group for technical support.

Occurs when trying to copy forum with forum type set to category

Fresh install with https://community.mybb.com/mods.php?action=view&pid=930 this them and https://community.mybb.com/mods.php?action=view&pid=916 this plugin 

plz help
There is a problem with the 5th value.

It must be 
'-1'
and if you look at what you paste, it's without the quotation marks.
Yep, this looks like a bug. That column is unsigned and the value -1 is being inserted.
Hi,

Thank you for your report. We have pushed this issue to our Github repository for further analysis where you can track our commits and progress with fixing this bug. Discussions regarding this bug may also take place there too.

Follow this link to visit the issue on Github: https://github.com/mybb/mybb/issues/2884

Thanks for contributing to MyBB!

Regards,
The MyBB Group