Szerző Téma: MySQL mentés HIBA  (Megtekintve 1193 alkalommal)

MySQL mentés HIBA
« Dátum: 2016. November 12. - 12:48:34 »
0
Halihó!
Mikor egy játékos lelép akkor ezzel a \"Mentés\" formátummal próbálom elmenteni a játékos adatait.
 
mysql_format(kapcs, query, 384, \"UPDATE `jatekosok` SET Admin = \'%d\', Penz = \'%d\', Tartozas = \'%d\', Skin = \'%d\', Frakcio = \'%d\', Munka = \'%d\' WHERE Nev=\'%s\'\", pInfo[playerid][pAdmin], pInfo[playerid][pMoney], pInfo[playerid][pTartozas], pInfo[playerid][pSkin], pInfo[playerid][pFrakcio], pInfo[playerid][pMunka], Nev(playerid));
mysql_tquery(kapcs, query);

 
De nem menti el, semmit nem csinál rá, mi lehet a problémám?

MySQL mentés HIBA
« Válasz #1 Dátum: 2016. November 12. - 13:12:57 »
0
a 384 es hosszúságon növelnék a helyedbe először

MySQL mentés HIBA
« Válasz #2 Dátum: 2016. November 12. - 13:50:41 »
0
És másodszor? :D

MySQL mentés HIBA
« Válasz #3 Dátum: 2016. November 12. - 14:53:21 »
0
Kéne egy log (sql, (server log))

MySQL mentés HIBA
« Válasz #4 Dátum: 2016. November 12. - 15:05:10 »
0

[14:53:49] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'0\')
[14:53:49] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'0\')
[14:53:51] [ERROR] mysql_format - no value for specifier \"%d\" available
[14:53:51] [ERROR] mysql_format - no value for specifier \"%s\" available
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET Admin = \'0\', Penz = \'0\', Tartozas = \'0\', Skin = \'0\', \' at line 1
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET Kor = \'0\', Nem = \'0\', Fizetes = \'0\', FizetesIDO = \'0\'\' at line 1
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET RegIDO = \'\', BelepesIDO = \'\'\' at line 1
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET Ban = \'0\', Borton = \'0\', BortonIdo = \'0\', BortonTipus\' at line 1
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET Kresz = \'0\', Jogositvany = \'0\', Szemelyi = \'0\', Jogsi\' at line 1
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET JogsiC = \'0\', JogsiCE = \'0\', JogsiH = \'0\', RutinA = \'\' at line 1
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET ANev = \'\', spawnx = \'1693.393\', spawny = \'-2325.564\',\' at line 1
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET Rang = \'0\', FSkill = \'0\', Szamlaszam = \'\', Bank = \'0\'\' at line 1
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET MobilSzam = \'\', MobilPenz = \'0\', Mobil = \'0\', MobilAl\' at line 1
[14:53:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'WHERE Nev=\'Jay_Gatsby\' SET EngedelyFegyo = \'0\', Korozott = \'0\', KorozesIndok = \'\' at line 1

 
Ilyen hibák vannak :S
Adatot meg így töltöm be:
 

pInfo[playerid][pAdmin] = cache_get_field_content_int(0, \"Admin\");

 

SimplePortal 2.3.7 © 2008-2024, SimplePortal