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!

#3750 Save failed with the following error: Unknown column 'sortattribute' in 'field list'

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 sbluege on Thursday, 02 January 2020 08:12 UTC

dado023
 Hello,

dear Sven.

First, happy holidays to you and to your loved ones.
Second, thank you kindly for creating such a beautiful joomla gallery extension.


I have a problem with saving and event, ...when i push Save button, it throws this error message:

Error
Save failed with the following error: Unknown column 'sortattribute' in 'field list'


I am using latest joomla and even gallery versions.

I hope you can help

Thank you in advance
Daniel

sbluege
Hi,

there are some database changes missing which I introduced with Event Gallery 3.5.0 several years ago. How did you update to the latest version?

This page shows some of the missing statements: https://udrugacinaz.hr/administrator/index.php?option=com_eventgallery&view=systemcheck

dado023
Hello Sven,

Thank you so much for responding back.

I just downloaded pkg event gallery zip file, and then installed it through joomla.

Daniel

sbluege
Did you encounter any error message? I recommend executing the SQL scripts which appear on the page I send you. You need to replace #_ with your table prefix.

dado023
I did not encounter any other error message.

Where can i find those SQL scripts you are talking about?

Also, do i execute scripts in phpMyAdmin ?

Daniel

sbluege
You can execute them with phpMyAdmin, just don't forget to use the right table prefix. Don't execute them with #__.

The statements you can find here: https://udrugacinaz.hr/administrator/index.php?option=com_eventgallery&view=systemcheck

dado023
Hello Sven,

again, thank you so much for responding.

Once i execute all those scripts in phpMyAdmin, i get different error, like this:


Error
Save failed with the following error: Unknown column 'shuffle_images' in 'field list'


Please advise
Dan

sbluege
Okay. I guess we're close. Please try to execute this SQL then:

A LTER TABLE `#__eventgallery_folder` ADD `shuffle_images` tinyint(4) NOT NULL DEFAULT '0' after `sortdirection`;
U PDATE `#__eventgallery_folder` set `shuffle_images`=1 where `attribs` like '%"shuffle_images":"1"%';


Please remove the space in "A LTER" and "U PDATE" and add your table prefix.

dado023
First of all, Happy new year :)

Again, thank you so much for your quick reply.

Last SQL instruction worked out......now it saves the gallery without displaying errors, thank you so much.


If possible, please remove all my private info from this ticket and make it public, because it might help other people with the same problem....i hope

Kind regards
Dan

sbluege
Done.

For all reading that: the better way to fix this, is to go through all the SQL updates to avoid issues in other places.

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