So, I copied my db over to a test db, and made sure to uncheck all non-core modules as well as change the theme to bluemarine. Then i untarred the drupal 4.7 files into a clean directory and changed settings.php.

When i ran update.php it autoselected version 133 (i'm not sure if this is correct, though) and ran with no problems. No errors were displayed on the screen.

When i try to go to my site, though, i get the following message:

------------------ message starts here ------------------

Page not found
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/.quangodryer/tvst/new.varal.org/includes/database.mysql.inc on line 120.

------------------ message ends here ------------------

The same happens when i visit any page on my site. I took a look at my db and found that, indeed, there is no "theme" column in "blocks". so i imagine the update script failed somewhere. The problem is that i have no idea where, since it didn't print any error message.

Comments

nedjo’s picture

The missing field was supposed to be added by system_update_145(). Were you updating from a release version? If so, which one?

tvst’s picture

It **is** a release version. The only thing is that I'm not sure which exact version it is. I know it's 4.6.x -- but what x is, i haven't a clue.

Is there any place where I can find out? I looked all over the db, with no success.

Here's something that may help: My system.module says v 1.204.2.1 2005/04/12 19:00:39.

Thanks for the reply, though

tvst’s picture

Also, does the update script write a log anywhere? If so, I should check for errors there.

Standart’s picture

I have perfectly the same issue. I installed a fresh drupal-4.6.9, then ran the update script of drupal-4.7.3. The update script showed no errors but when I open any page I see user warning: Unknown column 'theme' ....

I use Apache-2.2.2, PHP-5.1.6 and MySQL-5.0.24a.