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.

Latest post by mmccrae on Saturday, 23 September 2017 19:20 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.

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.

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]

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?

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]

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.



>

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?

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]

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]

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

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]

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?

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

mmccrae
Second try attachment with corrected filename.

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.

mmccrae
Thank you for immediate replies which answered my problem!