Error after enabling 'Contact' module. Table not created! [#106266]

Location
http://localhost/arena/?q=admin/build/modules/list/confirm

Referrer
http://localhost/arena/?q=admin/build/modules

Message
BLOB/TEXT column 'recipients' can't have a default value query: CREATE TABLE contact ( cid int unsigned NOT NULL auto_increment, category varchar(255) NOT NULL default '', recipients longtext NOT NULL default '', reply longtext NOT NULL default '', weight tinyint NOT NULL default '0', selected tinyint NOT NULL default '0', PRIMARY KEY (cid), UNIQUE KEY category (category) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Web\WebServer\Apache2\htdocs\arena\includes\database.mysql.inc on line 167.

Severity
error

My current server configuration:

Drupal 5.0-RC-1
Database schema Up to date
MySQL database 5.0.27
PHP 5.2.0
Unicode library PHP Mbstring Extension
Web server Apache/2.0.59 (Win32) PHP/5.2.0

Comment	File	Size	Author
#3	contact.default.patch	965 bytes	webchick
#3

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

Aurous CreditAttribution: Aurous commented 2 January 2007 at 00:25

This happened after brand new installation. I activated multiple modules at one time (Contact, Forum, Path, Search and Upload) and deactivated (Color).

Comment #2

Aurous CreditAttribution: Aurous commented 2 January 2007 at 00:32

Deactivated Contact and uninstalled data. Showed db error of table not found, which was obvious. I then tried activating contact module again got the same error:

user warning: BLOB/TEXT column 'recipients' can't have a default value query: CREATE TABLE contact ( cid int unsigned NOT NULL auto_increment, category varchar(255) NOT NULL default '', recipients longtext NOT NULL default '', reply longtext NOT NULL default '', weight tinyint NOT NULL default '0', selected tinyint NOT NULL default '0', PRIMARY KEY (cid), UNIQUE KEY category (category) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Web\WebServer\Apache2\htdocs\arena\includes\database.mysql.inc on line 167.

Comment #3

webchick

she/they

English

Vancouver 🇨🇦

CreditAttribution: webchick commented 2 January 2007 at 00:32

Status:

Active

» Needs review

File	Size
contact.default.patch	965 bytes

Sounds like MySQL running in strict mode.

This should take care of that error (you'll need to reinstall Drupal to a test installation, or else use devel module's "reinstall module" feature on contact module). But, probably needs more testing in case it introduces some errors when editing the contact form.