Дамп FluxBB

не определяется чем именно ?

каким образом базу импортируете?

ТС, могу глянуть, я во FluxBB хорошо разбираюсь.

Старый форум видимо с кучей модификаций. Надо дебаг включать и смотреть, где ошибка. Скорее всего что то с несуществующими полями в таблицах БД.

Оказывается, Error: Unable to fetch guest information. от того что дамп недогрузился на хостинг.

Я сначала установил форум на хостинг и получил ошибку

An error was encountered

Error: Unable to fetch guest information.

В базе почему то нет таблицы users

Потом установил его на свой компьютер.

Базу импортировал командами:

mysql -p
use forum2
set names utf8;
source u231179_forum_2013-05-01_11-37-46.sql

Сервер начал импортировать базу, выдал ошибку подключения, потом продолжил и успешно завершил импорт:

Query OK, 102 rows affected (0.01 sec)
Records: 102  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 177 rows affected (0.03 sec)
Records: 177  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 28 rows affected (0.00 sec)
Records: 28  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 18 rows affected (0.00 sec)
Records: 18  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 40 rows affected (0.00 sec)
Records: 40  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 5450 rows affected (0.33 sec)
Records: 5450  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 941 rows affected (0.02 sec)
Records: 941  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 493 rows affected (0.00 sec)
Records: 493  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 1640 rows affected (0.02 sec)
Records: 1640  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    710
Current database: forum2

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    711
Current database: forum2

ERROR 2006 (HY000): MySQL server has gone away
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    712
Current database: forum2

Query OK, 0 rows affected (0.15 sec)

Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.91 sec)

Query OK, 0 rows affected (0.31 sec)

Query OK, 42 rows affected (0.05 sec)
Records: 42  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.08 sec)

Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    713
Current database: forum2

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    714
Current database: forum2

ERROR 2006 (HY000): MySQL server has gone away
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    715
Current database: forum2

Query OK, 0 rows affected (0.05 sec)

Query OK, 297044 rows affected (9.12 sec)
Records: 297044  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.08 sec)

Query OK, 18 rows affected (0.00 sec)
Records: 18  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 5543 rows affected (0.04 sec)
Records: 5543  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 757 rows affected (0.00 sec)
Records: 757  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 2203 rows affected (0.10 sec)
Records: 2203  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 1323 rows affected (0.15 sec)
Records: 1323  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 292 rows affected (0.01 sec)
Records: 292  Duplicates: 0  Warnings: 0

mysql> source u231179_forum_2013-05-01_11-37-46.sql

На домашнем компьютере форум запустился, но темы не открываются, пишет:

An error was encountered
File: /var/www/forum/viewtopic.php
Line: 262
FluxBB reported: The post table and topic table seem to be out of sync!

Я установил плагин AP_Forum_cleanup.php, синхронизировал темы, посты, счетчики и т.д, но оно не помогло, результат тот же - The post table and topic table seem to be out of sync!

В config.php включен режим отладки, но я в нем ничего не понимаю:

0.00014	SET NAMES 'utf8'
0.00070	SELECT u.*, g.*, o.logged, o.last_post, o.last_search FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.ident='127.0.0.1' WHERE u.id=1
0.00025	UPDATE online SET logged=1437061608 WHERE ident='127.0.0.1'
0.00032	SELECT * FROM online
0.00010	SELECT f.forum_name, f.redirect_url, f.moderators, f.num_topics, f.sort_by, fp.post_topics, 0 AS is_subscribed FROM forums AS f LEFT JOIN forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND f.id=1
0.00017	SELECT id FROM topics WHERE forum_id=1 ORDER BY sticky DESC, last_post DESC, id DESC LIMIT 0, 30
0.00015	SELECT id, poster, subject, posted, last_post, last_post_id, last_poster, num_views, num_replies, closed, sticky, moved_to, poll_type FROM topics WHERE id IN(25,77,2228,223,207,2749,2646,2733,2734,2706,2735,2727,2716,2709,2693,2678,2690,2686,2685,2684,2682,2673,2666,2660,2657,2426,2636,2631,2626,2595) ORDER BY sticky DESC, last_post DESC, id DESC
Итого время выполнения запросов: 0.00183 s