Code:
L 03/15/2011 - 18:37:36: [MySQL] Thread worker was unable to start. L 03/15/2011 - 18:37:36: [AMXX] Displaying debug trace (plugin "expmod.amxx") L 03/15/2011 - 18:37:36: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery") L 03/15/2011 - 18:37:36: [AMXX] [0] expmod.sma::handleSqlSaveData (line 3099)
PHP Code:
public handleSqlSaveData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize) { // lots of error checking if(Errcode) { log_amx("Error on Table query: %s",Error) } if(FailState == TQUERY_CONNECT_FAILED) { log_amx("Could not connect to SQL database.") return PLUGIN_CONTINUE } else if(FailState == TQUERY_QUERY_FAILED) { log_amx("Table Query failed.") return PLUGIN_CONTINUE } new id = Data[0]; if(SQL_MoreResults(Query)) { new szCommand[512], szAuthid[32]; get_user_authid(id, szAuthid, 31); format(szCommand, 511, "UPDATE %s SET `xp` = %i, `lvl` = %i, `pkt` = %i,`money` = %i WHERE `authid` = '%s'", gszTable, gXp[id], gLevel[id], gPoint[id], gPlayerMoney[id],szAuthid); SQL_ThreadQuery(g_hTuple, "handleSqlSaveDataOther", szCommand); } else { new szCommand[512], szAuthid[32]; get_user_authid(id, szAuthid, 31); format(szCommand, 511, "INSERT INTO %s (`authid`, `xp`, `lvl`, `pkt`,`money`) VALUES('%s', %i, %i, %i,%i)", gszTable, szAuthid, gXp[id], gLevel[id], gPoint[id], gPlayerMoney[id]); SQL_ThreadQuery(g_hTuple, "handleSqlSaveDataOther", szCommand); } return PLUGIN_CONTINUE }
Line 3099 is:
SQL_ThreadQuery(g_hTuple, "handleSqlSaveDataOther", szCommand);
I checked the query in the "phpmyadmin". It is correct, I have no more ideas how to fix it. Please help.
__________________