MySQL Fehler/Errors

[16:48:03] [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 '`haus_garagepos_x` float(10,3) NOT NULL,`haus_garagepos_y` float(10,3) NOT NULL,' at line 1
[16:48:07] [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 '`pArchs0` int(2) NOT NULL,`pArchs1` int(2) NOT NULL,`pArchs2` int(2) NOT NULL,`p' at line 1
[16:48:08] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'gamemode.gm_properties' doesn't exist
[16:48:08] [ERROR] CMySQLQuery::Execute[()] - (error #1136) Column count doesn't match value count at row 1

Was hat dies zu bedeuten ? Und wo sind die Fehler die nichts funktionieren ?

Kaliber

strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_properties` (`id` int(12) NOT NULL,`haus_besitzer` varchar(24) NOT NULL");
strcat(query,",`haus_Owned` int(2) NOT NULL,`haus_innenraum` int(2) NOT NULL,`haus_miete` int(8) NOT NULL,`haus_beschreibung` varchar(150) NOT NULL,`haus_locked` int(2) NOT NULL,`haus_slots` int(3) NOT NULL,`haus_eingemitetenzaehler` int(3) NOT NULL,`haus_x` float(10,4) NOT NULL,");
strcat(query,"`haus_y` float(10,4) NOT NULL,`haus_z` float(10,4) NOT NULL,`haus_preis` int(12) NOT NULL,`haus_level` int(4) NOT NULL,`haus_geldkasse` int(12) NOT NULL,`haus_Opium` int(12) NOT NULL,");
strcat(query,"`haus_c4` int(12) NOT NULL,`haus_Ganja` int(12) NOT NULL,`haus_Kokain` int(12) NOT NULL,`haus_materials` int(12) NOT NULL,`haus_heal` int(12) NOT NULL,`haus_armour` int(12) NOT NULL,`haus_hatheal` int(12) NOT NULL,`haus_hatarmour` int(12) NOT NULL,`hausgundumper` int(2) NOT NULL,");
strcat(query,"`hausgun0` int(3) NOT NULL,`hausgun1` int(3) NOT NULL,`hausgun2` int(3) NOT NULL,`hausgun3` int(3) NOT NULL,`hausgun4` int(3) NOT NULL,`hausgun5` int(3) NOT NULL,`hausgun6` int(3) NOT NULL,`hausgun7` int(3) NOT NULL,`hausgun8` int(3) NOT NULL,`hausgun9` int(3) NOT NULL,`hausgun10` int(3) NOT NULL,`hausgun11` int(3) NOT NULL,`hausgun12` int(3) NOT NULL,");
strcat(query,"`hausgunammo0` int(8) NOT NULL,`hausgunammo1` int(8) NOT NULL,`hausgunammo2` int(8) NOT NULL,`hausgunammo3` int(8) NOT NULL,`hausgunammo4` int(8) NOT NULL,`hausgunammo5` int(8) NOT NULL,`hausgunammo6` int(8) NOT NULL,`hausgunammo7` int(8) NOT NULL,`hausgunammo8` int(8) NOT NULL,`hausgunammo9` int(8) NOT NULL,`hausgunammo10` int(8) NOT NULL,`hausgunammo11` int(8) NOT NULL,");
strcat(query,"`hausgunammo12` int(8) NOT NULL,`hausmull` int(3) NOT NULL,`haus_msg` varchar(150) NOT NULL,PRIMARY KEY (`id`),");
strcat(query,",`haus_garagepos_x` float(10,4) NOT NULL,`haus_garagepos_y` float(10,4) NOT NULL,`haus_garagepos_z` float(10,4) NOT NULL,`haus_garagevehspawn_x` float(10,4) NOT NULL,`haus_garagevehspawn_y` float(10,4) NOT NULL,`haus_garagevehspawn_z` float(10,4) NOT NULL,`haus_garagevehspawn_a` float(10,4) NOT NULL,`haus_havegarage` int(2) NOT NULL,`haus_garagelocked` int(2) NOT NULL,");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));

Was mach ich denn Falsch :O ? Es müsste sich doch erstellen..

Zitat von Kaliber

Naja, das komma am ende des Querys ist falsch...und ich schätze mal der String ist zu klein oder nicht leer...

Und was mach ich mit dem hier ?

[16:48:07] [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 '`pArchs0` int(2) NOT NULL,`pArchs1` int(2) NOT NULL,`pArchs2` int(2) NOT NULL,`p' at line 1

EDIT: Hier die Speicherung
for(new i=0;i<MAX_ARCHIVMENTS;i++)
{
mysql_format(MySqlConnection,mainquery,sizeof(mainquery),"%s,pArchs%i='%d'",mainquery,i,Spieler[playerid][pArchs][i]);
}

/push kann wer helfen ?

fail xD danke