A user on my forum was trying to submit a score of a game he was playing but after that there is a problem with the vbulletin database this is the error message
so if anyone clicks on arcade they get this message
PHP Code:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
LEFT JOIN user AS user ON user.userid = gamesessions.userid
LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='3cardpoker' AND score='1000') OR (gamename='acnebegone' AND score='8900') OR (gamename='aim' AND score='1134') OR (gamename='alchemy' AND score='1710') OR (gamename='alienattack' AND score='71') OR (gamename='alieninvasion' AND score='22') OR (gamename='aliens' AND score='18728') OR (gamename='alienterminator' AND score='12444') OR (gamename='altex' AND score='23') OR (gamename='applehunt' AND score='0') OR (gamename='arkanoid' AND score='91100') OR (gamename='asteroids' AND score='1180') OR (gamename='asteroids2000' AND score='2100') OR (gamename='asteroids2k3' AND score='2155') OR (gamename='autobahn' AND score='7214') OR (gamename='balloonbomber' AND score='33850') OR (gamename='balloonhunter' AND score='826') OR (gamename='bankrobbery' AND score='1520') OR (gamename='barbjump' AND score='96') OR (gamename='bartsws' AND score='165') OR (gamename='batpunch' AND score='1900') OR (gamename='bballistic' AND score='910') OR (gamename='bbobble' AND score='0') OR (gamename='bbountyhunter' AND score='300') OR (gamename='bigbirdhunting' AND score='90') OR (gamename='blackjack' AND score='2300') OR (gamename='blackjackbbt' AND score='21300') OR (gamename='bloodypingu' AND score='791') OR (gamename='bmxtricks' AND score='2300') OR (gamename='bombblast' AND score='9798') OR (gamename='bombjack' AND score='98900') OR (gamename='boogerflick' AND score='135') OR (gamename='boredmeeting' AND score='25') OR (gamename='bowling_tgfg' AND score='181') OR (gamename='breakout' AND score='15580') OR (gamename='bubbletrouble' AND score='9490') OR (gamename='bunnygrab' AND score='210') OR (gamename='burgertime' AND score='2150') OR (gamename='canyonglider' AND score='210') OR (gamename='cardriver' AND score='460') OR (gamename='castledefend' AND score='2960') OR (gamename='chicken' AND score='139') OR (gamename='chopper' AND score='476') OR (gamename='cityjumper' AND score='7') OR (gamename='commanderalien' AND score='160') OR (gamename='copforthis' AND score='30') OR (gamename='copter' AND score='1291') OR (gamename='counterstrike' AND score='7') OR (gamename='crabvb' AND score='0') OR (gamename='crazycars' AND score='8250') OR (gamename='crazyclosetsynergy' AND score='124') OR (gamename='crazyshuttle' AND score='3771') OR (gamename='cricket' AND score='39') OR (gamename='cricketcraziness' AND score='177') OR (gamename='ctdcurling' AND score='1528') OR (gamename='ctf' AND score='180') OR (gamename='cubshoot2' AND score='380') OR (gamename='curveball' AND score='15330') OR (gamename='desertbattle' AND score='2') OR (gamename='discdash' AND score='17721') OR (gamename='discoracer' AND score='2750') OR (gamename='donkeykong' AND score='3200') OR (gamename='donkeyrocket' AND score='6244') OR (gamename='dragrace' AND score='1550') OR (gamename='duckhunt' AND score='44000') OR (gamename='ducktracker' AND score='1000') OR (gamename='eggs' AND score='307') OR (gamename='energon' AND score='40') OR (gamename='equilibrium' AND score='581') OR (gamename='eskiv' AND score='35') OR (gamename='falldown' AND score='26169') OR (gamename='fastnfurious' AND score='15') OR (gamename='fishwater' AND score='1980') OR (gamename='flashbert' AND score='14975') OR (gamename='flashpoker' AND score='265') OR (gamename='flexicombat' AND score='1976') OR (gamename='flyplane' AND score='28') OR (gamename='frogger' AND score='118') OR (gamename='gandy' AND score='1425') OR (gamename='ggdrop' AND score='5') OR (gamename='graveyard' AND score='2010') OR (gamename='gwb' AND score='60') OR (gamename='hdefense' AND score='17500') OR (gamename='hexxagon' AND score='24') OR (gamename='himalayaya' AND score='178') OR (gamename='hls' AND score='1284196700') OR (gamename='homerun' AND score='66') OR (gamename='homerunrally' AND score='19') OR (gamename='iceberg' AND score='5') OR (gamename='iceracer' AND score='85025') OR (gamename='j20' AND score='45040') OR (gamename='jackpot' AND score='4020') OR (gamename='japbball' AND score='580') OR (gamename='juggler' AND score='27') OR (gamename='karts' AND score='500') OR (gamename='kf9000' AND score='90') OR (gamename='kickups' AND score='20') OR (gamename='lanebowling' AND score='208') OR (gamename='lawnpac' AND score='875') OR (gamename='lookalive' AND score='129') OR (gamename='madshark' AND score='0') OR (gamename='maeda' AND score='2900') OR (gamename='magicball' AND score='7') OR (gamename='mariomushroom' AND score='2') OR (gamename='marspatrol' AND score='700') OR (gamename='mcsnake' AND score='2') OR (gamename='minikickups' AND score='9') OR (gamename='minipool2' AND score='2101') OR (gamename='moneymoneymoney' AND score='640') OR (gamename='monkeyjump' AND score='281') OR (gamename='monkeylander' AND score='16295') OR (gamename='moonpatrol' AND score='3500') OR (gamename='mosquitokill' AND score='525') OR (gamename='mspacman' AND score='5900') OR (gamename='mumu' AND score='93') OR (gamename='netblazer3d' AND score='3') OR (gamename='notjustcricket' AND score='6950') OR (gamename='ollie' AND score='70') OR (gamename='pacman' AND score='23580') OR (gamename='parachutepanic' AND score='37') OR (gamename='penguin' AND score='3171') OR (gamename='ping' AND score='15') OR (gamename='plasmanautonfire' AND score='31') OR (gamename='plasticsaucer' AND score='1578') OR (gamename='plops' AND score='1475') OR (gamename='pooljam' AND score='22260') OR (gamename='popupkill' AND score='17') OR (gamename='qb_challenge' AND score='115') OR (gamename='qmanoids' AND score='370') OR (gamename='rabbithunter' AND score='40') OR (gamename='ratmanralph' AND score='750') OR (gamename='rocketmx' AND score='8026') OR (gamename='roflattack' AND score='11880') OR (gamename='ropewalker' AND score='61') OR (gamename='runandgun' AND score='46') OR (gamename='runsamrun' AND score='133') OR (gamename='seafishing' AND score='3608') OR (gamename='secondsofmadness' AND score='125') OR (gamename='shapegame' AND score='0') OR (gamename='skeletonpark' AND score='22') OR (gamename='smacktherabbit' AND score='23') OR (gamename='smaug' AND score='1331') OR (gamename='snake' AND score='1693') OR (gamename='snakeman' AND score='1050') OR (gamename='snorkel' AND score='4400') OR (gamename='soaker' AND score='29') OR (gamename='sonic' AND score='18130') OR (gamename='spaceinvaders' AND score='2440') OR (gamename='spacerunner' AND score='281') OR (gamename='spankthemonkey' AND score='848') OR (gamename='squidhunter' AND score='141') OR (gamename='starcastle' AND score='4790') OR (gamename='submarine' AND score='44') OR (gamename='suicidebob' AND score='12974') OR (gamename='superhackysack' AND score='1144') OR (gamename='superrampage3' AND score='27') OR (gamename='tetris' AND score='632') OR (gamename='threedsuper' AND score='15') OR (gamename='tobyandkiki' AND score='0') OR (gamename='tramp2' AND score='60') OR (gamename='turkeyshoot' AND score='5400') OR (gamename='typingtest' AND score='82') OR (gamename='ufoshoot' AND score='13450') OR (gamename='vbtetris' AND score='2963') OR (gamename='vforce' AND score='760') OR (gamename='wariniraq' AND score='1') OR (gamename='watchout' AND score='63') OR (gamename='witchhunt' AND score='0') OR (gamename='wormrace' AND score='1050') OR (gamename='wot' AND score='12') OR (gamename='yetisports1t' AND score='1375') OR (gamename='yetisports2t' AND score='561') OR (gamename='yetisports3t' AND score='1451') OR (gamename='yetisports4t' AND score='3793') OR (gamename='yetisports5t' AND score='1959') OR (gamename='yetisports6t' AND score='6758') OR (gamename='yetisports7t' AND score='5083') OR (gamename='ylympics' AND score='2375') OR (gamename='zelda' AND score='27750') AND sessiontype=1 ORDER BY gamesessions.gamename DESC
mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Tuesday 18th of January 2005 12:44:46 AM
Script: http://www.k2pk.com/forum/arcade.php?
Referer: http://www.k2pk.com/
anyone know how I can fix this problem ?
More Information