1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MySQL values don't update
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#1

04.03.2013, 00:25
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.
pawn Код:
PlayerStatSaveTimer[playerid] = SetTimerEx("StatSaving", 3000, true, "i", playerid);
This is what happens when the Timer is called.
pawn Код:
forward StatSaving(playerid);
public StatSaving(playerid)
{
    new Float:h;
    GetPlayerHealth(playerid, h);
    new query[512];
    format(query, sizeof(query), "UPDATE accounts SET level = '%d', xp = '%d', adminlevel = '%d', health = '%f', kills = '%d', deaths = '%d', skin = '%d', money = '%d', hunger = '%d', thirst = '%d', radiation = '%d', meat = '%d', squirrel = '%d', cola = '%d', pwater = '%d', bmeat = '%d', bsquirrel = '%d', bwater = '%d', race = '%d' WHERE name = '%s'",
    Player[playerid][Level],
    Player[playerid][XP],
    Player[playerid][AdminLevel],
    Player[playerid][Health],
    Player[playerid][Kills],
    Player[playerid][Deaths],
    Player[playerid][Skin],
    Player[playerid][Money],
    Player[playerid][Hunger],
    Player[playerid][Thirst],
    Player[playerid][Radiation],
    Player[playerid][Meat],
    Player[playerid][Squirrel],
    Player[playerid][Cola],
    Player[playerid][PWater],
    Player[playerid][BMeat],
    Player[playerid][BSquirrel],
    Player[playerid][BWater],
    Player[playerid][Race],
    pName(playerid));
    mysql_query(query);
    return 1;
}
If anyone knows how to fix this, please help me out.
Find
Reply
Mmartin
Big Clucker
***
Posts: 102
Threads: 9
Joined: Jan 2010
Reputation: 0
#2

04.03.2013, 00:31
Enable debugging and show us what does mysql_error() say.
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#3

04.03.2013, 04:38
----
Find
Reply
Scenario
Godfather
*****
Posts: 7,801
Threads: 187
Joined: Feb 2010
Reputation: 0
#4

04.03.2013, 06:51
You're saying stats every 3 seconds....?
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#5

04.03.2013, 20:40
I'm a little new to this, is that too quick for stats to save?
Find
Reply
MP2
Godfather
*****
Posts: 6,236
Threads: 310
Joined: Jan 2011
Reputation: 0
#6

04.03.2013, 20:42
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.
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#7

04.03.2013, 20:59
[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?
Find
Reply
[MG]Dimi
High-roller
*****
Posts: 1,239
Threads: 16
Joined: Mar 2011
Reputation: 0
#8

04.03.2013, 21:41
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.
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#9

04.03.2013, 22:50
Ah, turns out I had "thirst" spelled wrong in the database. Fixed it all when I fixed that. Thanks
Find
Reply
Scenario
Godfather
*****
Posts: 7,801
Threads: 187
Joined: Feb 2010
Reputation: 0
#10

04.03.2013, 23:31
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).
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help