AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   SQL Plugin Error (https://forums.alliedmods.net/showthread.php?t=76908)

tripc 09-02-2008 01:03

SQL Plugin Error
 
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?

atomen 09-02-2008 02:58

Re: SQL Plugin Error
 
The plugin can't find the 'users' table.
Post the code if you can ensure yourself the table exists.

tripc 09-02-2008 05:31

Re: SQL Plugin Error
 
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

AbeXito 09-02-2008 13:16

Re: SQL Plugin Error
 
Table `users` exists in DB you have connected to?

tripc 09-02-2008 16:14

Re: SQL Plugin Error
 
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?


All times are GMT -4. The time now is 03:16.

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