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!

#2858 – "Internal Server Error" attempting to upgrade Event Gallery

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.
Thursday, 21 September 2017 16:56 UTC
mmccrae
 Event Gallery 3.7.2 is installed and working. While attempting to upgrade to 3.7.6, I generated this error:
"100 Current database version is not set (). I can't update! I tried to update to database version 3.7.3_2017-08-04. Please contact the developer for help.If you want to try a fix yourself, please have a look at this page: https://www.svenbluege.de/joomla-event-gallery/event-gallery-manual/faq-sql-error-during-install. "
I don't think the FAQ page applies because I've never downgraded Event Gallery.

Custom Fields

Event Gallery Version 3.7.6
Joomla Version 3.8.0
 
Thursday, 21 September 2017 20:43 UTC
sbluege
Hi,

do you remember which was the first version of Event Gallery you installed? How exactly did you install it? Was there any error message?

Downgrading is not the issue. Your database misses important version information for some reasons.
 
Friday, 22 September 2017 18:30 UTC
mmccrae

Hello Sven Bluege,

I installed Event Gallery toward the end of July17, it must have been ver 3.7.2 that I installed. I installed it via "Upload Package File" in the back end. There was no error message that I can remember.

Mark McCrae
mmccrae@grandmontcommunity.org

On 9/21/2017 4:43 PM, Sven Bluege wrote:
Reply to your public ticket #2858 "Internal Server Error" attempting to upgrade Event Gallery [Event Gallery - General]

 
Friday, 22 September 2017 18:35 UTC
sbluege
Please have a look at this page: https://www.svenbluege.de/joomla-event-gallery/event-gallery-manual/faq-sql-error-during-install

Can you try to execute the insert statement?
 
Friday, 22 September 2017 21:00 UTC
mmccrae

I submitted the query to update the schema version, then tried to install the Event Gallery update and got the same error message again. Then in the query I substituted latest db version  = 3.6.4_2017-02-13 from components/com_eventgallery/sql/updates/mysql and got the same error message trying to install the Event Gallery update.

Mark McCrae
mmccrae@grandmontcommunity.org


On 9/22/2017 2:35 PM, Sven Bluege wrote:
Reply to your public ticket #2858 "Internal Server Error" attempting to upgrade Event Gallery [Event Gallery - General]

 
Saturday, 23 September 2017 05:30 UTC
sbluege

Did you replaced #__ with your database prefix? Which query did you execute?

Please note that you can't post a sql query in a ticket. Add a space character in the INSERT/UPDATE/SELECT word.



>

 
Saturday, 23 September 2017 16:50 UTC
sbluege
Does the update query updates anything? set version_id='3.6.4_2017-02-13' would be the right thing.
What does your #_schemas table contain?
 
Saturday, 23 September 2017 17:00 UTC
mmccrae

I executed this query:

 update fsj4o_schemas
set version_id='$$databaseversion$$'
where extension_id in (
   select extension_id
  from fsj4o_extensions
  where element = 'com_eventgallery'
);
When I substituted latest version ID I wasn't sure about syntax so I submitted the query three ways:
set version_id='$$$$'
set version_id=''

set version_id=
The query did not return a result for any of my tries.

Mark McCrae
mmccrae@grandmontcommunity.org

On 9/23/2017 1:30 AM, Sven Bluege wrote:
Reply to your public ticket #2858 "Internal Server Error" attempting to upgrade Event Gallery [Event Gallery - General]

 
Saturday, 23 September 2017 17:15 UTC
mmccrae

The update query has yet to evoke a response. Screenshot of my schemas table is attached - Event Gallery does not appear to be represented.



Mark McCrae
mmccrae@grandmontcommunity.org

On 9/23/2017 12:50 PM, Sven Bluege wrote:
Reply to your public ticket #2858 "Internal Server Error" attempting to upgrade Event Gallery [Event Gallery - General]

 
Saturday, 23 September 2017 17:18 UTC
sbluege
so please try the insert statement instead. You'll find it at the end of this page: https://www.svenbluege.de/joomla-event-gallery/event-gallery-manual/faq-sql-error-during-install
 
Saturday, 23 September 2017 18:42 UTC
mmccrae

I tried this insertion statement...

 insert into fsj4o_schemas (extension_id, version_id)
 select extension_id, '1.0.0'
from fsj4o_extensions
where element = 'com_eventgallery'
...and got no response to the query, and browsing the schemas table, Event Galley still is not represented.

Mark McCrae
mmccrae@grandmontcommunity.org
 
On 9/23/2017 1:18 PM, Sven Bluege wrote:
Reply to your public ticket #2858 "Internal Server Error" attempting to upgrade Event Gallery [Event Gallery - General]

 
Saturday, 23 September 2017 18:46 UTC
sbluege
No response to an insert query? You should either see a new record or you get an SQL exception because the entry already exists.
Can you double check please?

btw, what does

s elect extension_id 
    from fsj4o_extensions 
    where element = 'com_eventgallery'


return?
 
Saturday, 23 September 2017 19:06 UTC
mmccrae
The query that you suggested in your last post returned extension no. 10019.

I re-ran the insertion inquiry and got the same non-result. So I tried a manual insertion, using values for extension ID=10019 and for version ID=1.0.0. I got a warning message, I think my syntax was not perfect, but the insertion did succeed. Then I attempted to reinstall Event Gallery update and this time was successful, except with numerous warnings. See the attached screenshot.

Am I OK with duplicate columns?

Mark McCrae
mmccrae@grandmontcommunity.org
 
Saturday, 23 September 2017 19:08 UTC
mmccrae
Second try attachment with corrected filename.
Attachment
firefox.jpg
 
Saturday, 23 September 2017 19:16 UTC
sbluege
That was it! The warnings are okay since the initial version was set to 1.0.0 and the updater tried to apply all steps to the latest version.
The next update will not cause any trouble.

In addition, I already added an option to Event Gallery to fix the missing version data with a single button click starting with version 3.7.8.
 
Saturday, 23 September 2017 19:20 UTC
mmccrae
Thank you for immediate replies which answered my problem!
 
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.