Snake Posted October 25, 2009 Share 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 Link to comment Share on other sites More sharing options...
Danny696 Posted October 25, 2009 Share Posted October 25, 2009 try doing something like: UPDATE `dbname`.`userstats` Quote Link to comment Share on other sites More sharing options...
Snake Posted October 25, 2009 Author Share Posted October 25, 2009 Gym Error UPDATE `dbname`.`userstats` and where would i put this at? ?( Quote Link to comment Share on other sites More sharing options...
corruptcity || skalman Posted October 25, 2009 Share Posted October 25, 2009 between the words $db=>query (" and "; lol Quote Link to comment Share on other sites More sharing options...
Snake Posted October 25, 2009 Author Share 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 Link to comment Share on other sites More sharing options...
Nickson Posted October 26, 2009 Share 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 Link to comment Share on other sites More sharing options...
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.