Проблема возникла при переносе форума на phpBB на другой хостинг. Алгоритм переноса был таким:
1. Перенос файлов
2. Перенос базы данных через встроенную функцию резервного копирования
3. Правка файла конфига.
4. Очистка папки cache
Беда в том, что пришлось поменять драйвер базы данных с mysql на mysqli, поскольку на старом драйвере движок форума совсем не завелся, с ошибкой:
- Ошибка
- Код: Выделить всё
General Error
SQL ERROR [ mysql4 ]
mysql_connect function does not exist, is mysql extension installed? []
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
- Спойлер
- Код: Выделить всё
Общая ошибка
SQL ERROR [ mysqli ]
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'scforum.f.forum_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]
SQL
SELECT f.forum_id, f.forum_name, t.*, u.user_id, u.username, u.user_colour, MATCH (t.topic_title) AGAINST ('косметалогия перманетный макияж новинка') AS relevance FROM (sclassclinic_phpbb_topics t CROSS JOIN sclassclinic_phpbb_forums f CROSS JOIN sclassclinic_phpbb_users u) WHERE MATCH (t.topic_title) AGAINST ('косметалогия перманетный макияж новинка') >= 0.5 AND f.forum_id IN (7, 8, 9, 13, 25, 26, 27, 28, 29, 31, 32, 33, 34, 35, 36, 37, 39, 42, 43, 44, 45, 51, 52, 53, 54, 56, 57, 58, 59, 61, 62, 63, 65, 67, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 81, 82, 83) AND t.topic_status <> 2 AND t.topic_id <> 1867 AND (f.forum_id = t.forum_id OR (t.topic_type = 3 AND f.forum_type = 1)) AND t.topic_poster = u.user_id GROUP BY t.topic_id ORDER BY relevance LIMIT 5
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/includes/db/dbal.php
LINE: 754
CALL: trigger_error()
FILE: [ROOT]/includes/db/mysqli.php
LINE: 189
CALL: dbal->sql_error()
FILE: [ROOT]/includes/db/mysqli.php
LINE: 231
CALL: dbal_mysqli->sql_query()
FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()
FILE: [ROOT]/includes/hooks/hook_similar_topic.php
LINE: 154
CALL: dbal->sql_query_limit()
FILE: [ROOT]/includes/hooks/hook_similar_topic.php
LINE: 356
CALL: search_similar_topics()
FILE: (not given by php)
LINE: (not given by php)
CALL: display_similar_topic()
FILE: [ROOT]/includes/hooks/index.php
LINE: 141
CALL: call_user_func_array()
FILE: [ROOT]/includes/template.php
LINE: 208
CALL: phpbb_hook->call_hook()
FILE: [ROOT]/includes/functions.php
LINE: 4923
CALL: template->display()
FILE: [ROOT]/viewtopic.php
LINE: 1811
CALL: page_footer()