vb.org Archive - MySQL Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)

- - MySQL Error (https://vborg.vbsupport.ru/showthread.php?t=156335)

graham_w

08-26-2007 09:49 PM

MySQL Error

Getting this MySQL error after an upgrade to the latest ibProArcade and VBulletin 3.6.8

Quote:

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:

All times are GMT. The time now is 05:12 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01233 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: