vBulletin Database Error! when making new forum post.

[Aquawinds]

When making a new post in the forum we receive this error:

Database error in vBulletin 4.2.3:

Invalid SQL:
UPDATE forum SET
threadcount = threadcount - 1,
replycount = replycount - 1
WHERE forumid = 3;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`aquawi5_vbulletin4`.`forum` .`threadcount` - 1)'
Error Number : 1690
Request Date : Sunday, July 5th 2015 @ 05:03:21 PM
Error Date : Sunday, July 5th 2015 @ 05:03:21 PM
Script : http://www.aquawinds.com/forums/cont...ms-of-Use/edit
Referrer : http://www.aquawinds.com/forums/cont...ms-of-Use/edit
Classname : vB_Database
MySQL Version : 5.6.23
PHP Version: 5.4.41


The


Addons:

vbshop
vbsuper PMs
vbarcade
vbactivity
forumon
deluxe II
vbshout
vbsecurity
vaultWiki
Post Templates
Thread / Post Bookmarking
Staff Only Hidden Posts
Member Map
Draft Posts
Follow User
Auto Discussion Thread Creator
Easy Article Management (beta)
Tweet Poster
Threads Auto Close
Advanced Censor Options
Original Poster in Postbit
vBPhrases
DragonByte Private Text in Posts
Default Staff Signature
Logo Rotation
Banned From Reporting
Guest PM Notice


We are using the default style.

[Wayne Luke]

By default we don't use any bigint fields. Plus the query looks like it is deleting a thread, not adding one. You'll need to disable your addons one at a time until the error goes away. Then you can contact the addon developer for a fix.

[Aquawinds]

Thanks! Will do.

[Revelnode]

Hate to reopen this, but I am getting this in vB4.2.5, fresh install, no plug-ins, only a theme addition. I had asked to add all the cms content, then removed all content afterwards. I am now trying to edit an article on the home page and I get the same error. It DOES update the article, but upon "save" or "apply" it sends me to the error page and emails me the following.

Database error in vBulletin 4.2.5:

Invalid SQL:
UPDATE nbgvb4_forum SET
threadcount = threadcount - 1,
replycount = replycount - 1
WHERE forumid = 3;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`mkoster_nbg_vb4`.`nbgvb4_forum`.`threadcount` - 1)'
Error Number : 1690
Request Date : Thursday, August 24th 2017 @ 07:55:21 PM
Error Date : Thursday, August 24th 2017 @ 07:55:21 PM
Script : http://www.neutralbattlegrounds.com/.../117-Site-Redo
Referrer : https://www.neutralbattlegrounds.com...Site-Redo/edit
IP Address : 216.98.56.20
Username : Revelnode
Classname : vB_Database_MySQLi
MySQL Version : 5.5.52-MariaDB
Server : 45.77.78.16
User Agent :


Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 446
#2 vB_Database->query_write() called in [path]/includes/class_dm.php on line 649
#3 vB_DataManager->db_update() called in [path]/includes/class_dm.php on line 907
#4 vB_DataManager->save() called in [path]/includes/class_dm_forum.php on line 508
#5 vB_DataManager_Forum->save() called in [path]/vb/legacy/forum.php on line 204
#6 vB_Legacy_Forum->decrement_threadcount() called in [path]/vb/legacy/thread.php on line 480
#7 vB_Legacy_Thread->delete_internal() called in [path]/vb/legacy/thread.php on line 442
#8 vB_Legacy_Thread->soft_delete() called in [path]/packages/vbcms/dm/node.php on line 1109
#9 vBCms_DM_Node->postSave() called in [path]/packages/vbcms/dm/article.php on line 178
#10 vBCms_DM_Article->postSave() called in [path]/vb/dm.php on line 921
#11 vB_DM->save() called in [path]/packages/vbcms/dm/node.php on line 427
#12 vBCms_DM_Node->saveFromForm() called in [path]/packages/vbcms/content/article.php on line 1234
#13 vBCms_Content_Article->saveData() called in [path]/packages/vbcms/content/article.php on line 457
#14 vBCms_Content_Article->populateViewContent() called in [path]/vb/content.php on line 313
#15 vB_Content->getPageView() called in [path]/packages/vbcms/controller/content.php on line 191
#16 vBCms_Controller_Content->actionView() called in on line
#17 call_user_func_array() called in [path]/vb/controller.php on line 261
#18 vB_Controller->getResponse() called in [path]/packages/vbcms/route/content.php on line 97
#19 vBCms_Route_Content->getResponse() called in [path]/vb/router.php on line 251
#20 vB_Router::getResponse() called in [path]/vb/bootstrap.php on line 58
#21 require_once([path]/vb/bootstrap.php) called in [path]/content.php on line 30

[Wayne Luke]

You shouldn't be able to set threadcount and replycount to negative numbers. Did you delete all the comment threads from your comment forum before deleting the CMS content? vBulletin 4 uses a hidden forum to hold comments for articles.

After looking at your forum installation, I suggest reinstalling and choosing "No" when it asks if you want to import the default CMS content. It would be the easiest way to fix this issue on your site since there is no content yet.

[Revelnode]

You shouldn't be able to set threadcount and replycount to negative numbers. Did you delete all the comment threads from your comment forum before deleting the CMS content? vBulletin 4 uses a hidden forum to hold comments for articles.

Ahhhh, yeah no, I didn't do that... I will do a reinstall and do as you suggested and NOT add the content.
Thank you for the help.

Rev.

[Revelnode]

Ok, the only issue with this, is all the widgets layouts are gone. any way to import these separately?

[Wayne Luke]

You can recreate the layouts in the AdminCP under CMS -> Layout Manager. All the default widgets will still be available.