Raised This Month: $ Target: $400
 0% 

Invalid database handle 0


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
HuntTheShunt
Junior Member
Join Date: Oct 2005
Old 10-17-2005 , 16:29   Invalid database handle 0
Reply With Quote #1

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:581: [MYSQL] Invalid database handle 0
L 10/17/2005 - 19:581: [AMXX] Displaying debug trace (plugin "frequentfraggerprogram.amxx")
L 10/17/2005 - 19:581: [AMXX] Run time error 10: native error (native "dbi_query")
L 10/17/2005 - 19:581: [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.
HuntTheShunt is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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