I updated a forum from 3.0.7 to 3.1.3 and then to 3.2.8 and everything went well (the errors I managed to fix). But now I'm facing a performance issue - and I can say with certainty that it's not a host issue. I tested on local host and live host.
After the upgrade everything went well except that clicking on a forum / subforum has an average time of 5 seconds for the page to load, while other pages load in 0.5 seconds. This only happens where you have a list of topics, such as forums, and also searches (active topics).
So I was sure that the problem is the phpbb_topics table and derivatives when I installed the Recent Topics by paybas extension and so ... the forum crashed!
While installing the extension and enabling to display recent topics in the index, I get the error: MYSQL server has gone away. So all my ACP is accessible and I can only go back to index by disabling the extension that loads recent topics in the index. The error I have is this:
Code: Select all
SQL ERROR [ mysqli ] MySQL server has gone away  SQL SELECT COUNT(t.topic_id) as topic_count FROM (phpbb_topics t) LEFT JOIN phpbb_topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 2) LEFT JOIN phpbb_forums_track ft ON (ft.forum_id = t.forum_id AND ft.user_id = 2) WHERE t.topic_id <> '0' AND t.topic_status <> 2 AND ((t.forum_id IN ('10', '1', '2', '3', '4', '5', '6', '7', '8', '9', '15', '14', '18', '22') OR (t.topic_visibility = 1 AND 1=0))) BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 997 CALL: trigger_error() FILE: [ROOT]/phpbb/db/driver/mysqli.php LINE: 196 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/paybas/recenttopics/core/recenttopics.php LINE: 745 CALL: phpbb\db\driver\factory->sql_query() FILE: [ROOT]/ext/paybas/recenttopics/core/recenttopics.php LINE: 288 CALL: paybas\recenttopics\core\recenttopics->gettopiclist() FILE: [ROOT]/ext/paybas/recenttopics/event/listener.php LINE: 88 CALL: paybas\recenttopics\core\recenttopics->display_recent_topics() FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php LINE: 184 CALL: paybas\recenttopics\event\listener->display_rt() FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php LINE: 46 CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch() FILE: [ROOT]/phpbb/event/dispatcher.php LINE: 62 CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch() FILE: [ROOT]/phpbb/event/dispatcher.php LINE: 46 CALL: phpbb\event\dispatcher->dispatch() FILE: [ROOT]/index.php LINE: 248 CALL: phpbb\event\dispatcher->trigger_event()
Remember that when you click directly on a topic, it loads quickly like all pages, 0.5s. The problem only happens where you have topic lists (even though they are limited to 15 topics per page).
phpBB version: 3.2.8
PHP version: 7.0.33
MYSQL version: MySQL(i) 5.7.23-23
Database size: 1.28GiB