116 Posts
nycxav
7 years ago
2
Topic

Hi,

I am having issues on a website that I have upgraded from Joomla 3.3.6 and seblod 3.3.6 to Seblod 3.5.1 and Seblod 3.8.1.

All issues seem to be related to lists and searches.

First I had issues with the pagination when I had multiple tags assigned to the same content item.

Now my ordering parameters are not taken into account no matter what. My lists are always searched by created date.

I was wondering if anyone else is facing the same problems.

Thanks.
Xav.

Get a VIP membership
4229 Posts
Kadministrator
7 years ago
1
Level 1

I just tested and ordering works correctly for me if I put a field into ordering tab  (in the search&list) and view it the component directly (linked form menu). 

Do you use list module or ordering field, or perhaps do you use any fields that modify search (search query, search join etc) ?

116 Posts
nycxav
7 years ago
0
Level 2

Hi,

I do use the "search query" plugin to add "GROUP BY t0.pk" to fix the pagination issue that I had.

I tried to add an ORDER BY clause after the GROUP BY, unfortunately, the system adds its own "ORDER BY created" after mine and I get an SQL error because the generated statement has two "ORDER BY" clauses one after the other.

For the record I also use the "search join" plugin in my search. I don't know if it has an influence on the issue.

Thanks for your help.

Xav.

NB: I keep having errors when I try to submit posts on this forum. I end up having to resubmit because my posts are not attached to the original topic and the topic is the timestamp when it was submitted. e.g. this one and that one.

It seems to work when I reply to the last post, not when I reply to the topic FYI.

Get a VIP membership