[Brian_Furious]

I dont know whats happened. I've got some problemes with MySQL
I have a server hosted on ServerFFS..but when i run the server i got this:



---------------------------[16:54:50] MySQL Debugging activated (10/27/10)[16:54:50] ---------------------------[16:54:50] [16:54:50] >> mysql_connect( )[16:54:50] CMySQLHandler::CMySQLHandler() - constructor called.[16:54:50] CMySQLHandler::CMySQLHandler() - Connecting to "94.23.146.148" | DB: "damonds_test" | Username: "damonds_test"...
[16:54:50] CMySQLHandler::Connect() - Connection was successful.[16:54:50] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.[16:54:50] >> mysql_query( Connection handle: 1 )
[16:54:50] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1)
[16:54:50] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()


This is on localhost (my PC)


---------------------------[16:56:01] MySQL Debugging activated (10/27/10)[16:56:01] ---------------------------[16:56:01] [16:56:01] >> mysql_connect( )
[16:56:01] CMySQLHandler::CMySQLHandler() - constructor called.[16:56:01] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "damonds_test" | Username: "root" ...
[16:56:01] CMySQLHandler::Connect() - Connection was successful.
[16:56:01] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.[16:56:01] >> mysql_query( Connection handle: 1 )
[16:56:01] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1)
[16:56:01] CMySQLHandler::ProcessQueryThread(SELECT * FROM Vehicles) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)[16:56:01] OnQueryFinish(1,"SELECT * FROM Vehicles") - Called.
[16:56:01] >> mysql_store_result( Connection handle: 1 )[16:56:01] CMySQLHandler::StoreResult() - Result was stored.
[16:56:01] >> mysql_fetch_row_format( Connection handle: 1 )[16:56:01] >> mysql_free_result( Connection handle: 1 )
[16:56:01] CMySQLHandler::FreeResult() - Result was successfully free'd.


Whats wrong?

[DeathOnaStick]

Quote:

Originally Posted by Brian_Furious I dont know whats happened. I've got some problemes with MySQL I have a server hosted on ServerFFS..but when i run the server i got this: ---------------------------[16:54:50] MySQL Debugging activated (10/27/10)[16:54:50] ---------------------------[16:54:50] [16:54:50] >> mysql_connect( )[16:54:50] CMySQLHandler::CMySQLHandler() - constructor called.[16:54:50] CMySQLHandler::CMySQLHandler() - Connecting to "94.23.146.148" | DB: "damonds_test" | Username: "damonds_test"... [16:54:50] CMySQLHandler::Connect() - Connection was successful.[16:54:50] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.[16:54:50] >> mysql_query( Connection handle: 1 ) [16:54:50] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1) [16:54:50] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() This is on localhost (my PC) ---------------------------[16:56:01] MySQL Debugging activated (10/27/10)[16:56:01] ---------------------------[16:56:01] [16:56:01] >> mysql_connect( ) [16:56:01] CMySQLHandler::CMySQLHandler() - constructor called.[16:56:01] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "damonds_test" | Username: "root" ... [16:56:01] CMySQLHandler::Connect() - Connection was successful. [16:56:01] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.[16:56:01] >> mysql_query( Connection handle: 1 ) [16:56:01] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1) [16:56:01] CMySQLHandler::ProcessQueryThread(SELECT * FROM Vehicles) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)[16:56:01] OnQueryFinish(1,"SELECT * FROM Vehicles") - Called. [16:56:01] >> mysql_store_result( Connection handle: 1 )[16:56:01] CMySQLHandler::StoreResult() - Result was stored. [16:56:01] >> mysql_fetch_row_format( Connection handle: 1 )[16:56:01] >> mysql_free_result( Connection handle: 1 ) [16:56:01] CMySQLHandler::FreeResult() - Result was successfully free'd. Whats wrong?

I'm pretty sure that it would help us better to understand your problem, if you would post your code.

[Brian_Furious]

What code?

[Calgon]

Код:

[16:54:50] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

Print the data that is sent to the query error callback. Use/add this code:

pawn Код:

public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle) {
printf("EID: %d | Error: %s | Query: %s", errorid, error, query);
return 1;
}

And see what it shows in the console/log.

[Brian_Furious]

Quote:

Originally Posted by Calgon Код: [16:54:50] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() Print the data that is sent to the query error callback. Use/add this code: pawn Код: public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle) { printf("EID: %d | Error: %s | Query: %s", errorid, error, query); return 1; } And see what it shows in the console/log.

Thanks for the reply Calgon

pawn Код:

[13:35:05] EID: 1146 | Error: Table 'damonds_test.Vehicles' doesn't exist | Query: SELECT * FROM Vehicles

EDIT:

[Brian_Furious]

Fixed, Thanks to Calgon