MySQl Select DB - Printable Version

MySQl Select DB - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQl Select DB (/showthread.php?tid=101329)

MySQl Select DB - Matimor - 10.10.2009

Welcome to my re-issue with MySQL
Well, when I select the database (tables) is the MySQL plugin appends to the name of my DB. Server.log cars here:

Код:

SA:MP Dedicated Server
----------------------
v0.2X, ©2005-2008 SA:MP Team

[16:56:12] filterscripts = "" (string)
[16:56:12] 
[16:56:12] Server Plugins
[16:56:12] --------------
[16:56:12] Loading plugin: sampmysql.so
[16:56:12] 
/************************************************/
/* SAMP-MySQL v0.12 Plugin loaded successfully ! */
/************************************************/

[16:56:12]  Loaded.
[16:56:12] Loaded 1 plugins.

[16:56:12] 
[16:56:12] Filter Scripts
[16:56:12] ---------------
[16:56:12]  Loaded 0 filter scripts.

[16:56:12] MYSQL: Attempting to connect to server...
[16:56:12] 
Connection to MySQL database: Successfull !
[16:56:12] MYSQL: Database connection established.
[16:56:12] Error in mysql_query: Table 'admin_vps.cars' doesn't exist
[16:56:12] Error in mysql_store_result: Table 'admin_vps.cars' doesn't exist

To be: admin_vps and credited me admin_vps.cars
What's the problem? The map I am certainly well written!

Код:

#define MYSQL_DB  "admin_vps"

Re: MySQl Select DB - [nl]daplayer - 10.10.2009

this means that the table 'cars' in 'admin_vps' doesn't exists.

The database does exists.

Re: MySQl Select DB - Matimor - 10.10.2009

What is the correct mysql server launched but is not included.

And so after which incidentally is my table. Cars? Nowhere have I used MySql only to connect to the database, I used it.

Re: MySQl Select DB - MenaceX^ - 10.10.2009

Quote:

Originally Posted by Doom (NoZer0)

this means that the table 'cars' in 'admin_vps' doesn't exists.

The database does exists.

No, it doesn't mean that cars in admin_vops doesn't exist, it means that admin_vps.cars does not exist. Just do "CREATE TABLE and the rest."

Re: MySQl Select DB - Matimor - 10.10.2009

MenaceX^, I did it and it works but as you can see my post 2x UP? I wrote that everything starts up but the server is further Retrieving Info ;/

Re: MySQl Select DB - Matimor - 10.10.2009

Sorry, this was a bug with the Linux Putty Mailer, I now behold this error:

Код:

SA:MP Dedicated Server
----------------------
v0.2X, ©2005-2008 SA:MP Team

[10:42:54] filterscripts = "" (string)
[10:42:54] 
[10:42:54] Server Plugins
[10:42:54] --------------
[10:42:54] Loading plugin: sampmysql.so
[10:42:54] 
/************************************************/
/* SAMP-MySQL v0.12 Plugin loaded successfully ! */
/************************************************/

[10:42:54]  Loaded.
[10:42:54] Loaded 1 plugins.

[10:42:54] 
[10:42:54] Filter Scripts
[10:42:54] ---------------
[10:42:54]  Loaded 0 filter scripts.

[10:42:55] Script[gamemodes/gf.amx]: Run time error 19: "File or function is not found"

Sry For Double