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

[ken]

Here is what I found out and here is the fix:
Fix for Fedora and Drupal

update.php will not run with mod_security enabled in apache.
Findout if it is installed:
rpm -qa |grep security

Results:
mod_security-1.9.4-1.fc5

Turn it off:
cd /etc/httpd/conf.d
mv mod_security.conf mod_security.conf.off
service httpd restart

Run update:
http://website.com/update.php

Then turn mod_security back on after you have completed your site updates:
cd /etc/httpd/conf.d
mv mod_security.conf.off mod_security.conf
service httpd restart

Success!

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


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