k_rasuri
asked on
user exceeded maximum number of questions...phpbb forum error
hi there,
i had a forum that i maintained for a while..but recently it is throwing the following error
Critical Error Error updating sessions table DEBUG MODE SQL Error : 1226 User 'alldesis_p_bb1' has exceeded the 'max_questions' resource (current value: 50000) UPDATE phpbb_sessions SET session_time = 1181639570, session_page = 0 WHERE session_id = '6e6457954e7a8db0c979cc953
someone suggested me to contact the ISP to increase the maximum questions per hour. but i also heard that, by coding we can add 3 users and increase the maximum questions limitation. can any one suggest how to do that. i'm totally new to php. please be explicit...thanks in advance
i had a forum that i maintained for a while..but recently it is throwing the following error
Critical Error Error updating sessions table DEBUG MODE SQL Error : 1226 User 'alldesis_p_bb1' has exceeded the 'max_questions' resource (current value: 50000) UPDATE phpbb_sessions SET session_time = 1181639570, session_page = 0 WHERE session_id = '6e6457954e7a8db0c979cc953
someone suggested me to contact the ISP to increase the maximum questions per hour. but i also heard that, by coding we can add 3 users and increase the maximum questions limitation. can any one suggest how to do that. i'm totally new to php. please be explicit...thanks in advance
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Having said all of that, if you are on a shared host, then by grabbing more bandwidth you are stealing it from others. A sensible approach may be to talk to the ISP and ask for some sort of log of usage over time so you can see what your increase needs to be.
Say have it set to treble for a month and then see what the upper limit was, add 10% and ask for that.
If you had an extraordinary peak in activity then the upper limit may not need to be changed.
You probably also should see if you can find what the current value is so you can manually take the board offline without it crashing users. Say when you get to 95% of the limit. That way you still have 5% left to do manual admin stuff. Remember the limit applies to all your activity, not just what the board users do (ecommerce, etc).
Say have it set to treble for a month and then see what the upper limit was, add 10% and ask for that.
If you had an extraordinary peak in activity then the upper limit may not need to be changed.
You probably also should see if you can find what the current value is so you can manually take the board offline without it crashing users. Say when you get to 95% of the limit. That way you still have 5% left to do manual admin stuff. Remember the limit applies to all your activity, not just what the board users do (ecommerce, etc).
ASKER
Thanks guyz...i worked with the code in there and its working fine now
But I would STRONGLY recommend increasing the limit.
But ... http://www.karakas-online.de/forum/viewtopic.php?t=4987.
That's for phpNuke, but the principle is the same. You would need to edit config.inc/config.php (I think) to do something similar.