Another error when installing
Permalink Browser Info Environment
Hey,
after installing your addon:
An exception occurred while executing 'CREATE TABLE whaleGridGallery (id INT UNSIGNED AUTO_INCREMENT NOT NULL, galleryName VARCHAR(255) DEFAULT NULL, galleryType VARCHAR(10) DEFAULT NULL, fsID INT UNSIGNED DEFAULT NULL, stackID INT UNSIGNED DEFAULT NULL, gPlugin VARCHAR(50) DEFAULT NULL, gTheme VARCHAR(50) DEFAULT NULL, hPlugin VARCHAR(50) DEFAULT NULL, hTheme VARCHAR(50) DEFAULT NULL, lPlugin VARCHAR(50) DEFAULT NULL, lTheme VARCHAR(50) DEFAULT NULL, positions LONGTEXT DEFAULT NULL, options LONGTEXT DEFAULT NULL, dateAdded TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, dateModified TIMESTAMP DEFAULT CURRENT_TIMESTAMP 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[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
after installing your addon:
An exception occurred while executing 'CREATE TABLE whaleGridGallery (id INT UNSIGNED AUTO_INCREMENT NOT NULL, galleryName VARCHAR(255) DEFAULT NULL, galleryType VARCHAR(10) DEFAULT NULL, fsID INT UNSIGNED DEFAULT NULL, stackID INT UNSIGNED DEFAULT NULL, gPlugin VARCHAR(50) DEFAULT NULL, gTheme VARCHAR(50) DEFAULT NULL, hPlugin VARCHAR(50) DEFAULT NULL, hTheme VARCHAR(50) DEFAULT NULL, lPlugin VARCHAR(50) DEFAULT NULL, lTheme VARCHAR(50) DEFAULT NULL, positions LONGTEXT DEFAULT NULL, options LONGTEXT DEFAULT NULL, dateAdded TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, dateModified TIMESTAMP DEFAULT CURRENT_TIMESTAMP 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[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
| Type: | Pre-Sale |
|---|---|
| Status: | In Progress |
Thanks for the quick reply.
Wooohoo it's working. Thanks a lot.
Greetings from Germany.
Wooohoo it's working. Thanks a lot.
Greetings from Germany.
Ive just installed and also got this error - the add-on is listed, but is not visible as an option when adding a block??
I did try replaying the file attached here, but still no go?
I did try replaying the file attached here, but still no go?
Plz open replace attached file with current /packages/whale_grid_gallery/db.xml and see if it fixes the error?
Cheers,