Jump to content

Recommended Posts

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

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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.