Support archive

Shortcuts SQL Error from admin and using save tag.

Marijan 29 Oct 2019 09:40 problem, complete

Using Low Search 6.20 and have problem with creating shortcuts.
It is the same error if I use it from admin and try to create shortcut myself, the same if I create it from search log and the same if I use save tag.

Replies

1. Low 29 Oct 2019 10:31

   Try running this query:
   
   

   ALTER TABLE exp_low_search_shortcuts MODIFY sort_order INT(4) UNSIGNED NOT NULL DEFAULT 1;

   
   
   ...does that solve the issue for you?

2. Marijan 29 Oct 2019 11:46

   Can't say how much you saved my day.
   Project I am working on is going live tomorrow or day after tomorrow so this fast answer really helped.
   
   Since it is documentation site for our services, search and filtering is what I need most.
   
   Works like charm, thanks 1000000 times for so fast answer and help.
   
   This is how table looks now.