Softaculous

Topic : Ampps MySQL Error : Table 'name.setting' doesn't exist


Posted By: anynaija on July 25, 2016, 2:01 pm
Website was working recently, after i close Ampps and re-open and visited my locahost website it came up with these error for each website:

Domain1.com:

MySQL Error  : Table 'anynaija.setting' doesn't exist

Domain2.com:

Error displaying the error page: Application Instantiation Error: Table 'onplenty.#__session' doesn't exist SQL=DELETE FROM `#__session` WHERE `time` < '1469453047'

Domain3.com:

Error displaying the error page: Application Instantiation Error: No database selected SQL=SELECT `session_id` FROM `#__session` WHERE `session_id` = 'eddu14dpoh5qk4f6n2lmlfnlv2' LIMIT 1

All the three site where loading and opening without database issue but recently i can't open any of the webpage on my system because of the database error.

Note: I re-installed joomla and vbulletin on ampps successfully, and site open well. But after closing Ampps and revisited the site, both site came up with database error  Table 'ahahhah.setting' doesn't exist


Avast antivirus was disable during all these process, what could have been deleting those tables from my database or could it be Bug on Ampps?


Database error log:


Posted By: anynaija on July 25, 2016, 2:02 pm | Post: 1
Database Error log


PHP Code

 Version: '5.6.30'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-07-25 14:39:02 2508 [Warning] InnoDB: Cannot open table anynaija/datastore from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:39:06 2508 [Warning] InnoDB: Cannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:39:07 2508 [Warning] InnoDB: Cannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:39:07 2508 [Warning] InnoDB: Cannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:39:11 2508 [Warning] InnoDB: Cannot open table anynaija/setting from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:56:27 2508 [Warning] InnoDB: Cannot open table anynaija/setting from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:56:31 2508 [Warning] InnoDB: Cannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:56:32 2508 [Warning] InnoDB: Cannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:56:32 2508 [Warning] InnoDB: Cannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:59:55 2508 [Warning] InnoDB: Cannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:59:55 2508 [Warning] InnoDB: Cannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:59:55 2508 [Warning] InnoDB: Cannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-07-25 14:59:57 2508 [Warning] InnoDB: Cannot open table anynaija/setting from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.