View Single Post
Author Message
phela133
Member
Join Date: Apr 2008
Location: Poland/Norway
Old 03-26-2011 , 17:39   Thread worker was unable to start
Reply With Quote #1

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(FailStateHandle:QueryError[], ErrcodeData[], 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.
__________________
4Fragers.com [EasyBlock][ExpMod] - 46.4.99.111:27015

phela133 is offline
Send a message via Skype™ to phela133