mysql limit users
#1

Hy guys, i have done my gamemode login/register on mysql. All works beautiful and like it should work, but on the host, when are 5+ players on server, the webhost(phpmyadmin mysql) crash down , when i try to log in phpmyadmin it gives me this error and when i try to log in in game in won`t load my data..
http://postimg.org/image/irsrlze65/

In LOG here is what i have found:
Код HTML:
CMySQLHandler::Connect() - User 'zp_hid5013' has exceeded the 'max_user_connections' resource (current value: 10) (Error ID: 1226)

[20:21:43] >> mysql_real_escape_string( Connection handle: 1 )

[20:21:43] CMySQLHandler::EscapeString() - You cannot call this function now. (Reason: Dead Connection)

[20:21:43] >> mysql_real_escape_string( Connection handle: 1 )

[20:21:43] CMySQLHandler::EscapeString() - You cannot call this function now. (Reason: Dead Connection)

[20:21:43] >> mysql_query( Connection handle: 1 )
what is the problem ?
Reply
#2

I hope you're not opening a new connection for each player? The connection should be opened ONCE in OnGameModeInit and closed ONCE in OnGameModeExit.
Reply
#3

EDIT: solved, thank you very much :*
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)