MyBB Community Forums

A user reported that he gets an SQL error when setting the permissions for a forum:

Quote:SQL Error:
1366 - Incorrect integer value: '' for column 'canviewthreads' at row 1
Query:
INSERT INTO mybb_forumpermissions (fid,gid,canview,canviewthreads,candlattachments,canpostthreads,can ​ postreplys,canpostattachments,canratethreads,caneditposts,candeleteposts ​,candeletethreads,caneditattachments,canpostpolls,canvotepolls,cansear ​ch) VALUES ('15','5','0','','','0','0','0','','','','','','0','','')

I think he's running MySQL in strict mode but I'm not 100% sure as he did not respond.

I'm pretty sure this is duplicate

Really? I cannot find another bug report about this.

Yeah, there are some thread about this error but not on this case of the permissions, I've searched also with google.

In the previous threads it's always mentioned that this problem occur only because of the strict mode

Yes, this is duplicate of internal ticket #166. Different occurrences of the bug, but still fixed with the same fix.