[support] Problems Upgrading to 4.7 - Unknown column 'theme'

[Laura Scott]

If the update has not run any changes, then go through the script and  
look for the update number where it creates the table  columns you  
see in the error. Then run update again, this time manually selecting  
that update number.

If the update ran partially, then I would break out that piece to do  
it separately, and then run an update starting after the completed  
changes.

Laura

On Aug 24, 2006, at 2:34 AM, ken wrote:

> That is when I get the error, it seems to want to make sure  
> bluemarine is
> selected - which it is - and never gets to update the database with  
> the
> update.php script. It doesn't seem to matter what revision I start  
> at but
> it wants to start at 129.  Any ideas?
> BTW - thanks for replying.
> Cheers!
> Ken
>> Hi,
>>
>> It is sometimes best to start with the most obvious - did you run the
>> update script (update.php)? That upgrades the database to the latest
>> version.
>>
>> Regards,
>>
>> Kobus
>>
>>
>>>>> ken at gordiandata.net 8/24/2006 9:31 AM >>>
>> I know RTFM but I have looked everywhere and cannot find an answer to
>> this
>> problem. Here is the problem:
>> *Upgrading form 4.6.8 to 4.7.3
>> *PHP 5.1
>> *MySQL 5.0
>>
>> The error, I know it is common but I have reinstalled the themes in
>> 4.6.8,
>> made sure that set to bluemarine and still get this error:
>> user warning: Unknown column 'theme' in 'where clause' query:  
>> SELECT *
>> FROM blocks WHERE theme = 'bluemarine' AND status = 1 ORDER BY  
>> region,
>> weight, module in /var/www/html/drupal47/includes/database.mysql.inc
>> on
>> line 120.
>>
>> Question:
>> What do I have to do to patch the database or the file to get around
>> this
>> error? I think that prior upgrades some how did not get installed
>> correctly and therefore this one is a no go.
>>
>> I have also converted the database from latin1 to utf8, this did not
>> make
>> a difference.
>>
>> Thanks in advance!
>> Ken
>>
>> --
>> [ Drupal support list | http://lists.drupal.org/ ]
>> --
>> [ Drupal support list | http://lists.drupal.org/ ]
>>
>
>
> -- 
> Ken Gregoire
> Gordian Data Inc.
> www.gordiandata.com
> ken at gordiandata.net
>
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]