PDA

View Full Version : MySQL Error


graham_w
08-26-2007, 09:49 PM
Getting this MySQL error after an upgrade to the latest ibProArcade and VBulletin 3.6.8

mySQL query error: UPDATE tournament_players_statut SET statut='3' WHERE tid='500' AND mid=

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mySQL error code:
Date: Monday 27th 2007f August 2007 08:47:04 AM

Server is Linux running PHP 5.2.3

Please PM or email me if you need more info.

MrZeropage
08-27-2007, 05:33 AM
when does this happen ? Can this be reproduced ?

graham_w
08-27-2007, 07:12 AM
It's on all pages of the Arcade - cannot use the Arcade at all.

The other day I upgraded the Arcade to 2.6.3a from 2.5.6 (I think - very certain it was in the 2.5.x release - been a bit slack updating)and i'm certain I checked after the install and the arcade was working fine. I then did a Vbulletin upgrade from 3.6.4 to 3.6.8 and I didn't check to see if the arcade was still working, but the guy I did the upgrade for emailed me this morning to tell me the arcade was throwing the error.

I redownloaded the arcade zip file and reinstalled, still the same.

Thanks,
Graham

MrZeropage
08-27-2007, 09:59 AM
please provide access to AdminCP + FTP and I will fix this ...

graham_w
08-27-2007, 10:25 AM
Thanks, details sent via PM.

MrZeropage
08-27-2007, 02:02 PM
problem fixed ... were some totally corrupted tournaments with invalid database-entries

graham_w
08-28-2007, 11:18 PM
Thank you for your help with this - all fixed :)

Cheers :up::up: