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

[ken]

Thanks Laura,

I think I a problem before it even runs any scripts.  Forgot to mention
get this error before I looked at the summary log:
An HTTP error 406 occured. update.php?op=do_update
Ideas?

> 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/ ]
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>


-- 
Ken Gregoire
Gordian Data Inc.
www.gordiandata.com
ken at gordiandata.net