By allie on

This was posted elsewhere but I have moved it, as this is the more appropriate location, as pwolanin pointed out to me.

The database might not be perfect...but I have my user list, my basic content, etc. I don't know if the software is robust enough to handle our usage. I do need someone to walk me thru what I need to do...

Upgrade Disaster
allie - October 1, 2006 - 00:03
Project: Drupal
Version: 4.7.3
Component: other
Category: support
Priority: critical
Assigned: Unassigned
Status: active
Description

Our site crashed originally because of a server error (limited memory), and pretty much degraded over a period of two months, then was completely blank for a few days. Then, everything was wiped, corruption in the database was found and corrected, and now we have the basic appearance of being back--but we're not back.
We have an assortment of errors that just escalated.

Please help us get back on our feet?

Sample error messages follow:

Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'drupal1.node_revisions' doesn't exist\nquery: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 20 in /home/novelspot/www/www/includes/database.mysql.inc on line 120.', 2, '', 'http://novelspot.net/about_us', 'http://novelspot.net/', '66.61.53.48', 1159657774) in /home/novelspot/www/www/includes/database.mysql.inc on line 120

Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'drupal1.node_revisions' doesn't exist\nquery: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 20 in /home/novelspot/www/www/includes/database.mysql.inc on line 120.', 2, '', 'http://novelspot.net/about_us', 'http://novelspot.net/', '66.61.53.48', 1159657774) in /home/novelspot/www/www/includes/database.mysql.inc on line 120

Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Unknown column 'referer' in 'field list'\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', 'node/20 not found.', 1, '', 'http://novelspot.net/about_us', 'http://novelspot.net/', '66.61.53.48', 1159657774) in /home/novelspot/www/www/includes/database.mysql.inc on line 120.', 2, '', 'http://novelspot.net/about_us', 'http://novelspot.net/', '66.61.53.48', 1159657774) in /home/novelspot/www/www/includes/database.mysql.inc on line 120

Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Unknown column 'theme' in 'where clause'\nquery: SELECT * FROM blocks WHERE theme = 'bluemarine' AND status = 1 ORDER BY region, weight, module in /home/novelspot/www/www/includes/database.mysql.inc on line 120.', 2, '', 'http://novelspot.net/about_us', 'http://novelspot.net/', '66.61.53.48', 1159657774) in /home/novelspot/www/www/includes/database.mysql.inc on line 120
Page not found

user warning: Table 'drupal1.node_revisions' doesn't exist query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 20 in /home/novelspot/www/www/includes/database.mysql.inc on line 120.
user warning: Table 'drupal1.node_revisions' doesn't exist query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 20 in /home/novelspot/www/www/includes/database.mysql.inc on line 120.
user warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', 'node/20 not found.', 1, '', 'http://novelspot.net/about_us', 'http://novelspot.net/', '66.61.53.48', 1159657774) in /home/novelspot/www/www/includes/database.mysql.inc on line 120.
user warning: Unknown column 'theme' in 'where clause' query: SELECT * FROM blocks WHERE theme = 'bluemarine' AND status = 1 ORDER BY region, weight, module in /home/novelspot/www/www/includes/database.mysql.inc on line 120.

⋅ Categories: Drupal 4.7.x

Comments

allie’s picture

allie commented

For starters, the .htaccess file is this:

RewriteEngine on
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?q=$1 [L,QSA]

We have an assortment of database files (in 2 each in 2 separate folders--one folder is the update and one is the pre-existing) and I'm not sure which is being engaged; but the one you see when you go to mysql has the intact information.

I'm happy to answer any questions if anyone can point me in a direction where to start...

vm’s picture

vm commented

if i understand this correctly you are upgrading from 4.6 to 4.7 ?

if so you missed the step about shutting off pre existing contrib modules first. (there will also have to be updated to 4.7 versions prior to re enabling them and running update.php)

I found this videocast very very helpful with regards to updating drupal. http://drupal.org/videocasts/upgrading-to-4.7

allie’s picture

allie commented

The database is saved...that's all I've got.

We had two months worth of sitting around getting in worse and worse shape before this, so that there wasn't really anything good to backup. I guess I'm looking at wiping everything, installing 4.7 and then doing an infinite quantity of manual labor inputting something like 2000 nodes. Hari kari is starting to look tempting.

This may sound rather stupid...but...what if I wiped everything, installed 4.6, added my modules, and attached to the saved database...would there be any chance that I'd get a usable result? Because then--on the remote condition that it worked--I could then toss out the modules, save and upgrade correctly to 4.7. (It would also give me the opportunity to dispose of a humongous year-long log, stats and stuff.)

vm’s picture

vm commented

i take it you didnt back up the site before doing the upgrade, both database AND files ? If you did, i would use these backups.

If you don't have previous backups I suppose at this point you don't have anything to lose by trying to revert your file structure backwards, provided your backup of the db is a 4.6 backup and not a 4.7 back up.

although your db errors are letting you know the necessary modules that you have enabled havent been installed. you may also choose to look into the devel.module to better explain some of your problems. At the mimimum it will help you reinstall modules.

Updating the modules from the versions you had running to the new ones may work also.

it is normal, as shown in the videocast i link you too, for there to be certain errors while updating (upgrading) modules. once the modules are installed, updated and enabled, the errors are handled and fixed.

allie’s picture

allie commented

I didn't install anything initially-I had a web person who found the drupal software over a year ago (with which I have been supremely delighted) but he has been too busy, and also, he didn't take me (and my 46 person staff, and 570 member authors) to raise.

By the way, if it had been marginally usable, I'd have backed it up. But at that point, it was kind of like a car with square wheels, no door key, dragging a trailer with a whole lotta cargo that disappeared when you tried to find it.

The site had been invisible for 2 or 3 days. I logged in and all the drupal files had been scooted into a sub directory, and the front directory was blank. I have 570 subscribers nagging me for TWO months over the site being screwed up and no word from my web guy for weeks after copious emails. The site would not come up--(500 server error) corrected by my wonderful provider suresoft who gave me more ram to play with. I put up another site for a condo group (bavarianvillageassociation.com) pretty much just to get the experience working with installation. Of course, it's pretty vanilla and I tweaked nothing.

For the past month half of the urls on my site were clean and half were not. Nothing was working correctly, the "index" pages had disappeared, and every link had to be manually configured, (either "=?" added or subtracted. When I looked at the db, everything seemed to be there. Something had been done there on Sept 3 but nothing else that I could see. The pages weren't coming up anyway, and I hadn't been able to log in since early or mid Sept. My web guy had suggested some other software (perhaps motivated by the lack of memory--but perhaps I can get feedback about that here...maybe we shouldn't have run statistics, or logged errors--I'll have to find out and discard inessential memory usage. I think the only backup I might have is 4.5, before we went to 4.6. It was working then, but is totally different.

The db backup was 4.6 and running on msql 4.0. Any suggestions would be welcomed before (and during) the time I tackle this. (I've already used the mysl feature of saving the individual components to word so that if I have to do this manually, I have an alternative style of backup which I pray I don't have to use.)

(Getting way ahead of myself...) I like the look of the holy grail theme, but even if I had everything working (and when I do get everything working) I won't go NEAR anything that is remotely flawed. Well, we never did run anything but one of the themes that came with the software, though admittedly our web guy had managed some nice tweaks. At least I think he did them.

Anyway, wish me luck and offer me suggestions. I need all the help I can get. Clean urls here i come (I hope i hope i hope)