ISSUE SUMMARY:
I cannot find an event in past events, but it shows in backend and when searching. I cant see any differences in data.
I think I know what's wrong. I was under the impression that past events are sorted by date with the latest first. That doesn't seem to be case? How do you expect past events to be sorted?
In general I believe the search, sorting and filtering options of JomSocial could be much improved.
Hi,
here the temp fix for that:
edit /components/com_community/models/events.php line 423
$orderBy = ' ORDER BY a.' . $db->quoteName('startdate') . ' ASC';
$orderBy = ' ORDER BY a.' . $db->quoteName('startdate') . ' DESC';
I've added the code suggested but Past Events still do not sort chronologically.
switch ($sorting) {
case 'latest':
if (empty($orderBy))
$orderBy = ' ORDER BY a.' . $db->quoteName('created') . ' DESC';
break;
case 'alphabetical':
if (empty($orderBy))
$orderBy = ' ORDER BY a.' . $db->quoteName('title') . ' ASC';
break;
case 'startdate':
if (empty($orderBy))
$orderBy = ' ORDER BY a.startdate ASC';
break;
default:
/*$orderBy = ' ORDER BY a.' . $db->quoteName('startdate') . ' ASC';*/
$orderBy = ' ORDER BY a.' . $db->quoteName('startdate') . ' DESC';
break;
}
HI, Anton.
I tested this using latest version of JomSocial 4.2.6 and events are sorted chronologically by default.
Do you use latest version?
HI, Anton.
Please, upgrade to latest version and check if this sort your issue.
If not, send me PM with:
1. Your site backend URL
2. Super User credentials
3. Link to current forum thread (so I'll know to what your PM apply to).