Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I just did a clean drupal installation, and then installed MERCI and got this error upon activating the module.
* user warning: Invalid default value for 'sub_type' query: CREATE TABLE merci_bucket_node ( `nid` INT unsigned NOT NULL, `vid` INT unsigned NOT NULL, `default_availability` TINYINT NOT NULL DEFAULT 0, `late_fee_per_hour` FLOAT NOT NULL DEFAULT 0, `rate_per_hour` FLOAT NOT NULL DEFAULT 0, `fee_free_hours` FLOAT NOT NULL DEFAULT 0, `sub_type` INT NOT NULL DEFAULT 'MERCI_SUB_TYPE_ITEM', PRIMARY KEY (nid, vid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/XXXXX/public_html/includes/database.inc on line 515.
* user warning: Invalid default value for 'sub_type' query: CREATE TABLE merci_resource_node ( `nid` INT unsigned NOT NULL, `vid` INT unsigned NOT NULL, `default_availability` TINYINT NOT NULL DEFAULT 0, `late_fee_per_hour` FLOAT NOT NULL DEFAULT 0, `rate_per_hour` FLOAT NOT NULL DEFAULT 0, `fee_free_hours` FLOAT NOT NULL DEFAULT 0, `sub_type` INT NOT NULL DEFAULT 'MERCI_SUB_TYPE_ITEM', PRIMARY KEY (nid, vid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/XXXXX/public_html/includes/database.inc on line 515.
and there are no "MERCI settings" for any of the content.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | merci.module.txt | 94.16 KB | civicpixel |
Comments
Comment #1
coderdan commentedComment #2
Martin S commentedI am getting exactly the same error.
Comment #3
civicpixel commentedI'm not sure what happened, but the .module file in the download is 0k. I've updated the module in CVS. Hopefully the next release that gets rolled has the correct module file. If you don't want to wait for that release to show up, I've included the update .module as a .txt. Just rename it and replace the 0k file. That should resolve your problem.