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 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? 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. Link to comment https://forums.phpfreaks.com/topic/64848-am-i-hosed/#findComment-323579 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.