Re: [support] Problems Upgrading to 4.7 - Unknown column 'theme'
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@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/ ]
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@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@gordiandata.net
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@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@gordiandata.net
-- [ Drupal support list | http://lists.drupal.org/ ]
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@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@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@gordiandata.net
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@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@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@gordiandata.net
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Ken Gregoire Gordian Data Inc. www.gordiandata.com ken@gordiandata.net
participants (3)
-
ken -
Kobus Myburgh -
Laura Scott