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/ ]