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!

#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
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

Custom Fields

Event Gallery Version 3.11.2 (build 3d8cb8c)
Joomla Version 3.9.14
URL  
PHP Version 7.3.11
Attachment
chrome_2019-12-27_21-35-11.png
 
Saturday, 28 December 2019 08:09 UTC
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
 
Saturday, 28 December 2019 13:22 UTC
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
 
Saturday, 28 December 2019 13:43 UTC
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.

 
Sunday, 29 December 2019 01:43 UTC
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
 
Sunday, 29 December 2019 09:08 UTC
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
 
Sunday, 29 December 2019 18:47 UTC
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
 
Monday, 30 December 2019 18:38 UTC
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.
 
Wednesday, 01 January 2020 22:51 UTC
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

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