Was ist bei dem Querry falsch? Ich verzweifle

Findet ihr den Fehler?
strcat(query,"CREATE TABLE IF NOT EXISTS `account_blacklist` (`Name` varchar(24) NOT NULL,");
for(new fID=0;fID<18;fID++)
{
strcat(query,",");
format(query,sizeof(query),"%sblacklist%i",query,fID);
strcat(query,",");
format(query,sizeof(query),"%sblacklistreason%i",query,fID);
}
strcat(query,",PRIMARY KEY (`Name`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));

Zitat von niklasbollmer

Hast du keine mysql_log.txt?

Was soll dein Script überhaupt machen? Vielleicht kann man das ja anders lösen, so dass es funktioniert.

Hier ein Auszug der mysql_log.txt

[21:34:40] Passing query CREATE TABLE IF NOT EXISTS `account_blacklist` (`Name` varchar(24) NOT NULL,,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,PRIMARY KEY (`Name`)) | 
[21:34:40] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:34:40] OnQueryError() - Called.

Zitat von 123Maffin

Was hälst du davon, den Querry auch vollständig zu machen?

Hab schon alles fertig funktioniert nur war einfach mal total verpeilt