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.