AlliedModders

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

HuhHuhXd 01-13-2024 08:17

[MySQL] Invalid info tuple handle: 0
 
1 Attachment(s)
Hello, I have a problem with the database.
After entering the server, the following error appears:
Code:

L 01/13/2024 - 14:07:18: [MySQL] Invalid info tuple handle: 0
L 01/13/2024 - 14:07:18: [AMXX] Displaying debug trace (plugin "paintballmod.amxx", version "3.4")
L 01/13/2024 - 14:07:18: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 01/13/2024 - 14:07:18: [AMXX]    [0] paintballmod.sma::client_putinserver (line 171)


while after entering the /modele command, the following error appears:

Code:

L 01/13/2024 - 14:13:18: [MySQL] Invalid info tuple handle: 0
L 01/13/2024 - 14:13:18: [AMXX] Displaying debug trace (plugin "paintballmod.amxx", version "3.4")
L 01/13/2024 - 14:13:18: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 01/13/2024 - 14:13:18: [AMXX]    [0] paintballmod.sma::WczytajMedale (line 1192)
L 01/13/2024 - 14:13:18: [AMXX]    [1] paintballmod.sma::RankingMedali (line 1262)
L 01/13/2024 - 14:13:18: [AMXX]    [2] paintballmod.sma::MenuMedali_ (line 1240)

I don't know how to fix it, please help.

fysiks 01-13-2024 17:16

Re: [MySQL] Invalid info tuple handle: 0
 
Have you verified that you can actually connect to your database successfully with your credentials? Also verify that your database is allowed to be access by your server because many web hosts will block external connections by default.

HuhHuhXd 01-14-2024 06:57

Re: [MySQL] Invalid info tuple handle: 0
 
How to do it? I have the mod running on localhost, as well as the database (xampp) on localhost, the table was not created, so I created it and it still doesn't work.

HuhHuhXd 01-14-2024 09:35

Re: [MySQL] Invalid info tuple handle: 0
 
Bug solved, I had register_message twice in public_init

Natsheh 01-18-2024 19:06

Re: [MySQL] Invalid info tuple handle: 0
 
Quote:

Originally Posted by fysiks (Post 2816006)
Have you verified that you can actually connect to your database successfully with your credentials? Also verify that your database is allowed to be access by your server because many web hosts will block external connections by default.

Code:

[MySQL] Invalid info tuple handle: 0
Invalid info tuple handle has nothing to do with connecting to the database, it prepares the connection credentials into a tuple for connection...

fysiks 01-18-2024 21:18

Re: [MySQL] Invalid info tuple handle: 0
 
Ok, so if that is the case, how is that even possible considering that this condition (a value of 0) is explicitly checked and if it was actually 0, the plugin would be put into a failed state. See line 131.

Feel free to help the OP.


All times are GMT -4. The time now is 02:29.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.