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!

#1744 error updating

Posted in ‘Event Gallery Extended’

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 avp on Tuesday, 06 October 2015 15:24 UTC

Friday, 02 October 2015 20:53 UTC

avp

Hi Sven
I am getting this error while updating to either 3.4.1 or 2.

Duplicate column name 'attachments' SQL=ALTER TABLE `jos_eventgallery_emailtemplate` ADD `attachments` text AFTER `body`;

Package Update: There was an error installing an extension: com_eventgallery_3_4_1.zip

Saturday, 03 October 2015 05:33 UTC

sbluege

Please have a look at this page: https://www.svenbluege.de/joomla-event-gallery/event-gallery-manual/faq-sql-error-during-install

Maybe you try to change the version to 3.4.1_2015-08-04 before you use 3.4.1_2015-08-11 since I don't know why you have an older version there. Maybe you installed an older version over a newer one?

Saturday, 03 October 2015 09:25 UTC

avp

Morning Sven

I am using running 3.3.1 at present. Is it best to do a incremental upgrade or go directly to the most resent up to date version.

Andy

Saturday, 03 October 2015 09:32 UTC

sbluege

If you use 3.3.1 why do you already have 3.4.1 database structures?

Usually you can simply update from one version to a newer one. Joomla! will take care of the necessary updates.

For now just go ahead with the procedure described in the FAQ article and make sure you never install an older version over a newer one.

Saturday, 03 October 2015 09:44 UTC

avp

Hi I have only done one update since installing EG that was to 3.3.1. I don't do updates unless there is a really good reason to do.

I will check out the database version in your resent notes.

In fact I will try 3.5 that is a total change. It only takes me 15 mins to restore the website from back-ups.

Luckily this is on my test development server. So no damage done to live site.

just done 3.3.1 to 3.4.0 this is the error msg
Warning

Duplicate column name 'companyname' SQL=ALTER TABLE `jos_eventgallery_staticaddress` ADD `companyname` varchar(255) DEFAULT NULL AFTER `lastname`;

Package Update: There was an error installing an extension: com_eventgallery_3_4_0.zip
Tried this twice as in your notes on upgrading if fail on first attempt.

Andy

Saturday, 03 October 2015 10:23 UTC

avp

Hi Sven

Now done 3.3.1 to 3.5.0

Warning

Duplicate column name 'companyname' SQL=ALTER TABLE `jos_eventgallery_staticaddress` ADD `companyname` varchar(255) DEFAULT NULL AFTER `lastname`;

Package Update: There was an error installing an extension: com_eventgallery_3_5_0.zip

repeated to see if it would clear on second attempt.

any ideas.

Andy

Saturday, 03 October 2015 10:46 UTC

sbluege

Kind of strange. Given you're on 3.3.1. How can you have database changes from newer versions in your database?

Here is how to fix this:

There are four databasa schema versions since 3.3:

- 3.4.0.sql
- 3.4.0_2015-04-14
- 3.4.1_2015-08-04
- 3.4.1_2015-08-11

Now you need to update your database with the given SQL statement and one of the mentioned versions in the placeholder [VERSION]. Try to install the update after each step and don't skip one.

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

Monday, 05 October 2015 12:40 UTC

avp

Hi Sven

This SQL is very new to me. As far as I know I am doing this correctly. Please see the attached a screen shot of
the attempt of updating the SQL for Event Gallery.

Andy

Monday, 05 October 2015 12:47 UTC

sbluege

not bad, but you need to replace the #__ with your database prefix.

Tuesday, 06 October 2015 09:57 UTC

avp

Tuesday, 06 October 2015 10:11 UTC

avp

Hello Sven

Have sent you a email. For some reason I can not paste text to here and save.

Just hangs with spinning icon.

Andy

Tuesday, 06 October 2015 10:47 UTC

sbluege

You're not allowed to post SQL statements :)
But you're on the right track. Now try the next values and install the update after each statement again. Here are the next three values:

- 3.4.0_2015-04-14
- 3.4.1_2015-08-04
- 3.4.1_2015-08-11

Tuesday, 06 October 2015 10:57 UTC

avp

Thanks for the reply.

As I understand. Even joomla reports a upgrade error and the web site has crashed ( blank pages )
I keep going through the process.

Andy

Tuesday, 06 October 2015 11:38 UTC

avp

Hi Sven

- 3.4.0_2015-04-14
- 3.4.1_2015-08-04
- 3.4.1_2015-08-11

where are the download for the above updates.

Andy

Tuesday, 06 October 2015 12:05 UTC

sbluege

There are no additional downloads. Please install Event Gallery Extended 3.4.3 each time. Each new version might contain several SQL update steps. Since I don't know which is the latest step your database has seen we need to try them step by step. Only this way we can make sure you finally have the right database structure. The update will end without any error if we're finished.