Download & Extend

Failures when Upgrading from Drupal 5.9 to 6.4

Project:Scheduler
Version:6.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

When attempting to upgrade from Drupal 5.9 to Drupal 6.4 I receive the following error:
update.php warning:

“# user warning: Unknown column 'timezone' in 'field list' query: UPDATE scheduler SET publish_on=publish_on-timezone WHERE publish_on<>0 in /home/stilbla0/public_html/drupal/sites/all/modules/scheduler/scheduler.install on line 79. # user warning: Unknown column 'timezone' in 'field list' query: UPDATE scheduler SET unpublish_on=unpublish_on-timezone WHERE unpublish_on<>0 in /home/stilbla0/public_html/drupal/sites/all/modules/scheduler/scheduler.install on line 80. # user warning: Can't DROP 'timezone'; check that column/key exists query: ALTER TABLE scheduler DROP COLUMN timezone in /home/stilbla0/public_html/drupal/sites/all/modules/scheduler/scheduler.install on line 81. # user warning: Table 'stilbla0_StillTruth.amazon_item' doesn't exist query: ALTER TABLE amazon_item ADD mpn varchar(128) in /home/stilbla0/public_html/drupal/update.php on line 69.
--Drupal database update

Farther down the page there is a failure listed:
Failures:

“scheduler module Update #6100 * Failed: UPDATE {scheduler} SET publish_on=publish_on-timezone WHERE publish_on<>0 * Failed: UPDATE {scheduler} SET unpublish_on=unpublish_on-timezone WHERE unpublish_on<>0 * Failed: ALTER TABLE {scheduler} DROP COLUMN timezone
--Drupal database update
    Information:
  • Upgrading from Drupal 5.9 (Scheduler 5.x-1.16) to Drupal 6.3 (Scheduler 6.x-1.2 ).
  • Running http://example.com/update.php shows that even with the Scheduler module disabled in 5.9 before the conversion The scheduler module: was going to upgrade (upgrade number: 6100).

Questions:

  1. How fatal is that error? Is it a show stopper from my site going live?
  2. Should I do any database edits or drop tables or whatever? (I'd honestly rather not, my Sql fu is pretty weak.)

Comments

#1

This is a bug.
But you don't need to worry if scheduler still publishes and unpublishes as expected.

#2

Status:active» fixed

Fixed in http://drupal.org/cvs?commit=150436

#3

Fixed in 6.x-1.3

#4

Status:fixed» closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

nobody click here