Invalid MySQL handle ID. - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Invalid MySQL handle ID. (/showthread.php?tid=527173)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Invalid MySQL handle ID. (/showthread.php?tid=527173)
Invalid MySQL handle ID. - h4Xz0R - 21.07.2014
Everytime I send a MySQL query, I get an error that connection handle is invalid. It doesn't matter what the query looks like, if it's UPDATE or SELECT or anything.
I do have Apache/MySQL turned on.
Connection code:
pawn Код:
mysql_log (LOG_ERROR | LOG_WARNING | LOG_DEBUG);
mysql_connect (MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
Quote:
|
[13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_format" - invalid connection handle (id: 1) [13:46:41] [ERROR] "mysql_tquery" - invalid connection handle (id: 1) [13:46:41] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "rcrpg", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [13:46:41] [DEBUG] CMySQLHandle::Create - creating new connection.. [13:46:41] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [13:46:41] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [13:46:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [13:46:41] [DEBUG] CMySQLConnection::Connect - connection was successful [13:46:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [13:46:41] [DEBUG] mysql_errno - connection: 1 [13:46:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [13:46:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [13:46:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [13:46:41] [DEBUG] CMySQLConnection::Connect - connection was successful [13:46:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [13:46:41] [DEBUG] CMySQLConnection::Connect - connection was successful [13:46:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [13:46:41] [DEBUG] CMySQLConnection::Connect - connection was successful [13:46:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled |
Re: Invalid MySQL handle ID. - Zex Tan - 21.07.2014
My possibilities, either you entered the wrong connection handle properly.
Should be something like this,
pawn Код:
public OnGamemodeInIt()
{
new Conn = mysql_connect(/*......*/);
}
Example:
pawn Код:
mysql_tquery(Conn, /*Queries, cache, callback, format*/);