Snake Posted October 25, 2009 Posted October 25, 2009 QUERY ERROR: Lost connection to MySQL server during query Query was UPDATE `userstats` SET `agility` = `agility` + 138.382881365 WHERE `userid` = 1 I GET THIS WHEN I TRY AND TRAIN ANY OF MY STATS....A SIMILAR ERROR HAPPENS WITH EACH STAT I TRY AND TRAIN IN....IF SOMEBODY HAS ANY IDEA HOW TO FIX THIS WOULD BE GREATLY APPRECIATED UPDATE `dbname`.`userstats`....this is already in my gym.php,and i still get the same error,in all stats i try and train.....starting over with all fresh files uploaded into the server,and starting the install and all that still didn't help fix the problem....any ideas would be great :thumbsup: Quote
Danny696 Posted October 25, 2009 Posted October 25, 2009 try doing something like: UPDATE `dbname`.`userstats` Quote
Snake Posted October 25, 2009 Author Posted October 25, 2009 Gym Error UPDATE `dbname`.`userstats` and where would i put this at? ?( Quote
corruptcity || skalman Posted October 25, 2009 Posted October 25, 2009 between the words $db=>query (" and "; lol Quote
Snake Posted October 25, 2009 Author Posted October 25, 2009 Gym Error between the words $db=>query (" and "; lol QUERY 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 Query was UPDATE `dbname`.`userstats` now i get this crap....not sure where to put what you said....i'm think the gym.php.....i put it in between the "",and got this error Quote
Nickson Posted October 26, 2009 Posted October 26, 2009 Posting the lines where this error happens always helps. You've already posted the error description, but honestly, the more information we have, the better it is. The first querry error was "connection lost to mysql server", the second querry error was "syntax error". As you can see, both are different errors already. Please post all information regarding to the first query you are trying to use, but ONLY that, we don't need the whole file for inspection. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.