Ошибка в форуме PhPBB: Error creating new session

5. Техническая поддержка > WEB > PHP
полная ошибка:
phpBB : Critical Error
Error creating new session
SQL Error : 1016 Can't open file: 'phpbb_sessions.MYI' (errno: 145)
INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('c154190f35c297605c727edcb345a71d', 3, 1170681008, 1170681008, 'c3803563', 0, 1, 0)
нужно выполнить запросы:
repair table phpbb_sessions;
truncate table phpbb_sessions;
alter table phpbb_sessions type=myisam;

***пояснения: Those three MySQL queries, executed in order, will fix the situation. The first will likely give you an error about "table doesn't support repair option". If it does NOT, then you need to execute the third query.
The second query clears out the stale session entries, making room for new ones. The third query removes the size limitation on the table.

Add Feedback