[MySQL] Invalid info tuple handle: 0
1 Attachment(s)
I am updating my Register System and i am trying to fix the bug with MYSQL.
I can't understand why, but on 2 different servers there is no problem. But when i give the plugin to friend of mine the system gives this: L 12/22/2012 - 15:38:30: [MySQL] Invalid info tuple handle: 0 L 12/22/2012 - 15:38:30: [AMXX] Displaying debug trace (plugin "reg.amxx") L 12/22/2012 - 15:38:30: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery") L 12/22/2012 - 15:38:30: [AMXX] [0] RegisterSystem.sma::CheckClient (line 862) L 12/22/2012 - 15:38:30: [AMXX] [1] RegisterSystem.sma::client_authorized (line 802) If someone can help me fixing the problem it will be great. Thanks in advance. |
Re: [MySQL] Invalid info tuple handle: 0
1 Attachment(s)
I realized that when I turn on the server it gives that the system didn't connected. But when I restart the server it says Connection successesful. Why is this happenning? Other plugins like admin_sql.amxx are connecting without restarting. I recoded my system like admin_sql.amxx but it is the same.
L 12/26/2012 - 13:54:08: Start of error session. L 12/26/2012 - 13:54:08: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20121226.log") L 12/26/2012 - 13:54:08: [AMXX] Plugin ("RegisterSystem.amxx") is setting itself as failed. L 12/26/2012 - 13:54:08: [AMXX] Plugin says: [REGISTER SYSTEM] Could not connect to database! L 12/26/2012 - 13:54:08: [AMXX] Displaying debug trace (plugin "RegisterSystem.amxx") L 12/26/2012 - 13:54:08: [AMXX] Run time error 1: forced exit L 12/26/2012 - 13:54:08: [AMXX] [0] RegisterSystem.sma::plugin_cfg (line 678 ) No problem on admin_sql.amxx |
Re: [MySQL] Invalid info tuple handle: 0
Print data you use to create tuple when you create it to see if it's valid. You probably retrieve it from cvars before the .cfg is executed.
|
Re: [MySQL] Invalid info tuple handle: 0
formatex(query, charsmax(query), "CREATE TABLE IF NOT EXISTS registersystem (Name VARCHAR(32), Password VARCHAR(34), Status VARCHAR(10))")
SQL_ThreadQuery(g_sqlconn, "QueryCreateTable", query) |
| All times are GMT -4. The time now is 01:30. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.