Mysql - update is not loaded?
#1

Using mysql R39-2, I've had several issues where a player gets kicked and their stats do not get saved, or a player's stats do not get loaded correctly, etc. Particularly this weird case where the value that is Updated is not the value that is loaded upon re-login. Example:

[04:09:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[04:09:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "6"
[04:09:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Adminlevel", connection: 1
[04:09:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Adminlevel", data: "3"

loaded.
saving

[04:17:02] [DEBUG] mysql_format - connection: 1, len: 300, format: "UPDATE `playerinfo` SET `Adminlevel`=%d, `Money`=%d, `Kills`=%d WHERE `ID`=%d"
[04:17:02] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `playerinfo` SET `Adminlevel`=3, `Money`=25000, `Kills`=0", callback: "(null)", format: "(null)"

successful.

reload.

[17:35:12] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Adminlevel", connection: 1
[17:35:12] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Adminlevel", data: "0"
[17:35:12] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[17:35:12] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "6"

It is calling the same id btw.

Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)