Questio or Error MySQL??? - Printable Version

Questio or Error MySQL??? - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Questio or Error MySQL??? (/showthread.php?tid=186095)

Questio or Error MySQL??? - Brian_Furious - 27.10.2010

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?

Re: Questio or Error MySQL??? - DeathOnaStick - 27.10.2010

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.

Re: Questio or Error MySQL??? - Brian_Furious - 28.10.2010

What code?

Re: Questio or Error MySQL??? - Calgon - 28.10.2010

Код:

[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.

Re: Questio or Error MySQL??? - Brian_Furious - 28.10.2010

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:

Re: Questio or Error MySQL??? - Brian_Furious - 28.10.2010

Fixed, Thanks to Calgon