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.
Friday, 27 December 2019 20:51 UTC

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:

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

Custom Fields

Event Gallery Version 3.11.2 (build 3d8cb8c)
Joomla Version 3.9.14
PHP Version 7.3.11
Saturday, 28 December 2019 08:09 UTC

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:
Saturday, 28 December 2019 13:22 UTC
Hello Sven,

Thank you so much for responding back.

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

Saturday, 28 December 2019 13:43 UTC
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.

Sunday, 29 December 2019 01:43 UTC
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 ?

Sunday, 29 December 2019 09:08 UTC
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:
Sunday, 29 December 2019 18:47 UTC
Hello Sven,

again, thank you so much for responding.

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

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

Please advise
Monday, 30 December 2019 18:38 UTC
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.
Wednesday, 01 January 2020 22:51 UTC
First of all, Happy new year :)

Again, thank you so much for your quick reply.

Last SQL instruction worked 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

Thursday, 02 January 2020 08:12 UTC

For all reading that: the better way to fix this, is to go through all the SQL updates to avoid issues in other places.
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.