Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Cannot find event in past events, shows in backend and when searching

7 years 6 months ago
  • Tobias's Avatar
    Topic Author
  • Tobias
  • Offline
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 1
Licenses:
JomSocial Expired

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.

This message contains confidential information



STEPS TO REPLICATE:
1
2
3
4
5
RESULT
EXPECTED RESULT
BROWSER

7 years 6 months ago
Licenses:

Hi,

please provide me super user login detail:


I need for debugging purpose.

FYI:
to put any credentials information, please put it at site info section by editing your first post at this topic.

Regards

Attachments:
7 years 6 months ago
  • Tobias's Avatar
    Topic Author
  • Tobias
  • Offline
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 1
Licenses:
JomSocial Expired

I have re-activated administrative access

7 years 6 months ago
Licenses:

Hi,

I cant reproduce the issue.
here the search result:




please elaborate more if I missing something.

Regards

Attachments:
7 years 6 months ago
  • Tobias's Avatar
    Topic Author
  • Tobias
  • Offline
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 1
Licenses:
JomSocial Expired

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.

7 years 6 months ago
Licenses:

Hi,

here the temp fix for that:
edit /components/com_community/models/events.php line 423

$orderBy = ' ORDER BY a.' . $db->quoteName('startdate') . ' ASC';
change that code to
$orderBy = ' ORDER BY a.' . $db->quoteName('startdate') . ' DESC';

Regards

7 years 3 months ago
Licenses:
JomSocial Active

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;
        }

See attached.


It appears that dates are grouped by categories first which makes for an illogical display.
Can you please offer a fix as my client requires simple chronological sorting.

Thank,
Anton

Attachments:
7 years 3 months ago
Licenses:

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?


- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
7 years 3 months ago
Licenses:
JomSocial Active

Hi Michal,

I'm using 4.2.5 Pro.

Anton

7 years 3 months ago
Licenses:

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).


- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW