Ordering the tagslist

[lise]

Hi,

In the tagslist i can only sort my tags based on the tag# and not on the alfabetical order.
check http://j.gebondeninleer.nl/tags.html for the only available sorting option i have, the other options give me a 500 error.

this might be attached to something in the menu structure not being completely sound... (see screenshot)

[ a slight warning: the content (if clicked deeper) of the website, could be considered as 18+. but in essence we are just a few nutcases collecting and showcasing adult books ]

[lise]

i forgot to mention some details
the webhost is running on linux
joomla is 3.5 (was 3.4.x, but that had the same issue)

kind regards,
lise

[federica]

Hi lisa,
which abook version are you using?

[lise]

Abook 3.1.1

[lise]

maybe i should explain better what i want...
if you look at the attached screenshot, you will see that the order is not alfabetical.
and i would like to have it sorted a to z

[lise]

It took me some time and trial and error to get what i wanted.
As you could see in the previous post, the tagslist was not sorted by alphabet..
i solved this by adding a line into the SQL that is executed.

File: com_abook/site/models/tags.php

find: line 110/111

Code Select Expand

$query->group('t.id');
                $this->_db->setQuery($query);
Change:
Add between 110 and 111:$query->ORDER('name');

Code Select Expand

$query->group('t.id');
$query->ORDER('name');
                $this->_db->setQuery($query);

[federica]

Many thanks