Unable to delete/remove 5 threads or more at once

[fernandofgg]

Hi community

vB Version 4.2.4

I am not able to delete/remove 5 threads or more at once
When I select 5, 10, 30, etc threads for deletion I get DB error
I got technical support from my hosting and they told me the following:

Hi Fernando, Thank you for your update, and your patience. I've been reviewing this issue, and it seems what's going on is the delete process is running a query to subtract '1' from the value of certain columns which have a default value of '0', and with the current mysql configuration and the configuration of this app's db tables negative integers cannot be placed into these particular columns. Basically, it comes down to how the vbulletin script is setting up the db tables in conjunction with the current mysql configuration. I would recommend contacting Vbulletin support or posting in their public forums regarding this matter to see if they already know of this issue or have a documented workaround. If that doesn't pan out then we can try changing the sql_mode on your server to 'NO_UNSIGNED_SUBTRACTION', which would then allow these negative values to be stored in these particular columns. I cannot speak to any other impact that it may have on your application(s), however, which is why I suggest first checking with Vbulletin support. The sql_mode could always be changed back in the event that this does cause unwanted behaviors, but I still feel it's best to check with the application vendor first before going with system-wide changes. I hope that this is helpful, and should you have any further questions or concerns at all, please don't hesitate to let us know. Regards, Jacob, | L3 Support Administrator

This is the error:

Invalid SQL:
UPDATE user SET post_thanks_user_amount = post_thanks_user_amount - 1, posts = posts - 1 WHERE userid IN (67629,42358,67632,72492,58907,2390,69499,69715,34972,69198,69636,27407,69553,38766,72224, 69381,69003,36500,69736,3026,70089,71986,4734,73530,62634,38349,69647,73082,72292);
MySQL Error : BIGINT UNSIGNED value is out of range in '(thecentr_tcb.user.posts - 1)'
Error Number : 1690
Request Date : Tuesday, February 26th 2019 @ 05:24:17 PM
Error Date : Tuesday, February 26th 2019 @ 05:24:18 PM
Script : http://www.thecentralbox.net/inlinem...readids=269707,34411,270037,269609,291177,268122,268513,267784,268294,117204,269117,230530,231631,268514 ,269116,268957,268562,268560
Referrer : http://www.thecentralbox.net/inlinemod.php
IP Address : 172.69.6.11
Username : The Box Team
Classname : vB_Database_MySQLi
MySQL Version : 5.6.41

---

IP Address: 201.141.38.233



Thanks in advance

[Wayne Luke]

The post count for the user can't be negative. For some reason, this is happening in this query.

You can try upgrading to vBulletin 4.2.5 to see if this resolves the issue. Updating user post counts should also be run in the AdminCP.

[fernandofgg]

The post count for the user can't be negative. For some reason, this is happening in this query.

You can try upgrading to vBulletin 4.2.5 to see if this resolves the issue. Updating user post counts should also be run in the AdminCP.

Thanks but I connot upgrade to 4.2.5 because MGC Chatbox Evo will stop working, and this chat is very important to me

Any other way?

[Wayne Luke]

Since you've edited the post counter field to a BIGINT (we ship with INT fields), then you can try to make it signed instead of unsigned in the database. This would allow users to have a negative post count.

Not sure why you would have had to change this since no user on your site should have reached the INT limit of over 4.29 billion posts.