Thread

Receiving the following error when try to access control panel of EE.

MySQL ERROR:
Error Number: 1146
Description: Table 'databasename.exp_sites' doesn't exist
Query: SELECT es.* FROM exp_sites AS es WHERE es.site_id = '1'

A little history up to now:

Set up a DB using phpMyAdmin on host server. Install EE successfully. Created Sections, Categories, fields, etc.

Then host company was bought by another company and migrated sites to another server. After that, couldn’t connect to DB in fact, it was gone. Didn’t have backup. :( 

Moving on I tried to create a DB locally and import through phpMyAdmin. Recieved ERROR: No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.)

I know that on the install for EE, the databse must already exist before installation. Is there a way to reconnect to the DB or should I reinstall EE?  If EE reinstall, do I need to do an unstall first.

Thanks!

What version and build of EE are you on? If you decide to reinstall, there’s no need to uninstall EE fist but you will lose all of your data, so this is probably not the first thing you’d want to try.

Version is 1.6.8. 
The database did not have much content so reinstalling isn’t totally out of the question because I might spend more time trying to find a workaround.

In that case, yes, a clean install should definitely fix things. Whatever you do, keep a backup just in case.

Ah yes. I’ve learned my lesson on backups!
Thanks!

Great. Let us know how it goes, please.