Updated from 4.7.4 to 5.0 and updated scheduler in the bargain. Database update failed:

Update #1
    * ALTER TABLE {scheduler} DEFAULT CHARACTER SET utf8

Update #2

    * Failed: ALTER TABLE {scheduler} CHANGE timestamp_posted publish_on int(11) NOT NULL default '0'
    * Failed: ALTER TABLE {scheduler} CHANGE timestamp_hidden unpublish_on int(11) NOT NULL default '0'
    * Failed: ALTER TABLE {scheduler} ADD timezone int(6) NOT NULL default '0'

I just went ahead and dropped the table and created it manually (C&P'd the query out of the install file.)

Comments

AjK’s picture

AjK commented
Status: Active » Fixed

I just ran this myself as a test and the update/alter commands worked fine. I expect there was something wrong with the table how it was when you ran update. Since you dropped it and recreated there's no way to know what the table looked like before. Given 1000s of users have run update without problems I guess this was a one off for you.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)