I could use some assistance please with this error. It happens anytime I edit an existing CMS Article post. Thanks.
Here is the error in full:
Database error in vBulletin 4.2.0:
Invalid SQL:
UPDATE forum SET
threadcount = threadcount – 1,
replycount = replycount – 1
WHERE forumid = 3;
MySQL Error : BIGINT UNSIGNED value is out of range in ‘(`muffin_maindb`.`forum`.`threadcount` – 1)’
Error Number : 1690
Request Date : Monday, August 20th 2012 @ 09:14:58 AM
Error Date : Monday, August 20th 2012 @ 09:14:59 AM
Script : [url] http://www.muffinpower.org/content.p…in-Power!/edit [/url]
Referrer : [url] http://www.muffinpower.org/content.p…in-Power!/edit [/url]
IP Address : 74.216.114.33
Username : Muffin
Classname : vB_Database
MySQL Version : 5.5.23-55
================================================
I found a temporary solution however, still not sure why I’m getting this error as the database was not modified since installation.
Setting Comments to YES resolves the issue and prevents the error.
Setting it to NO will reproduce the error.
This is only an issue when there is only one article post, and the comments are set to NO for it.
