We help IT Professionals succeed at work.

user exceeded maximum number of questions...phpbb forum error

k_rasuri
k_rasuri asked
on
1,423 Views
Last Modified: 2013-12-12
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 = '6e6457954e7a8db0c979cc95365d8c2a' Line : 279 File : sessions.php

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
Comment
Watch Question

Richard QuadlingSenior Software Developer

Commented:
There is/was a bug around this ... http://bugs.mysql.com/bug.php?id=24243

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.

Top Expert 2007
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Senior Software Developer
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Richard QuadlingSenior Software Developer

Commented:
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).

Author

Commented:
Thanks guyz...i worked with the code in there and its working fine now
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.