AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   Invalid database handle 0 (https://forums.alliedmods.net/showthread.php?t=19474)

HuntTheShunt 10-17-2005 16:29

Invalid database handle 0
 
Hi all, (Sorry all I thought this was going to MySql stuff)
Can you help I have now got frequentfraggerprogram.amxx working thanks to the people at plugins.

My current problem is how to connect to mysql.
I have the MySql Server running with just databases
freqfragger,mysql,root
There are no tables in the freqfragger database. That is ok as the first time I get a correct connection frequentfraggerprogram.amxx will add one. ( can see that in the code )

in the sql.cfg I have tried
amx_sql_host "127.0.0.1"
//amx_sql_host "localhost"
// try anything now!
//amx_sql_host "MySQL"
//ip that server is running on
//amx_sql_host "192.168.1.129"
// in desperation public ip
//amx_sql_host "84.66.37.226"
amx_sql_user "root"
amx_sql_pass "Password mysql was setup with"
amx_sql_db "freqfragger"
amx_sql_table "freqfragger"



in the log file I have:-
L 10/17/2005 - 19:58:27: [frequentfraggerprogram.amxx] [AMXX] SQL Connection Failed
L 10/17/2005 - 19:58:31: [MYSQL] Invalid database handle 0
L 10/17/2005 - 19:58:31: [AMXX] Displaying debug trace (plugin "frequentfraggerprogram.amxx")
L 10/17/2005 - 19:58:31: [AMXX] Run time error 10: native error (native "dbi_query")
L 10/17/2005 - 19:58:31: [AMXX] [0] frequentfraggerprogram.sma::client_authorized (line 220)

And yes I am a novice at MySQL and plugins.


Of topic were are constants like USING_SQL defined/stored?
The include folder contains what in other languages would be library functions.


Any pointers welcome,
Thanks,
Hunt.


All times are GMT -4. The time now is 23:57.

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