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!

#2035 Save 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 Thursday, 24 March 2016 13:53 UTC

matjazr
 after adding new event got this message:




everything work thill today...is it problem after upgrade joomla to 3.5.0?

sbluege
This is unrelated to the Joomla! version. Your database misses a column. When did you updated to Event Gallery 3.4?

matjazr
i did update 21. february 2016.

sbluege
From your ticket history I already helped you at least two times with updates. Seems like your system is still broken.

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

Execute the update SQL files one after each other to get the database structures which come with the update.

matjazr
so will be always problem with update....this mean new install of joomla, to remove this problem?

sbluege
I suggest to read through the page I send you.

What is the result of this query?

select * 
from #__schemas 
where extension_id in (
    select extension_id 
    from #__extensions 
    where element = 'com_eventgallery'
);

matjazr
this is output: select * from "name"_schemas where extension_id in ( select extension_id from "name"_extensions where element = 'com_eventgallery' )

and down show version id: 3.4.1_2015-08-11

sbluege
That's the correct version. All database changes should be there.

Please try to add the database changes manually. They are located in those files:

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

Be careful with the insert statement in the 3.4.0.sql file. Don't execute it if it's already there.

matjazr
i am not shure if i was understand corectly last topis...so i was checked on ftp...have already all this files:


we are talking about this files:
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

so what i should do with them....something like this:

1.
update #__schemas
set version_id='3.4.0.sql'
where extension_id in (
select extension_id
from #__extensions
where element = 'com_eventgallery'
);

2.
update #__schemas
set version_id='3.4.0_2015-04-14.sql'
where extension_id in (
select extension_id
from #__extensions
where element = 'com_eventgallery'
);

3.
update #__schemas
set version_id='3.4.1_2015-08-04.sql'
where extension_id in (
select extension_id
from #__extensions
where element = 'com_eventgallery'
);

4.
update #__schemas
set version_id='3.4.1_2015-08-11.sql'
where extension_id in (
select extension_id
from #__extensions
where element = 'com_eventgallery'
);

and off course fix even this: #__

i am right?

sbluege
leave the schemas table alone. Just open the four files in the given order and execute each contained sql statement manually. Again: be careful with the INSERT statement and make sure the entry is not already there.

matjazr
i was try with first db 3.4.0.



and got error:
ALTER TABLE `kitjf_eventgallery_staticaddress` ADD `taxid` varchar(255) DEFAULT NULL AFTER `companyname`


#1060 - Duplicate column name 'taxid'

i am really not so familiar with DB ;)

sbluege
Those error messages are perfectly fine since all the changes should be already part of your database. Now grab the next file. Just the last sql file should not result in an error since it adds the missing passwordhint column.

matjazr
seem is it work fine now...can add new gallery....so hope will be ok in future ;)

thanks for help....