Joomla 3.4 session error

Receive this error after the server was restarted.

Error displaying the error page: Application Instantiation Error: Table '<dbname>.<prefix>_session' doesn't exist SQL=DELETE FROM `<prefix>_session` WHERE `time` < '1431620203'
TerryDirecot of TechnologyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TerryDirecot of TechnologyAuthor Commented:
I was able to resolve the problem above by deleting the <prefix>_session.frm file and running the following script from workbench. HOWEVER.... I now receive table does not exist errors for template_styles and usergroups tables.

drop table <prefix>_session;
CREATE TABLE IF NOT EXISTS `<prefix>_session` (
 `session_id` varchar(200) NOT NULL DEFAULT '',
 `client_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
 `guest` tinyint(4) unsigned DEFAULT 1,
 `time` varchar(14) DEFAULT '',
 `data` mediumtext,
 `userid` int(11) DEFAULT 0,
 `username` varchar(150) DEFAULT '',
 PRIMARY KEY (`session_id`),
 KEY `userid` (`userid`),
 KEY `time` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Peter HartCommented:
sounds like the database has been changed and tables removed
did you change the database?
maybe restore the database from a backup

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TerryDirecot of TechnologyAuthor Commented:
The database has become completely corrupted. Had to restore. This seems to be a well known issue with InnoDB. Unfortunately, I have not seen any answers on how to prevent or recover without a restore.
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

TerryDirecot of TechnologyAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for tri-data's comment #a40829857

for the following reason:

I accept my own solution. Sadly, I only received a few guesses, and they were weeks after the event.
Peter HartCommented:
I suggested your database was corrupted.

I believe I gave you the answer
in your closing comment you have added new information that wasn't there in the question.
TerryDirecot of TechnologyAuthor Commented:
Sorry. I can accept your answer as solution if this makes you happy, but the time has been so long for a reply on this post, that I have already solved this myself.
Peter HartCommented:
I would delete the question as it had incomplete information to get an answer
TerryDirecot of TechnologyAuthor Commented:
After much research, table corruption appears to happen often with the InnoDB engine. You can find numerous Joomla posts on the internet. Unfortunately, everyone thus far has only had one option, resort to backup. There does not appear to be a way to recover with current data when InnoDB eats the tables.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Joomla

From novice to tech pro — start learning today.