Bug Cant delete tourney in mid play

[Freekoid]

I created a brand new tournament and then deleted it straight away, no problem.

I tried deleting the other tournaments I have in ACP where at least one of the players has had a go/played their round.

This happens

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

MySQL Error   : BIGINT UNSIGNED value is out of range in '(`robbiez_hairywrinkledtestee`.`user`.`dbtech_vbarcade_matchcount` - 1)'
Error Number  : 1690
Request Date  : Saturday, June 30th 2012 @ 01:50:21 PM
Error Date    : Saturday, June 30th 2012 @ 01:50:21 PM
Script        : http://www.muppet-testee.info/test/admincp/arcade_admin.php?do=update_tourns
Referrer      : http://www.muppet-testee.info/test/admincp/arcade_admin.php?do=update_tourns
IP Address    : 86.13.197.237
Username      : TPB
Classname     : vB_Database
MySQL Version : 5.5.23-55

 

[skol]

Try running the queries individually and test again..

TRUNCATE TABLE dbtech_vbarcade_match
TRUNCATE TABLE dbtech_vbarcade_tourn
UPDATE user SET dbtech_vbarcade_matchcount = 0

Adding your table prefix if required..

 

[Freekoid]

Try running the queries individually and test again..

TRUNCATE TABLE dbtech_vbarcade_match
TRUNCATE TABLE dbtech_vbarcade_tourn
UPDATE user SET dbtech_vbarcade_matchcount = 0

Adding your table prefix if required..

In ACP > Maintenance > Execute SQL Query ?

 

[skol]

Yes,but run each line on it's own,or you'll get a error..

 

[Freekoid]

Yes,but run each line on it's own,or you'll get a error..

K, all 3 done seperately, all 4 tourneys (3 running, 1 not executed) all gone!

So that was what we would call a disc wipe so to speak?

 

[skol]

Yeah,it will get shut of everything...And give you a clean start.

 

[Darkwaltz4]

yeah, there was some notification bugs in revision #2 , fixed in #3 - but would remain until you cleared as above.

afterwards, try deleting again in all scenarios and let me know if you still have trouble

 

[Darkwaltz4]

Please let me know if this issue is now moot so i may close it

 

[Freekoid]

Sorry John..

Mid play

1. Delete using hyperlink. - Ok
2. Checked box, clicked 'Update Tournaments' and selected delete. - Ok

You can close thread