• Possible delete char bug

Posted: **Sat Aug 09, 2008 9:34 am**

I haven't seen this before in testing, but someone just deleted their char from my server and immediately following looks like a DB Error trying to update the deleted records unix timestamp.

Code: Select all

Delete char request: 1445 746
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_time
stamp=1218291913 where id=746 and account_id=1445': DBcore::RunQuery: No Result

Doesn't appear harmful, just reporting the news.

Posted: **Mon Oct 13, 2008 11:07 am**

Got a few more of these errors today in the console, though I still do not believe they are critical. The character deletes are occurring, not sure why their unix_timestamp is trying to get updated after they have been deleted...

Code: Select all

Delete char request: 924 1042
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_timestamp=1223890176 where id=1042 and account_id=924': DBcore::RunQuery: No Result
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_timestamp=1223890236 where id=1042 and account_id=924': DBcore::RunQuery: No Result
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_timestamp=1223890296 where id=1042 and account_id=924': DBcore::RunQuery: No Result
Timeout up!, state=0
Zone: Removing client from ip:xxx.xxx.xxx.xxx port:26357
Removing connection
.
.
.
Left Grid 924281492 and Entered Grid 819993724
OP_SatMsg Received 0x00ab
Delete char request: 3191 1043
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_timestamp=1223910033 where id=1043 and account_id=3191': DBcore::RunQuery: No Result
Timeout up!, state=0
Zone: Removing client from ip:xxx.xxx.xxx.xxx port:2546
Removing connection

Both cases seemed to have that Timoutup!, state=0. Perhaps the character delete is occurring after a client gets booted but before the game server knows the player deleted the char?
Most of the time, char deletes do not generate this error.

Posted: **Mon Oct 13, 2008 1:35 pm**

Heh, the player must have had two screens opened (one in-game and one on the server) and deleted the character while they were playing. I'm not sure why they would do this, unless they were trying to crash the server.

Posted: **Mon Oct 13, 2008 1:43 pm**

Bring it on, nubs! I dare you to crash mah server!