SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
SaNPower
Registered User
Posts: 2
Joined: Wed Sep 13, 2017 8:49 pm

SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Post by SaNPower » Wed Sep 13, 2017 8:53 pm

Code: Select all

SQL ERROR [ mysqli ]

User 'id2186839_phpbb' has exceeded the 'max_updates_per_hour' resource (current value: 5000) [1226]

SQL

UPDATE phpbb_ajax_chat_sessions SET username = 'SaN', user_colour = 'AA0000', user_login = 1505335849, user_lastupdate = 1505335849 WHERE user_id = 2

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/spaceace/ajaxchat/event/listener.php
LINE: 450
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: spaceace\ajaxchat\event\listener->index()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/index.php
LINE: 235
CALL: phpbb\event\dispatcher->trigger_event()
today i got this error , can anyone please help me?

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 47737
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Post by stevemaury » Wed Sep 13, 2017 11:40 pm

The error is from a table from Ajax chat. You need to ask where you got the chat extension.
For REALLY good and VERY inexpensive hosting CLICK HERE

All unsolicited PMs will be ignored.

SaNPower
Registered User
Posts: 2
Joined: Wed Sep 13, 2017 8:49 pm

Re: SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Post by SaNPower » Thu Sep 14, 2017 12:31 am

i got it from here. viewtopic.php?t=2286221

janus_zonstraal
Registered User
Posts: 1473
Joined: Sat Aug 30, 2014 1:30 pm

Re: SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Post by janus_zonstraal » Thu Sep 14, 2017 6:31 am

SaNPower wrote:
Thu Sep 14, 2017 12:31 am
i got it from here. viewtopic.php?t=2286221
Than ask it there ;)
Sorry! My English is bat ;) !!!

User avatar
3Di
Registered User
Posts: 11555
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Post by 3Di » Thu Sep 14, 2017 6:41 am

That's a problem with your host not the extension IMHO, ask them to increase (grant useage) the WITH MAX_QUERIES_PER_HOUR in your DB, which seems to be set to max 5000.
Want to compensate me for my interest? You can.
You can pm me only in case of request for paid job. Thx.
MOD conversions, Extensions and Scripts for phpBB.

rxu
Extensions Development Team
Posts: 2725
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation
Name: Ruslan
Contact:

Re: SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Post by rxu » Fri Sep 15, 2017 12:18 pm

Well, if the extension is actually updating the DB field 5000 times per hour (or per 3600 seconds, thus more than 1 time per second), that may be an issue with the extension. I'm pretty sure it shouldn't happen like that.

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20195
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Post by RMcGirr83 » Fri Sep 15, 2017 3:37 pm

So don't use an unvalidated extension on a live forum
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

User avatar
3Di
Registered User
Posts: 11555
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Post by 3Di » Fri Sep 15, 2017 7:50 pm

rxu wrote:
Fri Sep 15, 2017 12:18 pm
Well, if the extension is actually updating the DB field 5000 times per hour (or per 3600 seconds, thus more than 1 time per second), that may be an issue with the extension. I'm pretty sure it shouldn't happen like that.
That's a good point indeed.
I don't know that code but on the other side it could depend on how many users are simultaneously using the chat and the refresh time settings.. just a thought. For sure it should be optimised, giving the writer some feedback could be a good start.
Want to compensate me for my interest? You can.
You can pm me only in case of request for paid job. Thx.
MOD conversions, Extensions and Scripts for phpBB.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 17711
Joined: Fri Aug 29, 2008 9:49 am

Re: SQL ERROR [ mysqli ] User has exceeded the 'max_updates_per_hour'

Post by Mick » Sun Sep 17, 2017 8:04 am

Not forgetting that extensions are supported by their authors from wherever you downloaded them.
"The more connected we get the more alone we become" - Kyle Broflovski

Forza Garibaldi

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: cazadora2000, janus_zonstraal, JimA, KevC, rxu, Tailhook and 23 guests