Problem after upgrade to 1.2.3
Permalink Browser Info Environment
I've attempted to upgrade Whale Galleria from 1.2.2 to 1.2.3. I received an SQL error which unfortunately I didn't catch.
I'm still informed that the version is still 1.2.2, but now get an SQL when I try to create an instance of a Whale Galleria:
Not sure whether to attempt the Whale Galleria update again.
Can you advise what I should do to get things working again? Shamefully, I don't have a backup.
Best regards
Ray
I'm still informed that the version is still 1.2.2, but now get an SQL when I try to create an instance of a Whale Galleria:
An unexpected error occurred: An exception occurred while executing 'INSERT INTO whaleGalleria( name, fsID, plugin, theme, positions, options, dateAdded, dateModified, fmUID, lmUID ) VALUES ( ?, ?, ?, ?, ? , ?, ?, ?, ? , ? )' with params ["PunkFest20160819", 18, "galleria", "classic", "517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537", "{\"showTitle\":0,\"showDescription\":0,\"addLink\":0,\"thumbWidth\":60,\"thumbHeight\":40,\"galleryWidth\":0,\"galleryHeight\":350,\"galleryBgColor\":\"\",\"autoplay\":0,\"imageMargin\":0,\"imagePosition\":\"center\",\"initialTransition\":\"fade\",\"layerFollow\":1,\"maxScaleRatio\":0,\"pauseOnInteraction\":1,\"popupLinks\":0,\"preload\":\"2\",\"queue\":1,\"responsive\":1,\"show\":0,\"showCounter\":1,\"showInfo\":1,\"showImagenav\":1,\"swipe\":1,\"thumbDisplayOrder\":1,\"thumbMargin\":0,\"transition\":\"fade\",\"transitionSpeed\":400,\"wait\":5000}", "2016-10-04 21:21:29", "2016-10-04 21:21:29", "1", "1"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dateAdded' in 'field list'
Not sure whether to attempt the Whale Galleria update again.
Can you advise what I should do to get things working again? Shamefully, I don't have a backup.
Best regards
Ray
| Type: | Pre-Sale |
|---|---|
| Status: | In Progress |
Thank you for your speedy reply.
I have just attempted the upgrade and received this error:
Any further help would be appreciated.
Thanks
Ray
I have just attempted the upgrade and received this error:
An exception occurred while executing 'ALTER TABLE whaleGalleria ADD dateAdded DATETIME DEFAULT '1000-00-00 00:00:00' NOT NULL, ADD dateModified DATETIME DEFAULT '1000-00-00 00:00:00' NOT NULL, ADD fmUID INT UNSIGNED DEFAULT 0, ADD lmUID INT UNSIGNED DEFAULT 0': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'dateAdded'
Any further help would be appreciated.
Thanks
Ray
Did u re intstall the package?
Hi,
I just downloaded and applied the update through C5 as normal. The SQL error message appeared as part of the upgrade. This time the version number has changed to 1.2.4. At this point I haven't attempted to create a 'Galleria'.
Thank you for your attention.
Ray
I just downloaded and applied the update through C5 as normal. The SQL error message appeared as part of the upgrade. This time the version number has changed to 1.2.4. At this point I haven't attempted to create a 'Galleria'.
Thank you for your attention.
Ray
Are you suggesting that I should remove Whale galleria completely and reinstall?
Hi,
Not necessarily remove it, but uninstall the add-on, then install it again.
Not necessarily remove it, but uninstall the add-on, then install it again.
Plz upgrade to 1.2.4