Thread

Yesterday the site was fine. Made no changes. Today the site says:

“Site Error: Unable to Load Site Preferences; No Preferences Found”

Help!

* Using Multiple Site Manager, this is site #2 : http://www.medicalpracticetrends.com/

* EE Admin panel does show up

* Unable to log in as any user

* The primary site does show up, but very strange: http://emed.lawlolawl.com/

* Version 1.6.0 Build:  20070726

A) I can access the MySQL database. What do I check for?

- exp_members has one record (There should be 10 members)

B) Do I upgrade to the latest build? I don’t want to add any more confusion to debugging this

C) Is there a way to do automatic backups? Or what is the best way to back things up?

do you have a backup of your database that you could revert to? I’m not sure why users would go missing.

If your server doesn’t have automatic backups for databases there are some EE cron plugins around, but I haven’t used them.

James, you can use something like PHPMyAdmin to back up your database.

Or you can use Eskuel which is very easy to set up.

As to why you went from 10 members to 1 member, that I don’t have any idea about what could be causing this.

Do you have a backup of a previous version of your database?

I don’t have a previous version, but my web host may be able to recover it from a week ago, which should have all the stuff in it. And we will get some regular backups going, thanks for the tips.

* In which table do I find the entries?

It’s very strange.

A lot of things were reset back to the initial setup: members, custom fields, member fields, global variables…

Tags do have the tags we entered, so you can tell that it’s not just a brand new db. But maybe that is because it’s a module.

It’s like there was a reset back to the base install…

* What do you advise about going to a newer build? Now or after I get a backup of the database going?

* In which table do I find the entries?

exp_weblog_data, exp_weblog_titles

Tags do have the tags we entered, so you can tell that it’s not just a brand new db. But maybe that is because it’s a module.

Are you using Solspace’s tags module?

* What do you advise about going to a newer build? Now or after I get a backup of the database going?

After.

Tags do have the tags we entered, so you can tell that it’s not just a brand new db. But maybe that is because it’s a module.

Are you using Solspace’s tags module?

Yes, that’s the one.

Is there any mechanism in EE where it would install a previous copy of the database? Or “restore” back to an original? If someone accidentally clicked it within the admin panel it would reset?

There’s no ‘roll back’ type function in EE.  If you deinstall a module, it drops those tables- but even that isn’t what you’re seeing.  Have you talked to the host?  I have seen this a time or two when something borked on their end and the reinstalled from a backup- leaving folks wondering where more recent data went.  IF the members were added a while back and the tags are more recent?  That could be in play.

I’d talk to them, though.  I really can’t see how this would happen as a result of anything you did.  And data going ‘poof’ is highly worrisome.  See if the host has an idea.