By albertc on

Hi

I had a running Drupal site on my shared-hosting server and I decided to accept Fantastico's offer to upgrade the site to the current Drupal version. However, the upgrade went horribly wrong, apparently due to a Fantastico misconfiguration by my provider, and I've been left with a broken site and no backup copy (which Fantastico was supposed to make, but didn't).

The site is now giving the following error:

Fatal error: Can't open file: 'sessions.MYI' (errno: 145) query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '8a9520b0a976632a80fe82dd7b1c0263' AND u.status < 3 LIMIT 0, 1 in /home/c10blogs/public_html/includes/database.mysql.inc on line 66

Can somebody explain how to check the status of the site content, and how to recover it, if possible loading everything into a fresh install of Drupal 4.7?

Thanks for any assistance

--
Albert

Comments

albertc’s picture

albertc commented

Just in case it helps to diagnose, I just ran a DB repair and now the site is giving a different error:

user error: Unknown column 'severity' in 'field list'
query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (0, 'page not found', '<em>node</em> not found.', 1, '', '/', '213.96.61.131', 1157391051) in /home/c10blogs/public_html/includes/database.mysql.inc on line 66.


Fatal error: Unknown column 'severity' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (0, 'php', 'Unknown column \'severity\' in \'field list\' query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (0, \'page not found\', \'&lt;em&gt;node&lt;/em&gt; not found.\', 1, \'\', \'/\', \'213.96.61.131\', 1157391051) in /home/c10blogs/public_html/includes/database.mysql.inc on line 66.', 2, '', '/', '213.96.61.131', 1157391051) in /home/c10blogs/public_html/includes/database.mysql.inc on line 66

By the way, CHANGELOG.txt shows the site should be running on 4.7. Unfortunately I'm unable to remember which was the original Drupal version.

Thanks in advance
--
Albert