Page 1 of 1

SQL error

Posted: Mon Mar 10, 2008 1:18 pm
by Lardmaster
I logged in as dead and when I try to revive I get the message

Could not execute query.
Query: UPDATE nuke_wok_rpg_players SET HP=0 WHERE PlayerID=
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

Re: SQL error

Posted: Mon Mar 10, 2008 4:41 pm
by Hryllantre
Lardmaster wrote:I logged in as dead and when I try to revive I get the message

Could not :behead: execute query.
Looks like someone beat you to that :P

Posted: Mon Mar 10, 2008 5:39 pm
by korexus
Very odd, I just tried resurrecting and it worked fine.

Could you hit the refresh button in the stats window and tell me what happens?



Posted: Mon Mar 10, 2008 7:25 pm
by Lardmaster
Works fine now oddly enough. Didn't work last night or today though. Hey-ho.

Posted: Fri Mar 14, 2008 9:11 am
by Lardmaster
I get the error every time I start the game now. I then have to come out and then go back in and it works okay.

Posted: Wed Mar 19, 2008 4:36 pm
by Lardmaster
Still happening. Can it be to do with me using two different PCs? I log in okay but as soon as I try and do anything the error pops up.

Posted: Wed Mar 19, 2008 8:32 pm
by korexus
I occasionally get the error, but that is when I have left the window open for long enough for the session to time out. I had a login link for that situation before, but it seems to have dissapeared.

Do you have the browser set to automatically log you into Kaomaris?
Do you follow links to the RPG or use a favourite?
Are you using IE, Firefox or something else?


Posted: Wed Mar 19, 2008 10:31 pm
by Lardmaster
Answers :D

1) yes
2) No
3) IE becuase firefox won't work since that weird moving boxes thingummy.

Posted: Wed Mar 19, 2008 10:34 pm
by korexus
2)Do you follow links or use a favourite?

This was an either or, if I missed an option (typing the url manually?) could you let me know how you do access the rpg?


PS boxes work for me in firefox, or do you mean that you just don't like it that way?

Posted: Thu Mar 20, 2008 1:39 pm
by Lardmaster
2) I type the url in then click view running games then my wok which brings the detail up. As soon as I then try and click anything I get the error.

Posted: Thu Mar 20, 2008 1:46 pm
by Lardmaster
P.S. On firefox the page loads like i.e then after a couple of seconds the map etc disappears and I am just left with the chatbox. I've done the whole cache clearing thing to no effect.

Posted: Wed Apr 09, 2008 8:57 pm
by korexus
Login based error should be fixed now. When the session is timed out, you now get a much less offensive please log in message.

If everything disappears, you'll need to clear your cookies. For some stupid reason the window system is defaulting to hiding the windows and I can't figure out why. If you're using the default display then this shouldn't be a problem.


Posted: Thu Apr 10, 2008 11:44 am
by Lardmaster
The log in error is indeed fixed now. Nice one. However I have a new problem now in that I am not seeing any fight info. I get the baddie picture and the attack button but once I click attack the screen refreshes and the baddie is gone. I assume that I have killed it but no "you killed one" message anymore.

Posted: Thu Apr 10, 2008 11:48 am
by Lardmaster
Opening chests doesn't give me a message telling me what was in it either.

Posted: Thu Apr 10, 2008 1:24 pm
by korexus
Look down a bit, the messages have been moved to a scrollable box, so you can look back and check what happened in the past.

If you're using the windowed version, you may need to do the cookie clearing thing to make the new window appear.


Posted: Thu Apr 10, 2008 1:57 pm
by Lardmaster
Nope not seeing that at all. Not using the windowed version either.

Posted: Thu Apr 10, 2008 4:26 pm
by korexus
Curious. The text was being displayed, but in a one line box with no scroll bar, rather than a 5 line box with a scroll bar as I'd written. Just one more of IEs little bugs I guess. I'll try to make it work now.


Posted: Thu Apr 10, 2008 6:13 pm
by korexus
Should be there now. IE adds an irritating horizontal scroll bar, but I've just spent three hours getting that far (Google said it was a bug that couldn't be fixed, but what does it know? :wink: ) Enjoy your new message log. :D