Posts: 53
Threads: 12
Joined: Feb 2015
Quote:
Originally Posted by EiresJason
Have you tried just updating one field and have you made sure all of the fields actually exist in the table? I can't see an issue with the query being sent so my next thought would be one/more of the fields don't exist.
Maybe just try this and see what happens?
pawn Код:
format(query, sizeof(query), "UPDATE `misc` SET");
format(query, sizeof(query), "%s `gMOTD` = '%s',", query, g_mysql_ReturnEscaped(GlobalMOTD, MainPipeline));
mysql_function_query(MainPipeline, query, false, "OnQueryFinish", "i", SENDDATA_THREAD);
Even if you have checked the fields several times, just make sure all fields exist and match the case aswell. |
This is exactly what i mean, The fields / misc table was empty first then when it g_mysql_SaveMOTD. It doesnt save to the misc table. Is it because its empty?
NOTE : Before saving the MOTD the misc table is empty. Is there any query that can make those fields?
