SQL error on update from previous dev snapshot.
bht - October 2, 2008 - 14:58
| Project: | SimpleFeed |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
This was the message:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 1 query: ALTER TABLE simplefeed_feed ALTER error SET NOT NULL in C:\drupal\www\update.php on line 77.
#1
I got the exact same warning, and the details:
The following queries were executed
simplefeed module
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
#2
Hmm this seems like a D6 bug, the install code I'm using is:
db_add_column($ret, 'simplefeed_feed', 'error', 'int(1)', array('not null' => TRUE, 'default' => 0));
I commited a patch that swaps this order. Just make that column not null in your DB (although it is a minor issue even if you don't, no problems from it).
http://drupal.org/cvs?commit=144830
--project followup subject--
Automatically closed -- issue fixed for two weeks with no activity.
#3
Automatically closed -- issue fixed for two weeks with no activity.