PDOException: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB/TEXT column 'titles' can't have a default value: CREATE TABLE {custom_breadcrumb} ( `bid` INT unsigned NOT NULL auto_increment COMMENT 'Unique identifier for the custom_breadcrumb.', `name` VARCHAR(128) NULL DEFAULT NULL COMMENT 'An optional name for the custom breadcrumb.', `titles` MEDIUMTEXT NOT NULL DEFAULT '' COMMENT 'A return-delimited list of titles for the breadcrumb links.', `paths` MEDIUMTEXT NOT NULL COMMENT 'A return-delimited list of url paths for the breadcrumb links.', `visibility_php` MEDIUMTEXT NOT NULL COMMENT 'An optional PHP snippet to control the custom_breadcrumb visibility.', `node_type` VARCHAR(64) NULL DEFAULT 'AND' COMMENT 'Node types the custom_breadcrumb should apply to.', `language` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'The language this breadcrumb is for; if blank, the breadcrumb will be used for unknown languages.', PRIMARY KEY (`bid`), INDEX `language` (`language`), INDEX `node_language` (`node_type`, `language`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Stores custom breadcrumb trail overrides.'; Array ( ) in db_create_table() (line 2688 of /opt/www/apstudents/includes/database/database.inc).

CommentFileSizeAuthor
#1 installation001.patch826 byteszunaeid

Comments

zunaeid’s picture

StatusFileSize
new826 bytes

Here is the patch file that fix the issue.

colan’s picture

Title: Installation issue » BLOB/TEXT column 'titles' can't have a default value
Version: 7.x-2.0-alpha2 » 7.x-2.x-dev
Status: Active » Fixed

Sorry, your patch format didn't take, probably because the source directory is the Drupal root instead of the module's directory:

colan@dragon[Sat 24 16:29]% git am /tmp/installation001.patch
Patch format detection failed.
colan@dragon[Sat 24 16:29]% git apply /tmp/installation001.patch
error: sites/all/modules/contrib/custom_breadcrumbs/custom_breadcrumbs.install: No such file or directory

Please see Making a Drupal patch with Git or Advanced patch contributor guide for the future. Thanks for finding it though. Fixed in 4ec4b07.

kiramarch’s picture

Same issue -- this error comes when I try to install the module. Subscribing in hopes of a working patch!

colan’s picture

@kiramarch: This is fixed in the dev version. Please use that or a later release.

zunaeid’s picture

Version: 7.x-2.x-dev » 7.x-2.0-alpha3
Status: Fixed » Active

@colan:Thanks for including it.

colan’s picture

Status: Active » Fixed

Please leave as fixed unless there is still a problem.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.