big problems ( max_updates ) common

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
engkurd
Registered User
Posts: 41
Joined: Sun Apr 01, 2007 11:46 am

big problems ( max_updates ) common

Post by engkurd »

hello

it has been months that I have like this problem
it does not appear always

but realy I would like to know what is this problem and why

look

Code: Select all

Could not update topic views.

DEBUG MODE

SQL Error : 1226 User 'kiwannet' has exceeded the 'max_updates' resource (current value: 20000)

UPDATE phpbb_topics SET topic_views = topic_views + 1 WHERE topic_id = 5802

Line : 883
File : viewtopic.php
and sometimes

Code: Select all

phpBB : Critical Error 

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1226 User 'kiwannet' has exceeded the 'max_questions' resource (current value: 50000)

SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '3d2c95f6856ff3674a574b852d72d256' AND u.user_id = s.session_user_id

note :
I asked support team of my server about this
and the replyed :
In order to avoid the error regarding "max_updates" and "max_questions" optimize the script so that is fetches more data at once instead of fetching in loops etc
but really I did not understand

please help me
abusedemailaddress
Registered User
Posts: 161
Joined: Fri Mar 24, 2006 7:18 am

Re: big problems ( max_updates ) common

Post by abusedemailaddress »

Find a better host. They're screwy. If you have no MODs installed, the number of queries that phpBB makes per page view is actually quite low, and can't be taken much lower without a whole lot of redesign, which would make for some massive tables.

They're just trying to push off responsibility for over-selling the capacity of their servers.
The abuse will continue until morale improves!
engkurd
Registered User
Posts: 41
Joined: Sun Apr 01, 2007 11:46 am

Re: big problems ( max_updates ) common

Post by engkurd »

that mean
I have to transfer my site to another host ?

the problem is from host ?
User avatar
ric323
Former Team Member
Posts: 22910
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: big problems ( max_updates ) common

Post by ric323 »

engkurd wrote:that mean
I have to transfer my site to another host ?

the problem is from host ?
Yes, and yes.
Your host has put a ridiculaously small limit on the number of database accesses your board can make.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions
engkurd
Registered User
Posts: 41
Joined: Sun Apr 01, 2007 11:46 am

Re: big problems ( max_updates ) common

Post by engkurd »

thanks a lot bro

but I asked them to solve this problem
telling them that it because of limit

and they reply that we increase it and now u will not see this problem

I will wait and see ...

thanks a lot again
Locked

Return to “2.0.x Support Forum”