Planet M.U.L.E.
Planet Mule 1 => Bugs 1.2.1-3 => Topic started by: C64 nostalgia on January 29, 2010, 12:13
|
Title: Server is still not tracking properly Post by: C64 nostalgia on January 29, 2010, 12:13 I attached the whole log, but here's where it starts doing something strange and a little bit more. The record of the game just vanished off of Planet MULE.
[This is a follow-up to my post in this thread: 1/28/10 - issue with Lobby and update -- http://www.planetmule.com/forum?topic=648.0] Quote INFO [MasterClient.logSend] MasterClient: Sending Start Game SEVERE [MasterClient.send] StartGame com.turborilla.mule.network.MasterResponseException: [/home/bokbl3/public_html/mule/server/start_game.php 48] 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 'WHERE id=17132 AND host_user_id=5547' at line 3 Response: error="[/home/bokbl3/public_html/mule/server/start_game.php 48] 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 'WHERE id=17132 AND host_user_id=5547' at line 3" at com.turborilla.mule.network.MasterResponse.read(Unknown Source) at com.turborilla.mule.network.MasterClient.send(Unknown Source) at com.turborilla.mule.network.MasterClient.access$500(Unknown Source) at com.turborilla.mule.network.MasterClient$MasterCommunicator.run(Unknown Source) at java.lang.Thread.run(Thread.java:613) INFO [MasterClient$RequestQueue.retry] Master Client: Retry send in 2000 ms SEVERE [MasterClient.send] StartGame com.turborilla.mule.network.MasterResponseException: [/home/bokbl3/public_html/mule/server/start_game.php 48] 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 'WHERE id=17132 AND host_user_id=5547' at line 3 Response: error="[/home/bokbl3/public_html/mule/server/start_game.php 48] 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 'WHERE id=17132 AND host_user_id=5547' at line 3" at com.turborilla.mule.network.MasterResponse.read(Unknown Source) at com.turborilla.mule.network.MasterClient.send(Unknown Source) at com.turborilla.mule.network.MasterClient.access$500(Unknown Source) at com.turborilla.mule.network.MasterClient$MasterCommunicator.run(Unknown Source) at java.lang.Thread.run(Thread.java:613) INFO [MasterClient$RequestQueue.retry] Master Client: Retry send in 3500 ms INFO [Client.receiveTCPMessages] Client: Ready (10) 8 bytes INFO [Client.receiveTCPMessages] Client: Ready (13) 8 bytes INFO [Client.receiveTCPMessages] Client: Ready (11) 8 bytes INFO [Client.receiveTCPMessages] Client: Ready (12) 8 bytes INFO [MuleGameContainer.logSkippedFrames] Skipped frames: 40 INFO [GameController.beginNextPhase] --------- INTRO #0 -------------------------------------------------------- INFO [Server.logRoundtrip] Roundtrips: <P10> 2ms <P11> 184ms <P12> 243ms <P13> 118ms INFO [Client.logRoundtripTime] Client: Roundtrip time is 2 ms SEVERE [MasterClient.send] StartGame com.turborilla.mule.network.MasterResponseException: [/home/bokbl3/public_html/mule/server/start_game.php 48] 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 'WHERE id=17132 AND host_user_id=5547' at line 3 Response: error="[/home/bokbl3/public_html/mule/server/start_game.php 48] 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 'WHERE id=17132 AND host_user_id=5547' at line 3" at com.turborilla.mule.network.MasterResponse.read(Unknown Source) at com.turborilla.mule.network.MasterClient.send(Unknown Source) at com.turborilla.mule.network.MasterClient.access$500(Unknown Source) at com.turborilla.mule.network.MasterClient$MasterCommunicator.run(Unknown Source) at java.lang.Thread.run(Thread.java:613) INFO [MasterClient$RequestQueue.retry] Master Client: Retry send in 6125 ms SEVERE [MasterClient.send] StartGame com.turborilla.mule.network.MasterResponseException: [/home/bokbl3/public_html/mule/server/start_game.php 48] 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 'WHERE id=17132 AND host_user_id=5547' at line 3 Response: error="[/home/bokbl3/public_html/mule/server/start_game.php 48] 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 'WHERE id=17132 AND host_user_id=5547' at line 3" at com.turborilla.mule.network.MasterResponse.read(Unknown Source) at com.turborilla.mule.network.MasterClient.send(Unknown Source) at com.turborilla.mule.network.MasterClient.access$500(Unknown Source) at com.turborilla.mule.network.MasterClient$MasterCommunicator.run(Unknown Source) at java.lang.Thread.run(Thread.java:613) INFO [MasterClient$RequestQueue.retry] Master Client: Retry send in 10718 ms INFO [Client.receiveTCPMessages] Client: Ready (10) 8 bytes INFO [Client.receiveTCPMessages] Client: Ready (13) 8 bytes INFO [Client.receiveTCPMessages] Client: Ready (11) 8 bytes INFO [Client.receiveTCPMessages] Client: Ready (12) 8 bytes INFO [MuleGameContainer.logSkippedFrames] Skipped frames: 4 INFO [GameController.beginNextPhase] Title: Re: Server is still not tracking properly Post by: WhosYourBuddy? on January 29, 2010, 16:26 Actually, it seems none of the games played after Jan 28th 03:00 are being saved or updated to the High Score list properly.
http://www.planetmule.com/hi-score-players - Who's Your Buddy? Title: Re: Server is still not tracking properly Post by: maskdbandt on January 29, 2010, 21:17 i can believe that... i even read c64's post but didn't realize what it meant until i played one just now and it didn't save anything from it :( it was a fun game though
Title: Re: Server is still not tracking properly Post by: mikman on January 30, 2010, 00:11 It seems like the upgrade to 1.2.3 is what has caused this issue. One other side effect is that the lobby does not update the game status' very consistently or at all in most cases.
Title: Re: Server is still not tracking properly Post by: Peter on January 30, 2010, 11:08 Please see this thread:
http://www.planetmule.com/forum?topic=650.0 |