Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : Ampps MySQL Error : Table 'name.setting' doesn't exist



Threaded Mode | Print  

 Ampps MySQL Error : Table 'name.setting' doesn't exist, Ampps is crashing my Database and website. (1 Replies, Read 2476 times)
anynaija
Group: Member
Post Group: Newbie
Posts: 3
Status:
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:

IP: --   

Ampps MySQL Error : Table 'name.setting' doesn't exist
anynaija
Group: Member
Post Group: Newbie
Posts: 3
Status:
Database Error log


PHP Code

 Version'5.6.30'  socket''  port3306  MySQL Community Server (GPL)
2016-07-25 14:39:02 2508 [WarningInnoDBCannot open table anynaija/datastore from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table anynaija/setting from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table anynaija/setting from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table onplenty/u4x37_session from the internal data dictionary of InnoDB though the .frm file for the table existsSee 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 [WarningInnoDBCannot open table anynaija/setting from the internal data dictionary of InnoDB though the .frm file for the table existsSee http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 

IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is February 25, 2020, 10:00 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 10  |  Page Created In:0.129