MySQL 5 error: Field 'vcard' doesn't have a default value

[mwhitlock]

When MySQL is running in strict mode (which the MySQL installer recommends), attempting to add a contact in Roundcube 0.1-beta2 fails, and this message is appended to the error log:

[07-Aug-2006 07:43:23 -0500] DB Error: DB Error: unknown error Query: INSERT INTO contacts (user_id, changed, del, name, email) VALUES ('1', now(), 0, 'Matt Whitlock', 'mwhitlock@…') [nativecode=1364 Field 'vcard' doesn't have a default value] in C:\htdocs\default\roundcube\program\include\rcube_db.inc on line 479

The column contacts.vcard is declared as a TEXT NOT NULL, so it needs to be given a value in the INSERT query.

Here are three easy solutions:

1. Change the type of the vcard column to TEXT NULL and allow it to take a NULL value by default.
2. Give the vcard column an explicit value of (empty string) in the INSERT query.
3. Change the type of the vcard column to VARCHAR(65535) NOT NULL DEFAULT . (Note that TEXT columns cannot have default values.)

[mwhitlock]

Doh! I didn't see the thing about this box using Wiki formatting.

The last paragraph is supposed to be:

Here are three easy solutions:

1. Change the type of the vcard column to TEXT NULL and allow it to take a NULL value by default.
2. Give the vcard column an explicit value of '' (empty string) in the INSERT query.
3. Change the type of the vcard column to VARCHAR(65535) NOT NULL DEFAULT ''. (Note that TEXT columns cannot have default values.)

[mwhitlock]

The same problem affects the signature field of the identities table. It prevents new identities from being created. Changing the column type to TEXT NULL made the problem disappear.

[jpingle]

May be related to #1483978

[thomasb]

Fixed in trunk ([3c3b3517])