Timmi
31/12/2011, 02:16 PM
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
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