I got this error.

Unknown column 'theme' in 'where clause' query: SELECT * FROM blocks WHERE theme = 'marvinclassic' AND status = 1 ORDER BY region, weight, module in /home/robbt/websites/imcbeta/includes/database.mysql.inc on line 108.

One possible point that maybe related was I just created a fresh 4.7beta 2 install and didn't copy over any of the themes or files. I just created a copy of the database from a export and then pointed the update.php at it.

Comments

metapunk’s picture

metapunk commented

Just FYI here is the info about my server PHP and MYSQL in case it is needed.
Apache/2.0.54 (Ubuntu) mod_jk2/2.0.4 PHP/5.0.5-2ubuntu1 is the version of PHP/Apache I'm running with Mysql 4.1.12

stevryn’s picture

stevryn commented

Drupal 4.7 has a whole new set of forms handling I believe, and it is no doubt necessary to update the theme to a compatible version, if such exists.

chx’s picture

chx commented
Title: SQL Error related to Theme when running update.php to 4.7 beta 2 » 4.6 database did not get (fully?) updated

form API is not responsible for bird flu and black death. Nor it is responsible for every bug. I am fed up with blaming that change for everything.

http://drupal.org/node/36242#comment-52755

Your 4.6 database did not get updated and one of the signs for this is that you have no theme field in the blocks table.

metapunk’s picture

metapunk commented

I did the same update on a server with apache 1.3 and PHP 4.4 and I got no errors, so there is definently something up with Php 5.05 that is causing issues.

metapunk’s picture

metapunk commented

Actually I did get the same error relating to theme.
Type php
Date Thursday, December 29, 2005 - 2:38pm
User Anon
Location /favicon.ico
Referrer
Message Unknown column 'theme' in 'where clause' query: SELECT * FROM blocks WHERE theme = 'marvinclassic' AND status = 1 ORDER BY region, weight, module in /home/robbt/imcbeta/includes/database.mysql.inc on line 108.

This could be due to the fact that there is no marvinclassic theme under the new filesystem.
This error was repeated 3 times in the log.

gábor hojtsy’s picture

gábor hojtsy
he/him
Primary language Hungarian
Location Hungary
commented

There is no such column in the database! Stop thinking about the missing theme. After an update, review the listed SQL commands. You will see the failed ones signed with red. Also review your watchdog entries for the error messages encountered while upgrading. You will see why the block table update failed.

drumm’s picture

drumm
he/him
Location NY, US
commented

Yes, Goba is correct, you are looking for a different error message that happened during the update process.

PHP 5.0.5 is not fully supported IIRC.

Jaza’s picture

Jaza commented
Version: 4.7.0-beta2 » 4.7.0
Status: Active » Closed (fixed)

Looks more like a theme and user-specific updating problem than a Drupal bug. Please re-open if necessary.