I got this error from update.php following enabling of the SimpleFeed module:

* ALTER TABLE {simplefeed_feed} ADD error int(1)
* ALTER TABLE {simplefeed_feed} ALTER error SET default 0
* UPDATE {simplefeed_feed} SET error = 0
* Failed: ALTER TABLE {simplefeed_feed} ALTER error SET NOT NULL

With MySQL5, shouldn't this be the syntax?

ALTER TABLE {simplefeed_feed} CHANGE error error int(1) NOT NULL;

Comments

m3avrck’s picture

The update code is:

  db_add_column($ret, 'simplefeed_feed', 'error', 'int(1)', array('default' => 0, 'not null' => TRUE));

Not sure why it is throwing an error then...

jrabeemer’s picture

I got this error as well..

Update #3

    * ALTER TABLE {simplefeed_feed} ADD error int(1)
    * ALTER TABLE {simplefeed_feed} ALTER error SET default 0
    * UPDATE {simplefeed_feed} SET error = 0
    * Failed: ALTER TABLE {simplefeed_feed} ALTER error SET NOT NULL