AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   [MySQL] Invalid info tuple handle: 0 (https://forums.alliedmods.net/showthread.php?t=203680)

m0skVi4a 12-22-2012 09:12

[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.

m0skVi4a 12-26-2012 06:59

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

Sylwester 12-26-2012 08:07

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.

m0skVi4a 12-26-2012 08:28

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.