Raised This Month: $ Target: $400
 0% 

SQL Plugin Error


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
tripc
Senior Member
Join Date: Aug 2006
Old 09-02-2008 , 01:03   SQL Plugin Error
Reply With Quote #1

I made a plugin that connect to MySQL Database on other server...
the plugin connect successful...

I have been tried to get information from the table "users"
but I get error from the plugin

Code:
[AMXX] Connecting successful.
[AMXX] no such table: users
why I'm getting that error?
tripc is offline
atomen
Veteran Member
Join Date: Oct 2006
Location: Stockholm, Sweden
Old 09-02-2008 , 02:58   Re: SQL Plugin Error
Reply With Quote #2

The plugin can't find the 'users' table.
Post the code if you can ensure yourself the table exists.
__________________
atomen is offline
Send a message via MSN to atomen
tripc
Senior Member
Join Date: Aug 2006
Old 09-02-2008 , 05:31   Re: SQL Plugin Error
Reply With Quote #3

PHP Code:
new Handle:query SQL_PrepareQuery(sql"SELECT `nick` FROM users WHERE `steamid`='STEAM_0:0:123456'"TABLEauthid)
SQL_Execute(query)
 
 if (!
SQL_NumResults(query))
 {
SQL_QueryError(queryerror127)
server_print("[AMXX] %s"error)
} else {
server_print("[AMXX] the nick has been found"
that is part from the script
tripc is offline
AbeXito
Junior Member
Join Date: Sep 2008
Old 09-02-2008 , 13:16   Re: SQL Plugin Error
Reply With Quote #4

Table `users` exists in DB you have connected to?
AbeXito is offline
Send a message via Skype™ to AbeXito
tripc
Senior Member
Join Date: Aug 2006
Old 09-02-2008 , 16:14   Re: SQL Plugin Error
Reply With Quote #5

yes, if its wasnt exists that isnt an error

Edit:
I changed the details of the DataBase
and the details are incorrect and the plugin say "Connecting successful."

can someone please give me the base of connection to the database?

Last edited by tripc; 09-02-2008 at 16:50.
tripc is offline
Reply



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 03:16.


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