Thread worker was unable to start
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:
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. |
Re: Thread worker was unable to start
This is not a fault of your plugin.
This is a fault of the SQLx where sometimes this occurs. You can search for other threads regarding this issue, but AFAIK there is no official fix. |
Re: Thread worker was unable to start
In that case please write some good mysql.
|
Re: Thread worker was unable to start
There is a simple way to get rid of that problem - save player data with only 1 query. It seems that you first check if there is data in mysql and then use update or insert. You don't need to check if data of some player was previously inserted, because you should know that from loading and even if you don't know that, then you can just use REPLACE INTO and that will work as both insert and update (you just need to set authid as PRIMARY KEY when you create table).
|
Re: Thread worker was unable to start
Hmm ok, but I have a database of valuable records, which I do not want to lose.
|
Re: Thread worker was unable to start
and what would make you lose your records?
|
| All times are GMT -4. The time now is 14:34. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.