Mysql problem

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • [21:19:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "spawnchange", connection: 1
    [21:19:45] [WARNING] CMySQLResult::GetRowDataByName - field not found ("spawnchange")
    [21:19:45] [ERROR] cache_get_field_content_int - invalid datatype
    [21:19:45] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

  • [21:19:08] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM haus", callback: "OnHausesLoad", format: "(null)"
    [21:19:08] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [21:19:08] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [21:19:08] [DEBUG] CMySQLConnection::Connect - connection was successful
    [21:19:08] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [21:19:08] [DEBUG] CMySQLConnection::Connect - connection was successful
    [21:19:08] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [21:19:08] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [21:19:08] [DEBUG] CMySQLConnection::Connect - connection was successful
    [21:19:08] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [21:19:08] [DEBUG] CMySQLQuery::Execute[OnHausesLoad] - starting query execution
    [21:19:08] [DEBUG] CMySQLQuery::Execute[OnHausesLoad] - query was successfully executed within 0.62 milliseconds
    [21:19:08] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [21:19:08] [DEBUG] Calling callback "OnHausesLoad"..
    [21:19:08] [DEBUG] cache_get_data - connection: 1
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 0, field_name: "h_x", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_x", data: "1242.11"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 0, field_name: "h_y", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_y", data: "-878.216"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 0, field_name: "h_z", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_z", data: "46.6406"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 0, field_name: "ih_x", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ih_x", data: "1261.21"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 0, field_name: "ih_y", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ih_y", data: "-785.735"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 0, field_name: "ih_z", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ih_z", data: "1091.91"
    [21:19:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "h_interior", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_interior", data: "5"
    [21:19:08] [DEBUG] cache_get_field_content - row: 0, field_name: "besitzer", connection: 1, max_len: 24
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "besitzer", data: ""
    [21:19:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "1"
    [21:19:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "h_preis", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_preis", data: "0"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 1, field_name: "h_x", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_x", data: "1249.48"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 1, field_name: "h_y", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_y", data: "-877.383"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 1, field_name: "h_z", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_z", data: "46.6406"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 1, field_name: "ih_x", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ih_x", data: "0"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 1, field_name: "ih_y", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ih_y", data: "0"
    [21:19:08] [DEBUG] cache_get_field_content_float - row: 1, field_name: "ih_z", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ih_z", data: "0"
    [21:19:08] [DEBUG] cache_get_field_content_int - row: 1, field_name: "h_interior", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_interior", data: "0"
    [21:19:08] [DEBUG] cache_get_field_content - row: 1, field_name: "besitzer", connection: 1, max_len: 24
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "besitzer", data: "Travis_Smith"
    [21:19:08] [DEBUG] cache_get_field_content_int - row: 1, field_name: "id", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "id", data: "2"
    [21:19:08] [DEBUG] cache_get_field_content_int - row: 1, field_name: "h_preis", connection: 1
    [21:19:08] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_preis", data: "1"
    [21:19:08] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [21:19:41] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Travis_Smith'", callback: "OnUserCheck", format: "i"
    [21:19:41] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution
    [21:19:41] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.209 milliseconds
    [21:19:41] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [21:19:41] [DEBUG] Calling callback "OnUserCheck"..
    [21:19:41] [DEBUG] cache_get_data - connection: 1
    [21:19:41] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [21:19:45] [DEBUG] mysql_escape_string - source: "hh5462hh", connection: 1, max_len: 35
    [21:19:45] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Travis_Smith' AND password='h", callback: "OnPasswordResponse", format: "i"
    [21:19:45] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution
    [21:19:45] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.270 milliseconds
    [21:19:45] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [21:19:45] [DEBUG] Calling callback "OnPasswordResponse"..
    [21:19:45] [DEBUG] cache_get_data - connection: 1
    [21:19:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1
    [21:19:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "50"
    [21:19:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1
    [21:19:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "3"
    [21:19:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1
    [21:19:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "5000"
    [21:19:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fraktion", connection: 1
    [21:19:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fraktion", data: "0"
    [21:19:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "rang", connection: 1
    [21:19:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "rang", data: "0"
    [21:19:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "spawnchange", connection: 1
    [21:19:45] [WARNING] CMySQLResult::GetRowDataByName - field not found ("spawnchange")
    [21:19:45] [ERROR] cache_get_field_content_int - invalid datatype
    [21:19:45] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [21:29:09] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE user SET level='50',money='4988',fraktion='0,rang='0',spa", callback: "(null)", format: "(null)"
    [21:29:09] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [21:29:09] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 '0',spawnchange='0' WHERE id='2000'' at line 1
    [21:29:09] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
    [21:29:17] [DEBUG] mysql_close - connection: 1
    [21:29:17] [DEBUG] CMySQLConnection::Disconnect - connection was closed
    [21:29:17] [DEBUG] CMySQLConnection::Disconnect - connection was closed
    [21:29:17] [DEBUG] CMySQLConnection::Disconnect - connection was closed
    [21:29:17] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
    [21:29:25] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM haus", callback: "OnHausesLoad", format: "(null)"
    [21:29:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [21:29:25] [DEBUG] CMySQLConnection::Connect - connection was successful
    [21:29:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [21:29:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [21:29:25] [DEBUG] CMySQLConnection::Connect - connection was successful
    [21:29:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [21:29:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [21:29:25] [DEBUG] CMySQLConnection::Connect - connection was successful
    [21:29:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [21:29:25] [DEBUG] CMySQLQuery::Execute[OnHausesLoad] - starting query execution
    [21:29:25] [DEBUG] CMySQLQuery::Execute[OnHausesLoad] - query was successfully executed within 0.765 milliseconds
    [21:29:25] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [21:29:25] [DEBUG] Calling callback "OnHausesLoad"..
    [21:29:25] [DEBUG] cache_get_data - connection: 1
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 0, field_name: "h_x", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_x", data: "1242.11"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 0, field_name: "h_y", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_y", data: "-878.216"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 0, field_name: "h_z", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_z", data: "46.6406"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 0, field_name: "ih_x", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ih_x", data: "1261.21"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 0, field_name: "ih_y", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ih_y", data: "-785.735"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 0, field_name: "ih_z", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ih_z", data: "1091.91"
    [21:29:25] [DEBUG] cache_get_field_content_int - row: 0, field_name: "h_interior", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_interior", data: "5"
    [21:29:25] [DEBUG] cache_get_field_content - row: 0, field_name: "besitzer", connection: 1, max_len: 24
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "besitzer", data: ""
    [21:29:25] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "1"
    [21:29:25] [DEBUG] cache_get_field_content_int - row: 0, field_name: "h_preis", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "h_preis", data: "0"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 1, field_name: "h_x", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_x", data: "1249.48"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 1, field_name: "h_y", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_y", data: "-877.383"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 1, field_name: "h_z", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_z", data: "46.6406"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 1, field_name: "ih_x", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ih_x", data: "0"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 1, field_name: "ih_y", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ih_y", data: "0"
    [21:29:25] [DEBUG] cache_get_field_content_float - row: 1, field_name: "ih_z", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ih_z", data: "0"
    [21:29:25] [DEBUG] cache_get_field_content_int - row: 1, field_name: "h_interior", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_interior", data: "0"
    [21:29:25] [DEBUG] cache_get_field_content - row: 1, field_name: "besitzer", connection: 1, max_len: 24
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "besitzer", data: "Travis_Smith"
    [21:29:25] [DEBUG] cache_get_field_content_int - row: 1, field_name: "id", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "id", data: "2"
    [21:29:25] [DEBUG] cache_get_field_content_int - row: 1, field_name: "h_preis", connection: 1
    [21:29:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "h_preis", data: "1"
    [21:29:25] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [21:29:50] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Travis_Smith'", callback: "OnUserCheck", format: "i"
    [21:29:50] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution
    [21:29:50] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.304 milliseconds
    [21:29:50] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [21:29:50] [DEBUG] Calling callback "OnUserCheck"..
    [21:29:50] [DEBUG] cache_get_data - connection: 1
    [21:29:50] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [21:29:53] [DEBUG] mysql_escape_string - source: "hh5462hh", connection: 1, max_len: 35
    [21:29:53] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Travis_Smith' AND password='h", callback: "OnPasswordResponse", format: "i"
    [21:29:53] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution
    [21:29:53] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.331 milliseconds
    [21:29:53] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [21:29:53] [DEBUG] Calling callback "OnPasswordResponse"..
    [21:29:53] [DEBUG] cache_get_data - connection: 1
    [21:29:53] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1
    [21:29:53] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "50"
    [21:29:53] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1
    [21:29:53] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "3"
    [21:29:53] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1
    [21:29:53] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "5000"
    [21:29:53] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fraktion", connection: 1
    [21:29:53] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fraktion", data: "0"
    [21:29:53] [DEBUG] cache_get_field_content_int - row: 0, field_name: "rang", connection: 1
    [21:29:53] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "rang", data: "0"
    [21:29:53] [DEBUG] cache_get_field_content_int - row: 0, field_name: "spawnchange", connection: 1
    [21:29:53] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "spawnchange", data: "0"
    [21:29:53] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [21:32:01] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE haus SET besitzer='', h_preis='0' WHERE id='2'", callback: "(null)", format: "(null)"
    [21:32:01] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [21:32:01] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.342 milliseconds
    [21:32:01] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [21:32:15] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE haus SET besitzer='Travis_Smith', h_preis='0' WHERE id='1", callback: "(null)", format: "(null)"
    [21:32:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [21:32:15] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.250 milliseconds
    [21:32:15] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [21:37:33] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE user SET level='50',money='4980',fraktion='1,rang='6',spa", callback: "(null)", format: "(null)"
    [21:37:33] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [21:37:33] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 '6',spawnchange='0' WHERE id='2000'' at line 1
    [21:37:33] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
    [21:39:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Travis_Smith'", callback: "OnUserCheck", format: "i"
    [21:39:21] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution
    [21:39:21] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.238 milliseconds
    [21:39:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [21:39:21] [DEBUG] Calling callback "OnUserCheck"..
    [21:39:21] [DEBUG] cache_get_data - connection: 1
    [21:39:21] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [21:39:24] [DEBUG] mysql_escape_string - source: "hh5462hh", connection: 1, max_len: 35
    [21:39:24] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Travis_Smith' AND password='h", callback: "OnPasswordResponse", format: "i"
    [21:39:24] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution
    [21:39:24] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.242 milliseconds
    [21:39:24] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [21:39:24] [DEBUG] Calling callback "OnPasswordResponse"..
    [21:39:24] [DEBUG] cache_get_data - connection: 1
    [21:39:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1
    [21:39:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "50"
    [21:39:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1
    [21:39:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "3"
    [21:39:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1
    [21:39:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "50"
    [21:39:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fraktion", connection: 1
    [21:39:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fraktion", data: "0"
    [21:39:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "rang", connection: 1
    [21:39:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "rang", data: "0"
    [21:39:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "spawnchange", connection: 1
    [21:39:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "spawnchange", data: "0"
    [21:39:24] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [21:40:27] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE user SET level='50',money='48',fraktion='0,rang='0',spawn", callback: "(null)", format: "(null)"
    [21:40:27] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [21:40:27] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 '0',spawnchange='0' WHERE id='2000'' at line 1
    [21:40:27] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

  • Was??


    Du sollst
    format(query,sizeof(query),"UPDATE user SET level='%i',money='%i',alevel='%i',fraktion='%i,rang='%i',spawnchange='%i' WHERE id='%i'",sInfo[playerid][level],
    Zu
    format(query,sizeof(query),"UPDATE user SET level='%i',money='%i',alevel='%i',fraktion='%i',rang='%i',spawnchange='%i' WHERE id='%i'",sInfo[playerid][level],
    Ändern.


    Laut Log hast du das nicht gemacht, denn da fehlt das Anführungszeichen noch (nach Fraktion).

  • Wenn der gleiche Fehler immer noch kommt im Log, dann hast du die Änderung nicht gemacht, oder den Code nicht konpliliert, oder du startest den falschen Server.


    Ansonsten poste nochmal deinen Code, mit dem du den Spieler speicherst, wie sieht der jetzt aus, und was sagt der Log?

  • do.de - Domain-Offensive - Domains für alle und zu super Preisen
  • [22:20:44] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [22:21:10] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Travis_Smith'", callback: "OnUserCheck", format: "i"
    [22:21:11] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution
    [22:21:11] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.66 milliseconds
    [22:21:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [22:21:11] [DEBUG] Calling callback "OnUserCheck"..
    [22:21:11] [DEBUG] cache_get_data - connection: 1
    [22:21:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [22:21:14] [DEBUG] mysql_escape_string - source: "hh5462hh", connection: 1, max_len: 35
    [22:21:14] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Travis_Smith' AND password='h", callback: "OnPasswordResponse", format: "i"
    [22:21:14] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution
    [22:21:14] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.398 milliseconds
    [22:21:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [22:21:14] [DEBUG] Calling callback "OnPasswordResponse"..
    [22:21:14] [DEBUG] cache_get_data - connection: 1
    [22:21:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1
    [22:21:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "50"
    [22:21:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1
    [22:21:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "3"
    [22:21:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1
    [22:21:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "50"
    [22:21:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fraktion", connection: 1
    [22:21:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fraktion", data: "0"
    [22:21:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "rang", connection: 1
    [22:21:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "rang", data: "0"
    [22:21:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "spawnchange", connection: 1
    [22:21:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "spawnchange", data: "0"
    [22:21:14] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [22:22:21] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE user SET level='50',money='38',alevel='0',fraktion='0',ra", callback: "(null)", format: "(null)"
    [22:22:21] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [22:22:21] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'alevel' in 'field list'
    [22:22:21] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
    [22:24:01] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Travis_Smith'", callback: "OnUserCheck", format: "i"
    [22:24:01] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution
    [22:24:01] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.397 milliseconds
    [22:24:01] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [22:24:01] [DEBUG] Calling callback "OnUserCheck"..
    [22:24:01] [DEBUG] cache_get_data - connection: 1
    [22:24:01] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [22:24:04] [DEBUG] mysql_escape_string - source: "hh5462hh", connection: 1, max_len: 35
    [22:24:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Travis_Smith' AND password='h", callback: "OnPasswordResponse", format: "i"
    [22:24:04] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution
    [22:24:04] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.226 milliseconds
    [22:24:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [22:24:04] [DEBUG] Calling callback "OnPasswordResponse"..
    [22:24:04] [DEBUG] cache_get_data - connection: 1
    [22:24:04] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1
    [22:24:04] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "50"
    [22:24:04] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1
    [22:24:04] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "3"
    [22:24:04] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1
    [22:24:04] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "50"
    [22:24:04] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fraktion", connection: 1
    [22:24:04] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fraktion", data: "0"
    [22:24:04] [DEBUG] cache_get_field_content_int - row: 0, field_name: "rang", connection: 1
    [22:24:04] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "rang", data: "0"
    [22:24:04] [DEBUG] cache_get_field_content_int - row: 0, field_name: "spawnchange", connection: 1
    [22:24:04] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "spawnchange", data: "0"
    [22:24:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [22:24:39] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE user SET level='50',money='0',alevel='0',fraktion='0',ran", callback: "(null)", format: "(null)"
    [22:24:39] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [22:24:39] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.189 milliseconds
    [22:24:39] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving


    hier müstte der aktuelste sein neben bei auch paar restarts :)

  • Zitat

    [22:22:21] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'alevel' in 'field list'


    Die Spalte alevel existiert in der Tabelle nicht.
    Prüfe nach dem hinzufügen, ob du sonst alle Spalten hast, wenn nicht füge alle hinzu die fehlen.



    EDIT: @swagtiiger:
    Der Thread steht auf erledigt, ich nehme an es klappt somit alles.

    3HZXdYd.png

    Einmal editiert, zuletzt von Jeffry ()