Download & Extend
Support Nag » Issues

PDOException: SQLSTATE[42000]: Syntax error by installing/enabling via Drush

Posted by Digidog on January 3, 2012 at 6:37pm
Project:Support Nag
Version:7.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active

Issue Summary

<?php
WD php: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB/TEXT column 'message'     [error]
can't have a default value: CREATE TABLE {support_nags} (
`nagid` INT unsigned NOT NULL auto_increment,
`action` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Nag action to perform.',
`clients` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'List of all clients affected by this nag.',
`states` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'List of all states affected by this nag.',
`priorities` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'List of all priorities affected by this nag.',
`assigned` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'List of all assigned users affected by this nag.',
`mailto` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Notification recipients.',
`subject` VARCHAR(128) NOT NULL DEFAULT '' COMMENT 'Notification subject.',
`message` TEXT NOT NULL DEFAULT '' COMMENT 'Notification or update message text.',
`frequency` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Frequency to send notification or update ticket.',
`last` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Last notification or update.',
`count` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Total notifications sent or updates made.',
PRIMARY KEY (`nagid`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'The support_nags table stores individual support
nag...; Array
(
)
in db_create_table() (line 2684 of /home/digidog/www/drupal7/includes/database/database.inc).
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB/TEXT column &#039;message&#039; can&#039;t have a default value: CREATE TABLE {support_nags} (
`nagid` INT unsigned NOT NULL auto_increment,
`action` INT unsigned NOT NULL DEFAULT 0 COMMENT &#039;Nag action to perform.&#039;,
`clients` VARCHAR(255) NOT NULL DEFAULT &#039;&#039; COMMENT &#039;List of all clients affected by this nag.&#039;,
`states` VARCHAR(255) NOT NULL DEFAULT &#039;&#039; COMMENT &#039;List of all states affected by this nag.&#039;,
`priorities` VARCHAR(255) NOT NULL DEFAULT &#039;&#039; COMMENT &#039;List of all priorities affected by this nag.&#039;,
`assigned` VARCHAR(255) NOT NULL DEFAULT &#039;&#039; COMMENT &#039;List of all assigned users affected by this nag.&#039;,
`mailto` VARCHAR(255) NOT NULL DEFAULT &#039;&#039; COMMENT &#039;Notification recipients.&#039;,
`subject` VARCHAR(128) NOT NULL DEFAULT &#039;&#039; COMMENT &#039;Notification subject.&#039;,
`message` TEXT NOT NULL DEFAULT &#039;&#039; COMMENT &#039;Notification or update message text.&#039;,
`frequency` INT unsigned NOT NULL DEFAULT 0 COMMENT &#039;Frequency to send notification or update ticket.&#039;,
`last` INT unsigned NOT NULL DEFAULT 0 COMMENT &#039;Last notification or update.&#039;,
`count` INT unsigned NOT NULL DEFAULT 0 COMMENT &#039;Total notifications sent or updates made.&#039;,
PRIMARY KEY (`nagid`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT &#039;The support_nags table stores individual support nag...&#039;; Array
(
)
in db_create_table() (line 2684 of /home/digidog/www/drupal7/includes/database/database.inc).
Drush command terminated abnormally due to an unrecoverable error.
?>

not sure if this error occurs only in my enviroment or my installation method via Drush 4.5 on Drupal 7 latest --dev (installing it among with support, support_bot and bot)

Login or register to post comments

Comments

#1

Posted by samgreco on January 4, 2012 at 3:17am

I'm getting the same thing installing manually. On Drupal 7.10.

nobody click here