MyBB Community Forums
[Pushed] 1264 - Out of range value for column 'pid' at row 1 - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Development (https://community.mybb.com/forum-161.html)
+--- Forum: MyBB 1.8 Development (https://community.mybb.com/forum-165.html)
+---- Forum: 1.8 Bugs and Issues (https://community.mybb.com/forum-157.html)
+----- Forum: Pushed (https://community.mybb.com/forum-183.html)
+----- Thread: [Pushed] 1264 - Out of range value for column 'pid' at row 1 (/thread-213662.html)



1264 - Out of range value for column 'pid' at row 1 - 8guawong - 2017-10-19

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


RE: 1264 - Out of range value for column 'pid' at row 1 - NoRules - 2017-10-21

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.


RE: 1264 - Out of range value for column 'pid' at row 1 - Euan T - 2017-10-22

Yep, this looks like a bug. That column is unsigned and the value -1 is being inserted.


RE: 1264 - Out of range value for column 'pid' at row 1 - Euan T - 2017-10-22

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