Using PHP5 & MySQL 5.0.20. I've noticed several times
I'll be updating a field and it will give me an invalid
default value error. This seems easy to produce, and
it seems to be a PMA bug. To test:
Create any table.
Add a field of any type: Specify 'null' and Default
Value 'NULL'.
Save field.
Modify Field: Change 'null' to 'not null' and delete
the Default Value.
-> Error occurs.
Not null w/ no default should be perfectly legal, so
there's no reason for the error. The problem seems to
be PMA not correctly understanding the desire to remove
the default value.
Logged In: YES
user_id=210714
fixed for 2.8.2