unexpected error on installing package
Permalink Browser Info Environment
I receive en unaxpected error message when I install the package:
An unexpected error occurred.
An exception occurred while executing 'CREATE TABLE whaleResponsiveTables (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tableName VARCHAR(255) DEFAULT NULL, tablePlugin VARCHAR(50) DEFAULT NULL, tableTheme VARCHAR(50) DEFAULT NULL, options LONGTEXT DEFAULT NULL, items LONGTEXT DEFAULT NULL, dateAdded DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL, dateModified DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL, fmUID INT UNSIGNED DEFAULT 0, lmUID INT UNSIGNED DEFAULT 0, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'dateAdded'
What can I do?
An unexpected error occurred.
An exception occurred while executing 'CREATE TABLE whaleResponsiveTables (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tableName VARCHAR(255) DEFAULT NULL, tablePlugin VARCHAR(50) DEFAULT NULL, tableTheme VARCHAR(50) DEFAULT NULL, options LONGTEXT DEFAULT NULL, items LONGTEXT DEFAULT NULL, dateAdded DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL, dateModified DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL, fmUID INT UNSIGNED DEFAULT 0, lmUID INT UNSIGNED DEFAULT 0, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'dateAdded'
What can I do?
| Type: | Ticket |
|---|---|
| Status: | Archived |
Hi again,
Unfortunately the add on does not fit my purpose because I would like to embed images in the cells. Can I please request a refund? Thanks!
Unfortunately the add on does not fit my purpose because I would like to embed images in the cells. Can I please request a refund? Thanks!
Formal Refund Request: Please grant me a refund for the license assigned to this support request.
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.
To re-open this issue, reply to this message.
To re-open this issue, reply to this message.
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.
To re-open this issue, reply to this message.
To re-open this issue, reply to this message.
Plz overwrite attached file at:
\packages\whale_responsive_tables\db.xml
and then reinstall the package