MySQL Update - Errors?

Hey Com,

Bei meinem Blitzerupdaten kommen Errors in der Log

Zitat

Spoiler anzeigen

[09:16:49] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[09:16:49] >> mysql_query( Connection handle: 1 )

[09:16:49] CMySQLHandler::Query(UPDATE blitzer SET `Blitzerx` = '0.000000',`Blitzery` = '0.000000' ,`Blitzerz` = '0.000000', `BlitzerRotz` = '0.000000',`Geschindigkeit` = '0',`Strafe` = '0',`Punkte` = '0' ,`LastBlitz` = '' ,`Filmabschnitte` = '0',`Toleranz` = '0', `Inuse` = '0' WHERE Blitzerid = '15) - An error has occured. (Error ID: 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 ''15' at line 1)

[09:16:49] >> mysql_free_result( Connection handle: 1 )

[09:16:49] CMySQLHandler::FreeResult() - The result is already empty.

[09:16:49] >> mysql_query( Connection handle: 1 )

[09:16:49] CMySQLHandler::Query(SELECT * Blitzerx FROM `blitzer` WHERE `Blitzerid` = '16') - An error has occured. (Error ID: 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 'Blitzerx FROM `blitzer` WHERE `Blitzerid` = '16'' at line 1)

[09:16:49] >> mysql_store_result( Connection handle: 1 )

[09:16:49] CMySQLHandler::StoreResult() - No data to store.

[09:16:49] >> mysql_num_rows( Connection handle: 1 )

[09:16:49] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[09:16:49] >> mysql_query( Connection handle: 1 )

[09:16:49] CMySQLHandler::Query(UPDATE blitzer SET `Blitzerx` = '0.000000',`Blitzery` = '0.000000' ,`Blitzerz` = '0.000000', `BlitzerRotz` = '0.000000',`Geschindigkeit` = '0',`Strafe` = '0',`Punkte` = '0' ,`LastBlitz` = '' ,`Filmabschnitte` = '0',`Toleranz` = '0', `Inuse` = '0' WHERE Blitzerid = '16) - An error has occured. (Error ID: 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 ''16' at line 1)

[09:16:49] >> mysql_free_result( Connection handle: 1 )

[09:16:49] CMySQLHandler::FreeResult() - The result is already empty.

[09:16:49] >> mysql_query( Connection handle: 1 )

[09:16:49] CMySQLHandler::Query(SELECT * Blitzerx FROM `blitzer` WHERE `Blitzerid` = '17') - An error has occured. (Error ID: 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 'Blitzerx FROM `blitzer` WHERE `Blitzerid` = '17'' at line 1)

[09:16:49] >> mysql_store_result( Connection handle: 1 )

[09:16:49] CMySQLHandler::StoreResult() - No data to store.

[09:16:49] >> mysql_num_rows( Connection handle: 1 )

[09:16:49] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[09:16:49] >> mysql_query( Connection handle: 1 )

[09:16:49] CMySQLHandler::Query(UPDATE blitzer SET `Blitzerx` = '0.000000',`Blitzery` = '0.000000' ,`Blitzerz` = '0.000000', `BlitzerRotz` = '0.000000',`Geschindigkeit` = '0',`Strafe` = '0',`Punkte` = '0' ,`LastBlitz` = '' ,`Filmabschnitte` = '0',`Toleranz` = '0', `Inuse` = '0' WHERE Blitzerid = '17) - An error has occured. (Error ID: 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 ''17' at line 1)

[09:16:49] >> mysql_free_result( Connection handle: 1 )

[09:16:49] CMySQLHandler::FreeResult() - The result is already empty.

[09:16:49] >> mysql_query( Connection handle: 1 )

[09:16:49] CMySQLHandler::Query(SELECT * Blitzerx FROM `blitzer` WHERE `Blitzerid` = '18') - An error has occured. (Error ID: 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 'Blitzerx FROM `blitzer` WHERE `Blitzerid` = '18'' at line 1)

[09:16:49] >> mysql_store_result( Connection handle: 1 )

[09:16:49] CMySQLHandler::StoreResult() - No data to store.

[09:16:49] >> mysql_num_rows( Connection handle: 1 )

[09:16:49] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[09:16:49] >> mysql_query( Connection handle: 1 )

[09:16:49] CMySQLHandler::Query(UPDATE blitzer SET `Blitzerx` = '0.000000',`Blitzery` = '0.000000' ,`Blitzerz` = '0.000000', `BlitzerRotz` = '0.000000',`Geschindigkeit` = '0',`Strafe` = '0',`Punkte` = '0' ,`LastBlitz` = '' ,`Filmabschnitte` = '0',`Toleranz` = '0', `Inuse` = '0' WHERE Blitzerid = '18) - An error has occured. (Error ID: 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 ''18' at line 1)

[09:16:49] >> mysql_free_result( Connection handle: 1 )

[09:16:49] CMySQLHandler::FreeResult() - The result is already empty.

[09:16:49] >> mysql_query( Connection handle: 1 )

[09:16:49] CMySQLHandler::Query(SELECT * Blitzerx FROM `blitzer` WHERE `Blitzerid` = '19') - An error has occured. (Error ID: 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 'Blitzerx FROM `blitzer` WHERE `Blitzerid` = '19'' at line 1)

[09:16:49] >> mysql_store_result( Connection handle: 1 )

[09:16:49] CMySQLHandler::StoreResult() - No data to store.

[09:16:49] >> mysql_num_rows( Connection handle: 1 )

[09:16:49] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[09:16:49] >> mysql_query( Connection handle: 1 )

[09:16:49] CMySQLHandler::Query(UPDATE blitzer SET `Blitzerx` = '0.000000',`Blitzery` = '0.000000' ,`Blitzerz` = '0.000000', `BlitzerRotz` = '0.000000',`Geschindigkeit` = '0',`Strafe` = '0',`Punkte` = '0' ,`LastBlitz` = '' ,`Filmabschnitte` = '0',`Toleranz` = '0', `Inuse` = '0' WHERE Blitzerid = '19) - An error has occured. (Error ID: 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 ''19' at line 1)

[09:16:49] >> mysql_free_result( Connection handle: 1 )

[09:16:49] CMySQLHandler::FreeResult() - The result is already empty.

[09:17:01]

Alles anzeigen

Zitat

An error has occured. (Error ID: 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 ''19' at line 1)

Der Query

format(query,sizeof(query),"UPDATE `blitzer` SET `Blitzerx` = '%f',`Blitzery` = '%f', `Blitzerz` = '%f', `BlitzerRotz = '%f', `Geschwindigkeit` = '%d', `Strafe` = '%d', `Punkte` = '%d', `LastBlitz` = '%s', `Filmabschnitte` = '%d', `Toleranz` = '%d', `Inuse` = '%d' WHERE `Blitzerid` = '%d'",
			BlitzerInfo[id][Blitzerx], BlitzerInfo[id][Blitzery], BlitzerInfo[id][BlitzerRotz],BlitzerInfo[id][Blitzerz], BlitzerInfo[id][Geschwindigkeit], BlitzerInfo[id][Strafe], BlitzerInfo[id][Punkte], BlitzerInfo[id][LastBlitz], BlitzerInfo[id][Filmabschnitte],BlitzerInfo[id][Toleranz],BlitzerInfo[id][Inuse],BlitzerInfo[id][Blitzerid]);
			mysql_query(query);

Store und Free Result werden ausgeführt

Zitat von [DT]Beavis

SELECT * Blitzerx FROM `blitzer` WHERE `Blitzerid` = '19')

Was zum..
Poste doch mal alles da du mehr fehler hast

Das ist alles

stock SaveBlitzer()
{
new query[500];
for(new id = 0; id < MAX_BLITZER_DATA; id++)
{
//format(query,sizeof(query),"SELECT Blitzerx FROM `blitzer` WHERE `Blitzerid` = '%d'",id);
format(query,sizeof(query),"SELECT * Blitzerx FROM `blitzer` WHERE `Blitzerid` = '%d'",id);
mysql_query(query);
mysql_store_result();
if(!mysql_num_rows())
{
format(query,sizeof(query),"INSERT INTO blitzer (`Blitzerid`,`Blitzerx`,`Blitzery`,`Blitzerz`,`BlitzerRotz`,`Geschwindigkeit`,`Strafe`,`Punkte`,`LastBlitz`,`Filmabschnitte`, `Toleranz`,`Inuse`) VALUES ('%d','%f','%f','%f','%f','%d','%d','%d','%s','%d','%d','%d','%d')",
BlitzerInfo[id][Blitzerid], BlitzerInfo[id][Blitzerx], BlitzerInfo[id][Blitzery], BlitzerInfo[id][BlitzerRotz], BlitzerInfo[id][Geschwindigkeit], BlitzerInfo[id][Strafe], BlitzerInfo[id][Punkte], BlitzerInfo[id][LastBlitz], BlitzerInfo[id][Filmabschnitte], BlitzerInfo[id][Toleranz],BlitzerInfo[id][Inuse]);
mysql_query(query);
}
else
{
format(query,sizeof(query),"UPDATE `blitzer` SET `Blitzerx` = '%f',`Blitzery` = '%f', `Blitzerz` = '%f', `BlitzerRotz = '%f', `Geschwindigkeit` = '%d', `Strafe` = '%d', `Punkte` = '%d', `LastBlitz` = '%s', `Filmabschnitte` = '%d', `Toleranz` = '%d', `Inuse` = '%d' WHERE `Blitzerid` = '%d'",
BlitzerInfo[id][Blitzerx], BlitzerInfo[id][Blitzery], BlitzerInfo[id][BlitzerRotz],BlitzerInfo[id][Blitzerz], BlitzerInfo[id][Geschwindigkeit], BlitzerInfo[id][Strafe], BlitzerInfo[id][Punkte], BlitzerInfo[id][LastBlitz], BlitzerInfo[id][Filmabschnitte],BlitzerInfo[id][Toleranz],BlitzerInfo[id][Inuse],BlitzerInfo[id][Blitzerid]);
mysql_query(query);
}
mysql_free_result();
}
print("Blitzer gesaved!");
return 1;
}

Mfg

Ohman immer der selbe Fehler

Danke