Server is still not tracking properly

[C64 nostalgia]

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]

 

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]              

[WhosYourBuddy?]

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?

[maskdbandt]

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

[mikman]

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.

[Peter]

Please see this thread:
http://www.planetmule.com/forum?topic=650.0