MySQL 6.0.67

Upgrade tried to execute:

ALTER TABLE {int_meta_fields} ALTER combine SET NOT NULL

The way to do it is simply to execute an ALTER TABLE with a MODIFY on the column, redefining it with the same type and adding NOT NULL.

e.g.

alter table int_meta_fields modify combine (int(11) NOT NULL default 0;

Comments

fractile81’s picture

fractile81 commented
Status: Active » Closed (won't fix)

My code is using the standard db_add_column(); function provided by Drupal 6.x. As such, I'm not sure that MySQL 6.x is supported by Drupal, is it? I agree that the MODIFY (or CHANGE) is the correct way to do it, but I'm not willing to deviate from using Drupal-supported DB functions since then I'd have to manually support multiple databases myself.

What was the exact error you encountered? Despite my setting it to "won't fix" since I'm using core-Drupal, please leave some feedback. I'm curious to see if there's more I actually can do here.