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!

#1973 again upgrade gallery on new version not work

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 matjazr on Sunday, 21 February 2016 13:08 UTC

Sunday, 21 February 2016 12:18 UTC

matjazr

hi,

same problem like in ticket #1572 – upgrade gallery on new version not work

was try again this:

D ELETE FROM `#__eventgallery_foldertype`;

I NSERT INTO `#__eventgallery_foldertype` (`id`, `name`, `folderhandlerclassname`, `displayname`, `default`, `ordering`, `published`, `modified`, `created`) VALUES
(0, 'local', 'EventgalleryLibraryFolderLocal', 'Local Images', 1, 1, 1, '0000-00-00 00:00:00', NULL),
(1, 'picasa', 'EventgalleryLibraryFolderPicasa', 'Picasa Images', 0, 2, 1, '0000-00-00 00:00:00', NULL);

U PDATE `#__eventgallery_folder` set foldertypeid=1 where folder like '%@%';

u pdate #__schemas
set version_id='3.3.0'
where extension_id in (
select extension_id
from #__extensions
where element = 'com_eventgallery'
);

but got #1146 - Table 'name of DB.#__eventgallery_folder' doesn't exist

Sunday, 21 February 2016 12:28 UTC

sbluege

How often did you tried the update? Did you encounter an initial error? you database contains content which it should not have.

The SQL statements you executed make no sense. You did not event replace the #_ with your table prefix. Please have a look at this page: https://www.svenbluege.de/joomla-event-gallery/event-gallery-manual/faq-sql-error-during-install

It might help to solve this. Please do NOT set the schema version to 3.5.0. Set it to 3.4.1_2015-08-11 instead and install the SQL updates from those files manually. Don't forget to use your own table prefix.

administrator\components\com_eventgallery\sql\updates\mysql\3.4.0.sql
administrator\components\com_eventgallery\sql\updates\mysql\3.4.0_2015-04-14.sql
administrator\components\com_eventgallery\sql\updates\mysql\3.4.1_2015-08-04.sql
administrator\components\com_eventgallery\sql\updates\mysql\3.4.1_2015-08-11.sql