1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
[Help][MySQL]MySQL query unsuccessful.
Timmi
Little Clucker
**
Posts: 31
Threads: 7
Joined: Jan 2010
Reputation: 0
#1

31.12.2011, 13:16
So um, I've got a small problem. Let me try to make it short, so here it is:

When I start the server, I get the message "[MySQL] Connection successful!" in console. But when I join the server, and try to register or something, it gives me "[MySQL] Query Unsuccessful. (blah blah blah)". No idea why. I am using G-stylz/whatever's MySQL script, and I am on debian 5. if I load 'mysql.so', I get "libmysqlclient.so.15: cannot open shared [..]", but if I load 'mysql_debian.so', I dont get any such errors. (libmysqlclient.so.15: cannot open shared [..])

Example:
Код:
[13:23:34] [MYSQL] MySQL query unsuccessful. (INSERT INTO `playerjoins` (`joinid`, `player`, `ip`, `date`) values(NULL, 'T1mm1[XA]', '127.0.0.1', NOW()))
Script:
Код:
stock LogJoin(player[], ip[])
{
   	format(szQuery, sizeof(szQuery), "INSERT INTO `playerjoins` (`joinid`, `player`, `ip`, `date`) values\
   	(NULL, '%s', '%s', NOW())", player, ip);
   	SendQuery(szQuery);
   	return true;
}
mysql_debug.txt:

Код:
[13:23:34] ---------------------------
[13:23:34] MySQL Debugging activated (12/31/11)
[13:23:34] ---------------------------
[13:23:34]  
[13:23:34] >> mysql_ping( Connection handle: 1 )
[13:23:34] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
[13:23:34] >> mysql_ping( Connection handle: 1 )
[13:23:34] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
[13:23:34] >> mysql_query( Connection handle: 1 )
[13:23:34] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)
[13:23:34] >> mysql_ping( Connection handle: 1 )
[13:23:34] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
[13:23:34] >> mysql_query( Connection handle: 1 )
[13:23:34] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)
[13:23:34] >> mysql_store_result( Connection handle: 1 )
[13:23:34] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)
[13:23:34] >> mysql_num_rows( Connection handle: 1 )
[13:23:34] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[13:23:34] >> mysql_ping( Connection handle: 1 )
[13:23:34] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
[13:32:43] >> mysql_ping( Connection handle: 1 )
[13:32:43] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
[13:32:43] >> mysql_query( Connection handle: 1 )
[13:32:43] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)
[13:32:43] >> mysql_store_result( Connection handle: 1 )
[13:32:43] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)
[13:32:43] >> mysql_num_rows( Connection handle: 1 )
[13:32:43] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[13:32:43] >> mysql_free_result( Connection handle: 1 )
[13:32:43] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)
[13:43:56] >> mysql_ping( Connection handle: 1 )
[13:43:56] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
[13:43:56] >> mysql_query( Connection handle: 1 )
[13:43:56] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)
[13:43:56] >> mysql_store_result( Connection handle: 1 )
[13:43:56] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)
[13:43:56] >> mysql_num_rows( Connection handle: 1 )
[13:43:56] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[13:43:56] >> mysql_free_result( Connection handle: 1 )
[13:43:56] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)
That's it.. Can you help me, please? Thank you in advance.

PS: I am using DrPepper's gm, PTPM v5.9
Find
Reply
WooTFTW
Huge Clucker
***
Posts: 241
Threads: 22
Joined: May 2011
Reputation: 0
#2

31.12.2011, 13:32
Are you even connected to the database?
Find
Reply
Timmi
Little Clucker
**
Posts: 31
Threads: 7
Joined: Jan 2010
Reputation: 0
#3

31.12.2011, 13:43
I'm pretty sure I am. I've entered the host/dbname/password/username.

PS:

Код:
public mysql_start()
{
	if (mysql_connect(DBHOST, DBUSER, DBNAME, DBPASS))
	{
		mysql_debug(1);
		print("[MYSQL] Connection successful!");
	}
	else
	{
		print("[MYSQL] There was an error connecting to the MYSQL server");
		IRC_GroupSay(gGroupID, "IRC_Channel", "[MYSQL] There was an error connecting to the MYSQL server");
	}
   	return 1;
}
Find
Reply
MasterB
Little Clucker
**
Posts: 38
Threads: 7
Joined: Aug 2008
Reputation: 0
#4

31.12.2011, 14:25
server log?? does it actually say "[MYSQL] Connection successful!"
Find
Reply
Timmi
Little Clucker
**
Posts: 31
Threads: 7
Joined: Jan 2010
Reputation: 0
#5

01.01.2012, 02:38
Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3d, ©2005-2011 SA-MP Team

[03:29:24] filterscripts = ""  (string)
[03:29:24] 
[03:29:24] Server Plugins
[03:29:24] --------------
[03:29:24]  Loading plugin: irc.so
[03:29:24] 

*** IRC Plugin v1.4.2 by Incognito loaded ***

[03:29:24]   Loaded.
[03:29:24]  Loading plugin: sscanf.so
[03:29:24] 

[03:29:24]  ===============================

[03:29:24]       sscanf plugin loaded.     

[03:29:24]    © 2009 Alex "******" Cole

[03:29:24]  ===============================

[03:29:24]   Loaded.
[03:29:24]  Loading plugin: mysql_debian.so
[03:29:24] 

  > MySQL plugin R6 successfully loaded.

[03:29:24]   Loaded.
[03:29:24]  Loaded 3 plugins.

[03:29:24] 
[03:29:24] Ban list
[03:29:24] --------
[03:29:24]  Loaded: samp.ban
[03:29:24] 
[03:29:24] 
[03:29:24] Filterscripts
[03:29:24] ---------------
[03:29:24]   Loaded 0 filterscripts.

[03:32:33] [MYSQL] Connection successful!
[03:32:33] ==========================================================
[03:32:33] 			game mode stuff here
[03:32:33] 			credits etc
[03:32:33] 		irc bots connected or not
[03:32:33] 		blah blah blah
[03:32:33] 		blah blah blah
[03:32:33] 		blah blah blah
[03:32:33] ==========================================================
[03:32:33] Number of vehicle models: 118
Find
Reply
[HiC]TheKiller
High-roller
*****
Posts: 2,629
Threads: 40
Joined: Mar 2008
Reputation: 0
#6

01.01.2012, 04:55
mysql_connect returns the connection handle, not if it's successful or not. Use MySQL ping to check if the connection to the database was successful.
Find
Reply
Timmi
Little Clucker
**
Posts: 31
Threads: 7
Joined: Jan 2010
Reputation: 0
#7

01.01.2012, 05:32
Script:

Код:
public CheckSQL()
{
	new bool:connected;
	if (!mysql_ping())
	{
		connected = false;
	}
	else
	{
		connected = true;
	}
	if (connected == false)
	{
		print("[MYSQL] Lost connection to MYSQL server, Reconnecting..");
		mysql_start();
	}
	return 1;
}
mysql.txt:

Код:
[06:19:41] >> mysql_ping( Connection handle: 1 )

[06:19:41] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
Find
Reply
Kar
Banned
Posts: 2,938
Threads: 162
Joined: May 2010
#8

01.01.2012, 05:40
put mysql_start(); in OnGameModeInit and

pawn Код:
public mysql_start()
{
    mysql_debug(1);
    if (mysql_connect(DBHOST, DBUSER, DBNAME, DBPASS))
    {
        print("[MYSQL] Connection successful!");
    }
    else
    {
        print("[MYSQL] There was an error connecting to the MYSQL server");
        IRC_GroupSay(gGroupID, "IRC_Channel", "[MYSQL] There was an error connecting to the MYSQL server");
    }
    return 1;
}
Find
Reply
Timmi
Little Clucker
**
Posts: 31
Threads: 7
Joined: Jan 2010
Reputation: 0
#9

01.01.2012, 05:55
( Последний раз редактировалось Timmi; 25.03.2014 в 08:49. )
Код:
[12:18:47]  

[12:18:47] ---------------------------

[12:18:47] MySQL Debugging activated (01/01/12)

[12:18:47] ---------------------------

[12:18:47]  

[12:18:47] >> mysql_connect( )

[12:18:47] CMySQLHandler::CMySQLHandler() - constructor called.

[12:18:47] CMySQLHandler::CMySQLHandler() - Connecting to "176.9.81.250" | DB: "derp_ptpm" | Username: "derp_ptpm" ...

[12:19:08] CMySQLHandler::Connect() - Lost connection to MySQL server during query (Error ID: 2013)

[12:19:08]  

[12:19:08] ---------------------------

[12:19:08] MySQL Debugging activated (01/01/12)

[12:19:08] ---------------------------

[12:19:08]  

[12:19:08]  

[12:19:08] ---------------------------

[12:19:08] MySQL Debugging activated (01/01/12)

[12:19:08] ---------------------------

[12:19:08]  

[12:19:08] >> mysql_connect( )

[12:19:29] CMySQLHandler::Connect() - Lost connection to MySQL server during query (Error ID: 2013)

[12:21:22]  

[12:21:22] ---------------------------

[12:21:22] MySQL Debugging activated (01/01/12)

[12:21:22] ---------------------------

[12:21:22]  

[12:21:22] >> mysql_ping( Connection handle: 1 )

[12:21:22] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[12:21:22] >> mysql_ping( Connection handle: 1 )

[12:21:22] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[12:21:22] >> mysql_query( Connection handle: 1 )

[12:21:22] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[12:21:22] >> mysql_ping( Connection handle: 1 )

[12:21:22] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[12:21:22] >> mysql_query( Connection handle: 1 )

[12:21:22] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[12:21:22] >> mysql_store_result( Connection handle: 1 )

[12:21:22] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[12:21:22] >> mysql_num_rows( Connection handle: 1 )

[12:21:22] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[12:21:22] >> mysql_ping( Connection handle: 1 )

[12:21:22] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[12:21:37]  

[12:21:37] ---------------------------

[12:21:37] MySQL Debugging activated (01/01/12)

[12:21:37] ---------------------------

[12:21:37]  

[12:21:37] >> mysql_ping( Connection handle: 1 )

[12:21:37] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[12:21:37] >> mysql_ping( Connection handle: 1 )

[12:21:37] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[12:21:37] >> mysql_query( Connection handle: 1 )

[12:21:37] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[12:21:37] >> mysql_ping( Connection handle: 1 )

[12:21:37] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[12:21:37] >> mysql_query( Connection handle: 1 )

[12:21:37] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[12:21:37] >> mysql_store_result( Connection handle: 1 )

[12:21:37] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[12:21:37] >> mysql_num_rows( Connection handle: 1 )

[12:21:37] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[12:21:37] >> mysql_ping( Connection handle: 1 )

[12:21:37] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[12:23:12] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[12:23:12] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[12:23:12] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)
Still no luck. :<
Find
Reply
vent
Big Clucker
***
Posts: 144
Threads: 48
Joined: Nov 2010
Reputation: 0
#10

01.01.2012, 10:43
And now you should change the password at your MySQL server.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help