Bug Database error - ?

[bosss]

Just get this database error and never before - maybe You Fillip H. have some tips?

Database error in vBulletin 4.2.3 Beta 3:

Invalid SQL:
UPDATE user SET dbtech_vbarcade_matchcount = dbtech_vbarcade_matchcount - 1 WHERE userid = 3;

MySQL Error   : BIGINT UNSIGNED value is out of range in '(`mylibarc_mylibar`.`user`.`dbtech_vbarcade_matchcount` - 1)'
Error Number  : 1690
Request Date  : Saturday, January 17th 2015 @ 01:16:55 PM
Error Date    : Saturday, January 17th 2015 @ 01:16:56 PM
Script        : http://www.mysite.com/forum/cron.php?rand=1421525809
Referrer      : http://www.mysite.com/forum/arcade.php
IP Address    : 62.113.18.242
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :

Maybe some settings caused that - do not know

regards

Bosss

 

[bosss]

Please Fillip H. some help - get many database error messages with same text

Database error in vBulletin 4.2.3 Beta 3:

Invalid SQL:
UPDATE user SET dbtech_vbarcade_matchcount = dbtech_vbarcade_matchcount - 1 WHERE userid = 3;

MySQL Error   : BIGINT UNSIGNED value is out of range in '(`mylibarc_mylibar`.`user`.`dbtech_vbarcade_matchcount` - 1)'
Error Number  : 1690
Request Date  : Sunday, January 18th 2015 @ 05:20:41 AM
Error Date    : Sunday, January 18th 2015 @ 05:20:41 AM
Script        : http://www.mysite.com/forum/cron.php?rand=1421583639
Referrer      : http://www.mysite.com/forum/login.php?do=login
IP Address    : 46.234.87.62
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :

have you some tips?

regards

bosss

 

[Fillip H.]

You can run

UPDATE user SET dbtech_vbarcade_matchcount = dbtech_vbarcade_matchcount + 1 WHERE userid = 3

in order to make that specific error go away.

 

[bosss]

I will try - why that error come? do you know why and what caused that?

regards

bosss

 

[bosss]

Errors stoped - thanks Fillip H.!

that was one pending friendly tournament - maybe that caused errors?

regards

bosss