MySQL Problem.
#1

Код:
[19:48:07] CMySQLHandler::EscapeString(Albert_Casamento); - Escaped 19 characters to Albert_Casamento.

[19:48:07] >> mysql_query( Connection handle: 1 )

[19:48:07] CMySQLHandler::Query(resultID) - Threaded query with id 3 started. (Extra ID: 8)

[19:48:07] >> mysql_query( Connection handle: 1 )

[19:48:07] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
How can I fix this problem?
Reply
#2

CMySQLHandler::EscapeString(Albert_Casamento);
Connect(MySQL)::1
Reply
#3

I can't understand what am I suppose to do? Can you explain a little bit in detail pretty please.
Reply
#4

Код:
[20:26:17] CMySQLHandler::Query(UPDATE users SET Banned = '0', Second = '0', MainSkin = '1', Cash = '0', CashBank = '0', BankNO = '0', PayDay = '0' WHERE SQLID = '-1') - An error has occured. (Error ID: 2013, Lost connection to MySQL server during query)

[20:26:17] >> mysql_query( Connection handle: 1 )
Reply
#5

Add the public function OnQueryError into your mode (the parameters can be found in a_mysql.inc). Print the parameters.

For example, in R35:
pawn Код:
public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
    printf("OnQueryError(%i, \"%s\", \"%s\", \"%s\", %i)", errorid, error, callback, query, connectionHandle);
    return 1;
}
Also about the above post, look at the end: ... WHERE SQLID = '-1'
Don't you store the connection handle in a variable (assign the value mysql_connect returned to that variable) that you use it as parameter to those function is needed?
Reply
#6

Код:
[21:01:20] EID: 2014 | Error: Commands out of sync; you can't run this command now | Query: SELECT `PhoneB` FROM `phones` WHERE `PhoneNO` = '10619'
[21:01:20] 
errorid: 2014 | error: Commands out of sync; you can't run this command now | resultid: -1 | extraid: -1 | callback: NULL | query: SELECT `PhoneB` FROM `phones` WHERE `PhoneNO` = '10619'
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)