Support

Support is part of Event Gallery Extended.

Please get a subscription if you need support. Feel free to use the ticket system or the contact form for reporting defects or pre-sale questions. Make sure you're logged in in order to be able to create a new ticket.

For general information you can also jump to the manual.

Subscribe now!

#2408 Update Error

Posted in ‘Event Gallery - General’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by CalaMur on Tuesday, 01 November 2016 14:20 UTC

CalaMur
 If I try to update the Gallery I get the following error message:

Warnung

JFolder: :delete: Der Pfad ist kein Verzeichnis! Pfad: /var/www/sk10579/html/cms/components/com_eventgallery/media
JFolder: :delete: Der Pfad ist kein Verzeichnis! Pfad: /var/www/sk10579/html/cms/administrator/components/com_eventgallery/liveupdate
JFolder: :delete: Der Pfad ist kein Verzeichnis! Pfad: /var/www/sk10579/html/cms/administrator/components/com_eventgallery/media
JInstaller: :Install: SQL-Fehler Duplicate column name 'image_thumbthresholdsize' SQL=ALTER TABLE `#__eventgallery_watermark` ADD `image_thumbthresholdsize` int(4) NOT NULL DEFAULT '0' AFTER `image_opacity`;
Erweiterung „Aktualisierung“: SQL Fehler beim Ausführen der Abfrage: „DB-Funktion mit Fehlercode 1060 fehlgeschlagen!
Duplicate column name 'image_thumbthresholdsize' SQL=ALTER TABLE `#__eventgallery_watermark` ADD `image_thumbthresholdsize` int(4) NOT NULL DEFAULT '0' AFTER `image_opacity`;
SQL =
ALTER TABLE `#__eventgallery_watermark` ADD `image_thumbthresholdsize` int(4) NOT NULL DEFAULT '0' AFTER `image_opacity`;

Paket Aktualisierung: Bei der Installation der Erweiterung trat ein Fehler auf: com_eventgallery_3_4_7.zip

The Component is not working and will only show an error message; The gallery is not showing up on the webpage.

Thank you for your support!

Alexander

sbluege
Seems like the database version got lost or was never there.

Can you try to work through the instructions on this page?

https://www.svenbluege.de/joomla-event-gallery/event-gallery-manual/faq-sql-error-during-install

Let me know if you have any questions.

CalaMur
Thanks for the swift reply.

The Manifestcache before the update looks like:

{"name":"COM_EVENTGALLERY","type":"component","creationDate":"13\/07\/2016","author":"Sven Bl\u00fcge","copyright":"","authorEmail":"svenbluege@gmail.com","authorUrl":"www.svenbluege.de","version":"3.4.7","description":"COM_EVENTGALLERY_XML_DESCRIPTION","group":"","filename":"eventgallery"}

Joomla Admin sections says 3.2.1

I changed it to, as descibed in your example (see below) and as it didnt worked also to 3.2.1 :

{"name":"COM_EVENTGALLERY","type":"component","creationDate":"04\/07\/2016","author":"Sven Bl\u00fcge","copyright":"","authorEmail":"svenbluege@gmail.com","authorUrl":"www.svenbluege.de","version":"3.5.2","description":"COM_EVENTGALLERY_XML_DESCRIPTION","group":"","filename":"eventgallery"}

After I try to update the event gallery from the admin section it will always change the Manifest to:

{"name":"COM_EVENTGALLERY","type":"component","creationDate":"13\/07\/2016","author":"Sven Bl\u00fcge","copyright":"","authorEmail":"svenbluege@gmail.com","authorUrl":"www.svenbluege.de","version":"3.4.7","description":"COM_EVENTGALLERY_XML_DESCRIPTION","group":"","filename":"eventgallery"}

The error message after the update process failed says:
Duplicate column name 'image_thumbthresholdsize' SQL=ALTER TABLE `#__eventgallery_watermark` ADD `image_thumbthresholdsize` int(4) NOT NULL DEFAULT '0' AFTER `image_opacity`;
SQL =
ALTER TABLE `#__eventgallery_watermark` ADD `image_thumbthresholdsize` int(4) NOT NULL DEFAULT '0' AFTER `image_opacity`;

Did I something wrong here?

btw: the eventgallery_watermark table is empty, which is even the case on my local test environment where Event Gallery is working fine and I was able to update to the latest version.

Do you have an older version after 3.2.1 which I can try to update first and then try to update to the latest version?

Thanks for your help

Alexander



sbluege
I guess most of the database changes are already done. Just set the right version in the #_schema table for the extension. The right version is the name of the sql file with the highest version number in the sql/updates/ folder of the component zip file. For Event Gallery 3.4.7 the right value is '3.4.1_2015-08-11'.

If there are any SQL error after you finished the installation please grab each SQL file and execute it. You might get errors for a lot of files but in the end all update statements are executed and you're good to go.

CalaMur
Incredible! That's a radical support! With 3.4.1_2015-08-11 it worked!

Thank you very much! Really appreciated!

Alexander

sbluege
Did you reaplyed the update sql files? It might happen that some update steps are missing.

CalaMur
I changed the version / date with your sql script to 3.4.1_2015-08-11 and started the update from the Joomal backend. The update was installed successful, the Komponent is working well, as well as the module on the webpage. Thanks again for your support.

Alexander