[h4Xz0R]

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

[Zex Tan]

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*/);