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:
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
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:
|
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
Comment