A shaky recovery?

By Michael Fraase

Thursday, 14 August 2008 07:50PM CST

Section: Announcements

Recovery Houston, we may have at least partial recovery. While there are still some problems with the database, I think I’ve recovered the lost entries. Here’s how I did it; don’t try this at home:

  1. Ran a SQL query with a record ID that matched the first missing entry. That created a bogus record in the titles table.
  2. Through the Expression Engine control panel, I edited the new bogus title and it’s associated entry.
  3. Searched Google (it may be evil, but it has its uses) to locate the entry; loaded Google’s cached version in a browser window.
  4. Edited the entry in the Expression Engine control panel to match the title, category, date, and time in the Google cached record. (Found a lot of splogs that have stolen my content as a bonus benefit.)
  5. Saved the edited entry in the Expression Engine control panel.
  6. Rinsed and repeated for each of the remaining lost entries.
  7. Backed up the database and promised myself to do so regularly.

There are clearly still some problems, and I have no idea how serious they are. When I try to upload an image, I get the following error:

Notice: Undefined index: last_cache_clear in 
/www/xxxxxxxx/public_html/xxxxxxxx/core/core.system.php on line 944

This is probably related to corrupted/incomplete information in the exp_stats MySQL database table which is also most likely responsible for the error messages I’m receiving in the Expression Engine Control Panel.

Permalink | (0) Comments

Page 1 of 1 pages