SA-MP Forums Archive
Mysql Problem - 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)
+--- Thread: Mysql Problem (/showthread.php?tid=338339)


Mysql Problem - SanAndreasVille - 29.04.2012

Hello i have a problem with my mysql system
when too many players join, failed the connection to the server
here the mysql logs before the server crash is there a bug in the logs ?

Код:
[18:09:26] CMySQLHandler::EscapeString(mmm); - Escaped 12 characters to mmmm.
[18:09:26] >> mysql_query( Connection handle: 1 )
[18:09:26] CMySQLHandler::Query(SELECT * FROM `playerinfo` WHERE `user` = 'mmm' AND `password` = '1C3AFC9C1A5D22A1FE41AC18B070E2816B52049546C238364FA896A872546BA9A5BE527D1CB5175A1F883380D6F8E3CFDF5F8A3158D1348040BC949386204290' LIMIT 1) - Successfully executed.
[18:09:26] >> mysql_store_result( Connection handle: 1 )
[18:09:26] CMySQLHandler::StoreResult() - Result was stored.
[18:09:26] >> mysql_num_rows( Connection handle: 1 )
[18:09:26] CMySQLHandler::NumRows() - Returned 1 row(s)
[18:09:26] >> mysql_fetch_row_format( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchRow() - Return: mmm|1C3AFC9C1A5D22A1FE41AC18B070E2816B52049546C238364FA896A872546BA9A5BE527D1CB5175A1F883380D6F8E3CFDF5F8A3158D1348040BC949386204290|19|18|19|25497|87.188.177.180|0|NULL|NULL|1|29/4/2012
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("adminlvl") - 0
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("kills") - 19
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("deaths") - 18
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("ratio") - 1
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("regdate") - 29/4/2012
[18:09:26] >> mysql_free_result( Connection handle: 1 )
[18:09:26] CMySQLHandler::FreeResult() - Result was successfully free'd.
[18:09:26] >> mysql_real_escape_string( Connection handle: 1 )
[18:09:26] CMySQLHandler::EscapeString(mmm); - Escaped 12 characters to mmm.
[18:09:26] >> mysql_query( Connection handle: 1 )
[18:09:26] CMySQLHandler::Query(UPDATE `playerinfo` SET IP = '87.555555' WHERE user='mmm') - Successfully executed.
[18:27:09]  
[18:27:09] ---------------------------
[18:27:09] MySQL Debugging activated (04/29/12)
[18:27:09] ---------------------------


Re: Mysql Problem - CoaPsyFactor - 29.04.2012

use crashdetect plugin if server crash it will write you in server log what cause that crash