Headhunter Posted August 14, 2007 Share Posted August 14, 2007 I get this error when I log in. I really don't know code and have about 150 users on my site. Is this on my server side or my code side? ___________________________ phpBB : Critical Error Error doing DB query userdata row fetch DEBUG MODE SQL Error : 1226 User 'jaycepa1_p_bb1' has exceeded the 'max_questions' resource (current value: 50000) SELECT u.* FROM phpbb_users u, phpbb_sessions_keys k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = '98bbeb63a1cbd5b84933dade8840d93d' Line : 89 File : sessions.php Quote Link to comment https://forums.phpfreaks.com/topic/64848-am-i-hosed/ Share on other sites More sharing options...
uwannadonkey Posted August 14, 2007 Share Posted August 14, 2007 i assume its your server side SQL Error : 1226 User 'jaycepa1_p_bb1' has exceeded the 'max_questions' resource (current value: 50000) i think he asked to many questions? where is the max_questions resource changeable? Quote Link to comment https://forums.phpfreaks.com/topic/64848-am-i-hosed/#findComment-323576 Share on other sites More sharing options...
$username Posted August 14, 2007 Share Posted August 14, 2007 It looks like to me that you are not doing a mysql close connection after opening them. After you open the connection make sure to close the connection after running your SQL commands. Brett *EDIT* My bad did not read this to closely. up the limit You can change the variable from the command line, with: SET @MAX_QUESTIONS=<your new value>; For example: mysql> set @max_questions=0; Or you can open the my.cfn or my.ini and change the value there. Quote Link to comment https://forums.phpfreaks.com/topic/64848-am-i-hosed/#findComment-323579 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.