[HuhHuhXd]

Hello, I have a problem with the database.
After entering the server, the following error appears:

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:

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]

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]

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]

Bug solved, I had register_message twice in public_init

[Natsheh]

Originally Posted by fysiks 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.

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

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.