Posted by smanes on October 9, 2008 at 4:19pm
Jump to:
| Project: | SimpleFeed |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
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
#1
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...
#2
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