MySQl Select DB
#1

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"
Reply
#2

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

The database does exists.
Reply
#3

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.
Reply
#4

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."
Reply
#5

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 ;/
Reply
#6

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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)