Install Issue
Permalink Browser Info Environment
I have tried several times to download this and it provides an error every time. I tried manually uploading the file and trying to install and it provides an error doing that as well. Please let me know what I need to do to get this installed, thank you.
Type: | Pre-Sale |
---|---|
Status: | In Progress |
This is not a pre-sale, I have already purchased it obviously.
Hi,
It shouldn't be related to add-on, it may have something to do with Concrete5 website.
It shouldn't be related to add-on, it may have something to do with Concrete5 website.
This is the error I get when installing, have you seen this before.
An exception occurred while executing 'CREATE TABLE whaleOwlCarousel (id INT UNSIGNED AUTO_INCREMENT NOT NULL, carouselName VARCHAR(255) DEFAULT NULL, carouselPlugin VARCHAR(50) DEFAULT NULL, carouselTheme 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'
Hi,
Plz replace attached file at:
\packages\whale_owl_carousel\db.xml
Cheers,
Plz replace attached file at:
\packages\whale_owl_carousel\db.xml
Cheers,
I had the same issue, and replacing the file didn't help. There error is now:
An exception occurred while executing 'CREATE TABLE whaleOwlCarousel (id INT UNSIGNED AUTO_INCREMENT NOT NULL, carouselName VARCHAR(255) DEFAULT NULL, carouselPlugin VARCHAR(50) DEFAULT NULL, carouselTheme VARCHAR(50) DEFAULT NULL, options LONGTEXT DEFAULT NULL, items LONGTEXT DEFAULT NULL, dateAdded DATETIME DEFAULT '1000-00-00 00:00:00' NOT NULL, dateModified DATETIME DEFAULT '1000-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'
An exception occurred while executing 'CREATE TABLE whaleOwlCarousel (id INT UNSIGNED AUTO_INCREMENT NOT NULL, carouselName VARCHAR(255) DEFAULT NULL, carouselPlugin VARCHAR(50) DEFAULT NULL, carouselTheme VARCHAR(50) DEFAULT NULL, options LONGTEXT DEFAULT NULL, items LONGTEXT DEFAULT NULL, dateAdded DATETIME DEFAULT '1000-00-00 00:00:00' NOT NULL, dateModified DATETIME DEFAULT '1000-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'
You may want to use CURRENT_TIMESTAMP as the default DateTime value.