SQL Problem mit Datenbank..

Tag, nette Community, ich melde mich mal wieder,

Ich habe ein kleines Problem, ich stieg von BlueG zu Strickenkids MySQL um, alles schön und gut Beavis hilf mir doch es folgt ein Problem, wie jeder weis möchte das System von dem Kid ein Passwort, rein gemacht Funkt doch dann kommt immer ein Error er könne nichts in die Liste eintragen..?

Zitat

SA-MP Dedicated Server
----------------------
v0.3x, (C)2005-2013 SA-MP Team

[18:07:42]
[18:07:42] Server Plugins
[18:07:42] --------------
[18:07:42] Loading plugin: streamer
[18:07:42]

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[18:07:42] Loaded.
[18:07:42] Loading plugin: mysql
[18:07:42] SA:MP MySQL Plugin v2.1.1 Loaded.
[18:07:42] Loaded.
[18:07:42] Loading plugin: sscanf
[18:07:42] [MySQL] Thread running. Threadsafe: Yes.
[18:07:42]

[18:07:42] ===============================

[18:07:42] sscanf plugin loaded.

[18:07:42] (c) 2009 Alex "Y_Less" Cole

[18:07:42] 0.3d-R2 500 Players "dnee"

[18:07:42] ===============================

[18:07:42] Loaded.
[18:07:42] Loaded 3 plugins.

[18:07:42]
[18:07:42] Filterscripts
[18:07:42] ---------------
[18:07:42] Loading filterscript 'cameditor.amx'...
[18:07:42]
--------------------------------------
[18:07:42] CamEditor by Drebin
[18:07:42] --------------------------------------

[18:07:42] Loaded 1 filterscripts.

[18:07:42] [MySQL] Connected (0) to 'root'@'localhost via TCP/IP'.
[18:07:42] [MySQL] Server Version 5.5.27.
[18:07:42] Number of vehicle models: 6
[18:08:09] Incoming connection: 127.0.0.1:2827
[18:08:09] [join] PuSchKiiNX has joined the server (0:127.0.0.1)
[18:08:18] [MySQL] Error (0): Failed to exeute query. Unknown column 'PuSchKiiNX' in 'field list'.
[18:09:36] [part] PuSchKiiNX has left the server (0:1)

Alles anzeigen

& man erkennt dort schon diesen Error,

Zitat

[18:08:18] [MySQL] Error (0): Failed to exeute query. Unknown column 'PuSchKiiNX' in 'field list'.

bei diesem Error stehe ich zurzeit auf dem Schlauch, werde nicht schlau dadurch, könnte eventuell jemand helfen? vllt gibt es unter uns einige die dieses problem hatten? währe sehr Dankbar wenn sich jemand melden würde..

Noch die SQL_LOG

Zitat

[Mon May 20 18:07:42 2013] Logging Started
[Mon May 20 18:07:42 2013] -------------------------
[Mon May 20 18:07:42 2013] Function: mysql_init executed with result: "0".
[Mon May 20 18:07:42 2013] Connected (0) to root @ localhost via TCP/IP.
[Mon May 20 18:07:42 2013] MySQL Server Version 5.5.27.
[Mon May 20 18:07:42 2013] Function: mysql_query executed: "SELECT * FROM `accounts` WHERE `ID` = '0';" with result: "0".
[Mon May 20 18:07:42 2013] Function: mysql_store_result executed with result: "1"
[Mon May 20 18:07:42 2013] Function: mysql_num_rows executed with result: "".
[Mon May 20 18:07:42 2013] Function: mysql_query executed: "SELECT * FROM `accounts` WHERE `ID` = '1';" with result: "0".
[Mon May 20 18:07:42 2013] Function: mysql_store_result executed with result: "1"
[Mon May 20 18:07:42 2013] Function: mysql_num_rows executed with result: "".
[Mon May 20 18:07:42 2013] Function: mysql_query executed: "SELECT * FROM `accounts` WHERE `ID` = '2';" with result: "0".
[Mon May 20 18:07:42 2013] Function: mysql_store_result executed with result: "1"
[Mon May 20 18:07:42 2013] Function: mysql_num_rows executed with result: "".
[Mon May 20 18:07:42 2013] Function: mysql_query executed: "SELECT * FROM `accounts` WHERE `ID` = '3';" with result: "0".
[Mon May 20 18:07:42 2013] Function: mysql_store_result executed with result: "1"
[Mon May 20 18:07:42 2013] Function: mysql_num_rows executed with result: "".
[Mon May 20 18:07:42 2013] Function: mysql_query executed: "SELECT * FROM `accounts` WHERE `ID` = '4';" with result: "0".
[Mon May 20 18:07:42 2013] Function: mysql_store_result executed with result: "1"
[Mon May 20 18:07:42 2013] Function: mysql_num_rows executed with result: "".
[Mon May 20 18:08:09 2013] Function: mysql_real_esacpe_string executed: "PuSchKiiNX" with result: "PuSchKiiNX".
[Mon May 20 18:08:09 2013] Function: mysql_query executed: "SELECT `id` FROM `accounts` WHERE `Name` = 'PuSchKiiNX'" with result: "0".
[Mon May 20 18:08:09 2013] Function: mysql_store_result executed with result: "1"
[Mon May 20 18:08:09 2013] Function: mysql_free_result executed.
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "INSERT INTO `accounts` (`Name`, `Passwort`) VALUES (`PuSchKiiNX`,`lol`);" with result: "1".
[Mon May 20 18:08:18 2013] Error (0): Failed to exeute query. Unknown column 'PuSchKiiNX' in 'field list'.
[Mon May 20 18:08:18 2013] Function: mysql_real_esacpe_string executed: "PuSchKiiNX" with result: "PuSchKiiNX".
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "SELECT `id` FROM `accounts` WHERE `Name` = 'PuSchKiiNX'" with result: "0".
[Mon May 20 18:08:18 2013] Function: mysql_store_result executed with result: "1"
[Mon May 20 18:08:18 2013] Function: mysql_free_result executed.
[Mon May 20 18:08:18 2013] Function: mysql_real_esacpe_string executed: "PuSchKiiNX" with result: "PuSchKiiNX".
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "UPDATE `accounts` SET `Level` = '0',`Geld` = '0',`Alter` = '0',`Bundesland` = '0',`Admin` = '0' WHERE `Name` = 'PuSchKiiNX'" with result: "0".
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "UPDATE `accounts` SET `Kills` = '0',`Tode` = '0',`Perso` = '0',`CarLic` = '0',`BikeLic` = '0' WHERE `Name` = 'PuSchKiiNX'" with result: "0".
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "UPDATE `accounts` SET `FlyLic` = '0',`WaffenLic` = '0',`TruckLic` = '0',`Ban` = '0',`Warn` = '0',`Leader` = '0' WHERE `Name` = 'PuSchKiiNX'" with result: "0".
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "UPDATE `accounts` SET `Rang` = '0',`Fraktion` = '0',`Story` = '0',`Member` = '0',`Skin` = '0' WHERE `Name` = 'PuSchKiiNX'" with result: "0".
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "UPDATE `accounts` SET `Geschlecht` = '0',`Job` = '0',`Premium` = '0',`IP` = '0',`Wanteds` = '0',`HartzIV` = '0' WHERE `Name` = 'PuSchKiiNX'" with result: "0".
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "UPDATE `accounts` SET `ZollPass` = '0',`Konto` = '0',`URCoins` = '0',`XP` = '0',`Krankenkasse` = '0',`SpielMinuten` = '0' WHERE `Name` = 'PuSchKiiNX'" with result: "0".
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "UPDATE `accounts` SET `Timebiszahltag` = '0',`Telefonbuch` = '0',`Handynummer` = '0',`Handymarke` = '0', `Handyakku` = '0',`Uhr` = '0', `LSD` = '0', `Grass` = '0', `Kokain` = '0' WHERE `Name` = 'PuSchKiiNX'" with result: "0".
[Mon May 20 18:08:18 2013] Function: mysql_real_esacpe_string executed: "lol" with result: "lol".
[Mon May 20 18:08:18 2013] Function: mysql_query executed: "SELECT * FROM `accounts` WHERE `Name` = 'PuSchKiiNX' AND `passwort` = 'lol';" with result: "0".
[Mon May 20 18:08:18 2013] Function: mysql_store_result executed with result: "1"
[Mon May 20 18:08:18 2013] Function: mysql_num_rows executed with result: "".
[Mon May 20 18:08:18 2013] Function: mysql_free_result executed.

Alles anzeigen

Zitat von Beavis

Du benennst die Spalte PuSchKiiNX ?!
zeig mal die Zeile

die UPDATE ?

mysql_real_escape_string(PlayerName(playerid), PlayerName(playerid));
format(query, sizeof(query),"UPDATE `accounts` SET `Level` = '%d',`Geld` = '%d',`Alter` = '%d',`Bundesland` = '%d',`Admin` = '%d' WHERE `Name` = '%s'",
SpielerInfo[playerid][pLevel] = GetPlayerScore(playerid),SpielerInfo[playerid][pGeld] = GetPlayerMoney(playerid),
SpielerInfo[playerid][pAlter], SpielerInfo[playerid][pBundesland],SpielerInfo[playerid][pAdmin],PlayerName(playerid));
mysql_query(query, (-1), (0), SQL);

new string[300];
format(string,sizeof(string), "INSERT INTO `accounts` (`Name`, `Passwort`) VALUES (`%s`,`%s`);", SpielerInfo[playerid][pName], inputtext);
mysql_query(string, (-1), (0), SQL);
SpielerInfo[playerid][pUserid] = GetUserID(playerid);
SavePlayer(playerid);;

Danke erst jetzt gesehen mal testen!!