"forum_sessions" sql error occurred while fetching page

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Suggested Hosts
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
User avatar
Dragonwolf
Registered User
Posts: 603
Joined: Mon Aug 20, 2007 7:46 pm

"forum_sessions" sql error occurred while fetching page

Post by Dragonwolf » Sun Jul 24, 2016 12:20 pm

Hey there, I just checked in the error log and I've got about two pages of general SQL errors. It's telling me that the /forum_sessions "is marked as crashed and should be repaired [145]" It looks pretty serious. Can anyone help me? I'm not sure what to do. Scrolling down the list of errors I also see "Incorrect key file for table './forum_sessions.MYI'; try to repair it [126]"


An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
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]/phpbb/session.php
LINE: 372
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/cron.php
LINE: 23
CALL: phpbb\session->session_begin()
Last edited by Dragonwolf on Sun Jul 24, 2016 12:23 pm, edited 1 time in total.

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: "forum_sessions" sql error occurred while fetching page

Post by RMcGirr83 » Sun Jul 24, 2016 12:22 pm

Dragonwolf wrote:It's telling me that the /forum_sessions "is marked as crashed and should be repaired [145]"
viewtopic.php?f=46&t=1670675
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7632
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: "forum_sessions" sql error occurred while fetching page

Post by JimA » Sun Jul 24, 2016 12:27 pm

Be sure to note that you have a different table prefix, so you should adjust the query for that. :)

Code: Select all

REPAIR TABLE forum_sessions;
More information on running queries: Executing SQL Queries in phpMyAdmin
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

User avatar
Dragonwolf
Registered User
Posts: 603
Joined: Mon Aug 20, 2007 7:46 pm

Re: "forum_sessions" sql error occurred while fetching page

Post by Dragonwolf » Sun Jul 24, 2016 12:54 pm

Thanks a lot!

Locked

Return to “[3.1.x] Support Forum”