MYSQL Error
#1

[19:40:51] MYSQL: Attempting to connect to server...
Quote:

[19:40:51] MYSQL: Connection error, retrying...
[19:40:51] MYSQL: Could not reconnect to server, terminating server...
[19:40:51] Number of vehicle models: 74
[19:40:51] --- Server Shutting Down.

Quote:

#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS "root"
#define MYSQL_DB "nestomyks"

Reply
#2

Can you show us your mysql_connect line, and try to change the MYSQL_PASS to "" meaning empty.
Reply
#3

line mysql_connect

Quote:

mysql_connect(sqlhost, sqluser, sqlpass ,sqldb);

Reply
#4

In your defines change the password line with this
Код:
#define MYSQL_PASS ""
and in change your mysql_connect with this one
pawn Код:
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
Reply
#5

What can we use instead. samp_mysql_select_db (sqldb);

Used plugins of R6.
Reply
#6

error
Reply
#7

Quote:
Originally Posted by arititlez
Посмотреть сообщение
error
You need to provide us the error.
Reply
#8

Quote:

I changed it.
#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS "nestomyks"
#define MYSQL_DB "nestomyks"

Quote:

public MySQLConnect(sqlhost[], sqluser[], sqlpass[], sqldb[]) // by Luk0r
{
print("MYSQL: Attempting to connect to server...");
mysql_connect(sqlhost, sqluser, sqldb, sqlpass);
if(mysql_ping()==0)
{
print("MYSQL: Database connection established.");
return 1;
}
else
{
print("MYSQL: Connection error, retrying...");
mysql_connect(sqlhost, sqluser, sqldb, sqlpass);
if(mysql_ping()==0)
{
print("MYSQL: Reconnection successful. We can continue as normal.");
return 1;
}
else
{
print("MYSQL: Could not reconnect to server, terminating server...");
SendRconCommand("exit");
return 0;
}
}
}

Quote:

[20:27:56] Loaded.
[20:27:56] Loading plugin: mysql
[20:27:56]

> MySQL plugin R5 successfully loaded.

[20:27:56] Loaded.
[20:27:56] Loaded 2 plugins.

[20:27:56]
[20:27:56] Filterscripts
[20:27:56] ---------------
[20:27:56] Loaded 0 filterscripts.

[20:27:56] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[20:27:56] Pickups Max = 100, Current Pickups = 234
[20:27:56] EEEEE
[20:27:56] C C RR V V E RR
[20:27:56] C R R O O O V V E R R
[20:27:56] C R R O O V V EEEEE R R
[20:27:56] C RR O O V V E RR
[20:27:56] C R R O O O V V E R R
[20:27:56] C C R R V EEEEE R R
[20:27:56] MYSQL: Attempting to connect to server...
[20:27:56] MYSQL: Connection error, retrying...
[20:27:56] MYSQL: Could not reconnect to server, terminating server...
[20:27:56] Number of vehicle models: 74
[20:27:56] --- Server Shutting Down.
[20:27:56]

*** Streamer Plugin v2.6.1 by Incognito unloaded ***

Running through it.
Reply
#9

help me please
Reply
#10

I hope you do have the right stuff where you call MYSQLConnect.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)