Hey, ich habe in meinen MySQL Logs folgendes gefunden und wollte wissen, was das Problem ist..:
SQL
[ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[ERROR] cache_get_field_content_int - invalid datatype
oder
[14:50:08] [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 'Owned = 0,Locked = 0,Price = 0,PosX = 0.000000,PosY = 0.000000,PosZ = 0.000000,I' at line 1
Hier schon mal die UPDATE server_properties_furnitures
SQL
for(new i=0; i < MAX_GARAGES; i++){
format(query, sizeof(query), "UPDATE "#SQL_TAG"_garages SET \
Owner = %s,\
Owned = %d,\
Locked = %d,\
Price = %d,\
PosX = %f,\
PosY = %f,\
PosZ = %f,\
Interior = %d,\
UID = %d,\
WHERE UID = '%d'",
gInfo[i][Owner],
gInfo[i][Owned],
gInfo[i][Locked],
gInfo[i][Price],
gInfo[i][PosX],
gInfo[i][PosY],
gInfo[i][PosZ],
gInfo[i][Interior],
gInfo[i][UID],
gInfo[i][UID]
);}
mysql_function_query(MySqlConnection,query,false,"","");
Alles anzeigen