MySQL values don't update - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL values don't update (/showthread.php?tid=420219)

---

MySQL values don't update - Stephano - 04.03.2013

I never ran into this problem before and I've been using the same system for a while now and it just suddenly came up. Basically, your stats don't save when you log out, they reset back to the register stat values (when you register, you get set stats, such as level 1, $100, etc.).

This activates after you log onto the server.
This is what happens when the Timer is called.
If anyone knows how to fix this, please help me out.

---

Re: MySQL values don't update - Mmartin - 04.03.2013

Enable debugging and show us what does mysql_error() say.

---

Re: MySQL values don't update - Stephano - 04.03.2013

----

---

Re: MySQL values don't update - Scenario - 04.03.2013

You're saying stats every 3 seconds....?

---

Re: MySQL values don't update - Stephano - 04.03.2013

I'm a little new to this, is that too quick for stats to save?

---

Re: MySQL values don't update - MP2 - 04.03.2013

You should save stats at the least interval, once a minute. I'd personally recommend 5 minutes. IMPORTANT stats (money, score etc.) should be saved when they are updated - i.e. make a GivePlayerScore and hook GivePlayerMoney or something.

---

Re: MySQL values don't update - Stephano - 04.03.2013

[16:10:33] ---------------------------

[16:10:33] MySQL Debugging activated (03/04/13)

[16:10:33] ---------------------------

[16:10:33]

[16:11:39] >> mysql_query( Connection handle: 1 )

[16:11:40] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name` = 'Michael_Silvestri' LIMIT 1) - Successfully executed.

[16:11:40] >> mysql_store_result( Connection handle: 1 )

[16:11:40] CMySQLHandler::StoreResult() - Result was stored.

[16:11:40] >> mysql_num_rows( Connection handle: 1 )

[16:11:40] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:11:40] >> mysql_free_result( Connection handle: 1 )

[16:11:40] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:12:05] >> mysql_query( Connection handle: 1 )

[16:12:05] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name` = 'Michael_Silvestri' AND `password` = '32a57l21' LIMIT 1) - Successfully executed.

[16:12:05] >> mysql_store_result( Connection handle: 1 )

[16:12:05] CMySQLHandler::StoreResult() - Result was stored.

[16:12:05] >> mysql_num_rows( Connection handle: 1 )

[16:12:05] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:12:05] >> mysql_query( Connection handle: 1 )

[16:12:05] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name` = 'Michael_Silvestri' LIMIT 1) - Successfully executed.

[16:12:05] >> mysql_store_result( Connection handle: 1 )

[16:12:05] CMySQLHandler::StoreResult() - Result was stored.

[16:12:05] >> mysql_fetch_row_format( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchRow() - Return: Michael_Silvestri|32a57l21|1|0|5|100|0|0|1|10|100| 100|9|0|0|0|0|0|0|0|1

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("level") - 1

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("xp") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("adminlevel") - 5

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("health") - 100

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("kills") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("deaths") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("skin") - 1

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("money") - 10

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("hunger") - 100

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("thirst") -

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("radiation") - 9

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("meat") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("squirrel") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("cola") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("pwater") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("bmeat") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("bsquirrel") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("bwater") - 0

[16:12:05] >> mysql_fetch_field_row( Connection handle: 1 )

[16:12:05] CMySQLHandler::FetchField("race") - 1

[16:12:05] >> mysql_fetch_row_format( Connection handle: 1 )

[16:12:05] >> mysql_free_result( Connection handle: 1 )

[16:12:05] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:12:05] >> mysql_free_result( Connection handle: 1 )

[16:12:05] CMySQLHandler::FreeResult() - The result is already empty.

[16:12:16] >> mysql_query( Connection handle: 1 )

[16:12:16] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '0', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:12:27] >> mysql_query( Connection handle: 1 )

[16:12:27] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '0', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:12:37] >> mysql_query( Connection handle: 1 )

[16:12:37] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '0', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:12:48] >> mysql_query( Connection handle: 1 )

[16:12:48] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '0', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:12:59] >> mysql_query( Connection handle: 1 )

[16:12:59] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '0', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:13:10] >> mysql_query( Connection handle: 1 )

[16:13:10] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '0', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:13:21] >> mysql_query( Connection handle: 1 )

[16:13:21] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '0', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:13:32] >> mysql_query( Connection handle: 1 )

[16:13:32] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '0', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:13:42] >> mysql_query( Connection handle: 1 )

[16:13:42] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '0', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:13:42] >> mysql_query( Connection handle: 1 )

[16:13:42] CMySQLHandler::Query(UPDATE accounts SET thirst = '-1' WHERE name = 'Michael_Silvestri' LIMIT 1) - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:13:53] >> mysql_query( Connection handle: 1 )

[16:13:53] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:14:03] >> mysql_query( Connection handle: 1 )

[16:14:03] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:14:14] >> mysql_query( Connection handle: 1 )

[16:14:14] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:14:24] >> mysql_query( Connection handle: 1 )

[16:14:24] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:14:35] >> mysql_query( Connection handle: 1 )

[16:14:35] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:14:45] >> mysql_query( Connection handle: 1 )

[16:14:45] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:14:56] >> mysql_query( Connection handle: 1 )

[16:14:56] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:15:06] >> mysql_query( Connection handle: 1 )

[16:15:06] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '100', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:15:17] >> mysql_query( Connection handle: 1 )

[16:15:17] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '10', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:15:27] >> mysql_query( Connection handle: 1 )

[16:15:27] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:15:38] >> mysql_query( Connection handle: 1 )

[16:15:40] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:15:48] >> mysql_query( Connection handle: 1 )

[16:15:48] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:15:59] >> mysql_query( Connection handle: 1 )

[16:15:59] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:16:10] >> mysql_query( Connection handle: 1 )

[16:16:10] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:16:22] >> mysql_query( Connection handle: 1 )

[16:16:22] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:16:33] >> mysql_query( Connection handle: 1 )

[16:16:33] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:16:44] >> mysql_query( Connection handle: 1 )

[16:16:44] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:16:55] >> mysql_query( Connection handle: 1 )

[16:16:55] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:17:06] >> mysql_query( Connection handle: 1 )

[16:17:06] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:17:17] >> mysql_query( Connection handle: 1 )

[16:17:17] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:17:28] >> mysql_query( Connection handle: 1 )

[16:17:28] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:17:39] >> mysql_query( Connection handle: 1 )

[16:17:39] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:17:50] >> mysql_query( Connection handle: 1 )

[16:17:50] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:18:01] >> mysql_query( Connection handle: 1 )

[16:18:01] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:18:12] >> mysql_query( Connection handle: 1 )

[16:18:12] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:18:24] >> mysql_query( Connection handle: 1 )

[16:18:24] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:18:35] >> mysql_query( Connection handle: 1 )

[16:18:35] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '99', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:18:46] >> mysql_query( Connection handle: 1 )

[16:18:46] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '98', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:18:57] >> mysql_query( Connection handle: 1 )

[16:18:57] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '98', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:19:08] >> mysql_query( Connection handle: 1 )

[16:19:08] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '98', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:19:19] >> mysql_query( Connection handle: 1 )

[16:19:19] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '98', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:19:30] >> mysql_query( Connection handle: 1 )

[16:19:30] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '98', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')

[16:19:40] >> mysql_query( Connection handle: 1 )

[16:19:40] CMySQLHandler::Query(UPDATE accounts SET level = '1', xp = '0', adminlevel = '5', health = '0.000000', kills = '0', deaths = '0', skin = '1', money = '22', hunger = '98', thirst = '100', radiation = '9', meat = '0', squirrel = '0', cola = '0', pwater = '0', bmeat = '0', bsquirrel = '0', bwater = '0', race = '1' WHERE name = 'Michael_Silvestri') - An error has occured. (Error ID: 1054, Unknown column 'thirst' in 'field list')


Alright, it says that something's wrong with thirst, but it looks fine to me. Anything that you guys can see?

---

Re: MySQL values don't update - [MG]Dimi - 04.03.2013

You don't have that Column in Database. Show us Image from phpMyAdmin. Also, All Table & Column names have to be between ` ` to prevent SQL Syntax Error.

---

Re: MySQL values don't update - Stephano - 04.03.2013

Ah, turns out I had "thirst" spelled wrong in the database. Fixed it all when I fixed that. Thanks

---

Re: MySQL values don't update - Scenario - 04.03.2013

Remember that in PAWN, time is in milliseconds. So, each second is 1000ms, each minute is 60000ms and each hour is 60*60000.

Furthermore, remember that in MySQL field names are case sensitive (at least they are in Linux).

---