2 replies to this topic

[DarkGL]

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)

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
}

linijka 3099 to

SQL_ThreadQuery(g_hTuple, "handleSqlSaveDataOther", szCommand);

sprawdziłem zapytanie w pma i jest ok ale mam takie logi skończyły mi się pomysły co mogę mieć źle

[mgr inż. Pavulon]

public plugin_end()

{

	SQL_FreeHandle(g_hTuple)

}

[DarkGL]

nie pomoglo