SA-MP Forums Archive
Help me. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Help me. (/showthread.php?tid=394138)


Help me. - myhaitza97 - 21.11.2012

I have a big problem:
Код:
[23:28:58] >> mysql_query( Connection handle: 1 )

[23:28:58] CMySQLHandler::Query(UPDATE cars SET Angle='89.326828' WHERE id=8) - Successfully executed.

[23:28:59] >> mysql_query( Connection handle: 1 )

[23:28:59] CMySQLHandler::Query(UPDATE players SET Paycheck='184' WHERE id=11) - Successfully executed.

[23:28:59] >> mysql_query( Connection handle: 1 )

[23:28:59] CMySQLHandler::Query(UPDATE players SET Paycheck='224' WHERE id=12) - Successfully executed.

[23:29:00] >> mysql_query( Connection handle: 1 )

[23:29:00] CMySQLHandler::Query(UPDATE players SET Paycheck='186' WHERE id=11) - Successfully executed.

[23:29:00] >> mysql_query( Connection handle: 1 )

[23:29:00] CMySQLHandler::Query(UPDATE players SET Paycheck='226' WHERE id=12) - Successfully executed.

[23:29:01] >> mysql_query( Connection handle: 1 )

[23:29:01] CMySQLHandler::Query(UPDATE players SET Paycheck='188' WHERE id=11) - Successfully executed.

[23:29:01] >> mysql_query( Connection handle: 1 )

[23:29:01] CMySQLHandler::Query(UPDATE players SET Paycheck='228' WHERE id=12) - Successfully executed.

[23:29:02] >> mysql_query( Connection handle: 1 )

[23:29:02] CMySQLHandler::Query(UPDATE players SET Paycheck='190' WHERE id=11) - Successfully executed.

[23:29:02] >> mysql_query( Connection handle: 1 )

[23:29:02] CMySQLHandler::Query(UPDATE players SET Paycheck='230' WHERE id=12) - Successfully executed.

[23:29:02] >> mysql_query( Connection handle: 1 )

[23:29:02] CMySQLHandler::Query() - An error has occured. (Error ID: 1065, Query was empty)

[23:29:02] OnQueryError() - Called.

[23:29:02] >> mysql_reconnect( Connection handle: 1 )

[23:29:02] CMySQLHandler::Disconnect() - Connection was closed.

[23:29:02] CMySQLHandler::Connect() - Connection was successful.

[23:29:02] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[23:29:03] >> mysql_query( Connection handle: 1 )

[23:29:03] CMySQLHandler::Query(UPDATE players SET Paycheck='192' WHERE id=11) - Successfully executed.

[23:29:03] >> mysql_query( Connection handle: 1 )
After the server receives this error, it restarts.
How can i resolve it?

Sorry, for bad english!

Re: Help me. - NewerthRoleplay - 21.11.2012

A query has not got any data in it thus causing the server to crash, check the latest MySQL Query you did and see why it is not working.

Re: Help me. - myhaitza97 - 22.11.2012

In mysql log.txt.. show many errors (How can I detect in GM?), for example:
Код:
[17:48:16] CMySQLHandler::Query() - An error has occured. (Error ID: 1065, Query was empty)

[17:48:16] >> mysql_query( Connection handle: 1 )

[17:48:16] CMySQLHandler::Query() - An error has occured. (Error ID: 1065, Query was empty)

[17:48:16] >> mysql_query( Connection handle: 1 )

[17:48:16] CMySQLHandler::Query() - An error has occured. (Error ID: 1065, Query was empty)

[17:48:16] >> mysql_query( Connection handle: 1 )

[17:48:16] CMySQLHandler::Query() - An error has occured. (Error ID: 1065, Query was empty)



[17:48:16] OnQueryError() - Called.

[17:48:16] >> mysql_reconnect( Connection handle: 1 )

[17:48:16] CMySQLHandler::Disconnect() - Connection was closed.

[17:48:21] CMySQLHandler::Connect() - Connection was successful.

[17:48:21] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:48:21] >> mysql_query( Connection handle: 1 )

[17:48:21] CMySQLHandler::Query() - An error has occured. (Error ID: 1065, Query was empty)

[17:48:21] >> mysql_query( Connection handle: 1 )

[17:48:21] CMySQLHandler::Query() - An error has occured. (Error ID: 1065, Query was empty)


Re: Help me. - doreto - 22.11.2012

Did you use mysql_query(...) somewere inside a timer ?

Re: Help me. - myhaitza97 - 22.11.2012

Hmm... I create a new timer, but i not use mysql_query.