[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
Mysql problem
- SMiiTH
- Geschlossen
- Erledigt
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
-
Dir fehlt die Spalte "spawnchange" in der Tabelle deiner Datenbank.
Lege diese Spalte in der Struktur der Tabelle an. -
Erstens:
Wenn du deine ursprünglichen Posts löschst, dann widersprichst du dem Sinn eines Forums zu 100%.Zweitens:
Poste den Log vom Speichern, und zwar alles was da kommt und nicht wieder nur die Hälfte. -
-
schon lange vorhanden
-
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?
-
-
[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 savinghier 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. -
-
breadfish.de
Hat das Thema geschlossen.
