Support Request Template
What version of phpBB are you using?
What is your board's URL? http://forum.mtridersclub.co.uk
Who do you host your board with?
How did you install your board?
I used the download package from phpBB.com
Is your board a fresh install or a conversion?
Update from a previous version of phpBB3
Do you have any MODs installed?
Is registration required to reproduce this issue?
What version of phpBB3 did you update from?
What MODs do you have installed?
What styles do you currently have installed? No answer given
What language(s) is your board currently using?
Which database type/version are you using?
What is your level of experience?
Comfortable with PHP and phpBB
When did your problem begin?
It's got progressively worse over the past couple of months.
Please describe your problem.
The board is making too many connections to the database so that it's considered to be using an unfair amount of server resources and has been suspended.
The host claims the forum software does not close the MySQL connection after each run of the script. So how do I do that?
They have provided us with a log of events which doesn't really say much. here's an example:
[root@cpanel15 ~]# ps auxw | grep username
username 12171 0.0 0.2 34824 16936 ? S May03 0:00 /usr/bin/php /home/username/public_html/MTRC/search.php
username 12330 0.0 0.2 34776 16868 ? S May03 0:00 /usr/bin/php /home/username/public_html/MTRC/search.php
username 15315 0.0 0.2 40584 20796 ? S May03 0:00 /usr/bin/php /home/username/public_html/MTRC/posting.php
username 15330 0.0 0.2 35052 16660 ? S May03 0:00 /usr/bin/php /home/username/public_html/MTRC/viewtopic.php
username 15336 0.0 0.2 34536 16940 ? S May03 0:00 /usr/bin/php /home/username/public_html/MTRC/viewtopic.php
49269 username_phpb1 localhost username_phpb1 Query 37362 Copying to tmp table SELECT p.post_id FROM (phpbb_search_wordmatch m1, phpbb_search_wordmatch m2, phpbb_search_wordmatch
49312 username_phpb1 localhost username_phpb1 Query 37284 Copying to tmp table SELECT p.post_id FROM (phpbb_search_wordmatch m1, phpbb_search_wordmatch m2, phpbb_search_wordmatch
50176 username_phpb1 localhost username_phpb1 Query 36318 Locked UPDATE phpbb_posts\n\t\t\tSET post_edit_reason = '', forum_id = 24, poster_id = 94, icon_id = 0, post_ap
50179 username_phpb1 localhost username_phpb1 Query 36305 Locked SELECT t.*, f.*, p.post_approved FROM (phpbb_forums f, phpbb_posts p, phpbb_topics t) WHERE p.post_i
50182 username_phpb1 localhost username_phpb1 Query 36300 Locked SELECT p.post_id\n\tFROM phpbb_posts p\n\tWHERE p.topic_id = 8550\n\t\tAND p.post_approved = 1\n\t\t\n\t\t\n\tORDER
50184 username_phpb1 localhost username_phpb1 Query 36297 Locked SELECT p.post_id\n\tFROM phpbb_posts p\n\tWHERE p.topic_id = 8421\n\t\tAND p.post_approved = 1\n\t\t\n\t\t\n\tORDER
Generated by SRT Generator ($Rev: 4778 $)