Query execution was interrupted [1317]

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
TominTex
Registered User
Posts: 3
Joined: Wed Feb 02, 2011 1:46 pm

Query execution was interrupted [1317]

Post by TominTex » Wed Feb 02, 2011 1:55 pm

Whenever adding Moderator permissions or purging my cache I get this, how can I fix it? *note, purging my cache does not fix it either, I get a similar message when I do that as well.


SQL ERROR [ mysqli ]

Query execution was interrupted [1317]

SQL

SELECT a.forum_id, ug.user_id, g.group_id FROM (americanpreppersnetwork_acl_options o, americanpreppersnetwork_user_group ug, americanpreppersnetwork_groups g, americanpreppersnetwork_acl_groups a) LEFT JOIN americanpreppersnetwork_acl_roles_data r ON (a.auth_role_id = r.role_id) WHERE (o.auth_option_id = a.auth_option_id OR o.auth_option_id = r.auth_option_id) AND ((a.auth_setting = 0 AND r.auth_setting IS NULL) OR r.auth_setting = 0) AND a.group_id = ug.group_id AND g.group_id = ug.group_id AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1) AND ug.user_id IN (67, 509, 1012, 68, 359, 81, 1620, 674, 532, 1861, 91, 2569, 1292, 83, 2937, 1739, 1615, 1720, 604, 251, 901, 259, 1208, 459, 2261, 721, 433, 797, 984, 611, 488, 2262, 3924, 54, 90, 273, 64, 322, 321, 417) AND ug.user_pending = 0 AND o.auth_option LIKE 'm\\_%'

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_admin.php
LINE: 2395
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_main.php
LINE: 344
CALL: cache_moderators()

FILE: includes/functions_module.php
LINE: 518
CALL: acp_main->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

User avatar
AdamR
Former Team Member
Posts: 9731
Joined: Tue Mar 02, 2004 5:40 pm
Location: Tampa, Florida
Name: Adam Reyher
Contact:

Re: Query execution was interrupted [1317]

Post by AdamR » Thu Feb 03, 2011 6:11 am

Could you please fill out the Support Request Template so we can get a better idea of the issue?

- Adam
phpBB Support: Welcome | Userguide | Knowledge Base | Search
Honored supporter of the phpBB Group!
"If I have seen a little further it is by standing on the shoulders of Giants." - Isaac Newton

TominTex
Registered User
Posts: 3
Joined: Wed Feb 02, 2011 1:46 pm

Re: Query execution was interrupted [1317]

Post by TominTex » Thu Feb 03, 2011 3:25 pm

Support Request Template
What version of phpBB are you using? phpBB 3.0.8
What is your board's URL? http:www.americanpreppersnetwork.net
Who do you host your board with? Hostgator
How did you install your board? Someone else installed my board for me
Is your board a fresh install or a conversion? Update from a previous version of phpBB3
Do you have any MODs installed? Yes
Is registration required to reproduce this issue? Yes
What version of phpBB3 did you update from? phpBB 3.0.7
What MODs do you have installed? Custom Header Logo with custom backgrounds
User Blog Mod
Board3 Portal version 1.0.5
phpBB Gallery
Karma mod
Redbar
Advertisement Management Version: 1.0.9
What styles do you currently have installed? ProSilver
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP and phpBB
What username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
When did your problem begin? It started after I installed the sidebar: http://www.phpbb.com/community/viewtopi ... &t=2036725

But I dont think that is the problem. Not sure what is causing it.
Please describe your problem. Most of the time (but not always) whenever adding Moderator permissions or purging my cache It takes a long time and I get the following error message. how can I fix it? *note, purging my cache does not fix it either, I get a similar message when I do that as well.


SQL ERROR [ mysqli ]

Query execution was interrupted [1317]

SQL

SELECT a.forum_id, ug.user_id, g.group_id FROM (americanpreppersnetwork_acl_options o, americanpreppersnetwork_user_group ug, americanpreppersnetwork_groups g, americanpreppersnetwork_acl_groups a) LEFT JOIN americanpreppersnetwork_acl_roles_data r ON (a.auth_role_id = r.role_id) WHERE (o.auth_option_id = a.auth_option_id OR o.auth_option_id = r.auth_option_id) AND ((a.auth_setting = 0 AND r.auth_setting IS NULL) OR r.auth_setting = 0) AND a.group_id = ug.group_id AND g.group_id = ug.group_id AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1) AND ug.user_id IN (67, 509, 1012, 68, 359, 81, 1620, 674, 532, 1861, 91, 2569, 1292, 83, 2937, 1739, 1615, 1720, 604, 251, 901, 259, 1208, 459, 2261, 721, 433, 797, 984, 611, 488, 2262, 3924, 54, 90, 273, 64, 322, 321, 417) AND ug.user_pending = 0 AND o.auth_option LIKE 'm\\_%'

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_admin.php
LINE: 2395
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_main.php
LINE: 344
CALL: cache_moderators()

FILE: includes/functions_module.php
LINE: 518
CALL: acp_main->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Generated by SRT Generator ($Rev: 4778 $)

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10334
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: Query execution was interrupted [1317]

Post by Noxwizard » Sat Feb 05, 2011 3:18 am

This is most likely due to the huge amount of forums that you have. You have over 600 forums. The permission system starts to break down with large amounts of forums. It seems that your host is preempting your query before it can finish. We have seen complaints in the past about HostGator's usage restrictions.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

Locked

Return to “[3.0.x] Support Forum”