[m0skVi4a]

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 - 1580: [MySQL] Invalid info tuple handle: 0
L 12/22/2012 - 1580: [AMXX] Displaying debug trace (plugin "reg.amxx")
L 12/22/2012 - 1580: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 12/22/2012 - 1580: [AMXX] [0] RegisterSystem.sma::CheckClient (line 862)
L 12/22/2012 - 1580: [AMXX] [1] RegisterSystem.sma::client_authorized (line 802)
If someone can help me fixing the problem it will be great.
Thanks in advance.

[m0skVi4a]

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]

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]

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)