SA-MP Forums Archive
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)



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);
phpmyadmin is working fine too.

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(/*......*/);
}
When you're about to send a query, use the 'Conn' variable for your connection handle.

Example:
pawn Код:
mysql_tquery(Conn, /*Queries, cache, callback, format*/);