ISSUE SUMMARY: I enable "Order by last comment" in JomJomSocial Professional 4.2.5 and then frontpage has problems displaying. I disable it and everything works fine.
You may check the test site (test.sosailize.net) as i have "Order by last comment" on.


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

Hi, Nick.

Thank you for contacting us.
You're right the result is an error:

Unknown column 'a.updated_at' in 'order clause' SQL=SELECT a.* FROM `#__community_activities` as a WHERE ( 1 AND ( a.actor NOT IN (279,314,315,647,728,835,837,838,839,848,853,933,934,990,1000) ) AND ( (a.`group_access`='0') OR (a.`groupid` IN ('' ) ) OR (a.`groupid`='0')) AND (a.`event_access`='0') AND (a.`access` <= 10) AND ( a.`groupid` IN ( 9,2,6,14,10,7,12,13,15,16,17,19,21,20 ) OR ( a.`groupid` IS NULL ) OR ( a.`groupid` = 0 ) ) ) AND a.`archived` = 0 GROUP BY a.`id` ORDER BY a.`updated_at` DESC, a.`id` DESC LIMIT 10

I assign developer to investigate this issue further.
He'll contact you ASAP.

Thank you.
I will disable the "Order by last comment" on test site also, so i can work with it.

Hi Nick,

You need add new field "updated_at" type date inside table #__community_activities, you can do it from phpmyadmin

thank you!

I did what you sent and solved the other issue i had "Add Comment>Enter>Undefined error" and the issue of the front message "error:
Unknown column 'a.updated_at' in 'order clause' SQL=... GROUP BY a.`id` ORDER BY a.`updated_at` DESC, a.`id` DESC LIMIT 10"

but the frontpage still has problems displaying correctly.

So i disable it in both live and test site.

Hi Nick,

I set the "Order by last comment" to Yes, and check frontend, but I cant see the error like you said, seems this is already fixed, right ?

It's my mistake i didn't explain the problem. Now in my test site the "order by last comment" is on.
The 1st problem when i visit the frontpage is that when scrolling down there is "more" button although i have enabled "Infinite scrolling for activity streams".
2nd problem is when i click "more" then nothing happens, it doesn't display more.

Hi Nick,

This issue caused by your Joomla and 3rd party Jomsocial template, please you check this with our default template or contact JF developer.

thank you!

Which is your default template please?

hi Nick,

Please try to use Beez3 or Protostar template..

thank you!

I used both Beez3 & Protostar templates on my test site (test.sosailize.net) but in addition to "by last comment" issue, the infinite scrolling or "more" button is not functioning either.

What should i do please?

Hi Nick,

I cant access your test site test.sosailize.net, it always be redirected to sosailize.net/sosailize.com/public_html/ and show :

The web service to this account has been limited temporarily!

Site had malware problem and was down unfortunately. Please check now

Hi Nick,

This issue caused by your Jomsocial template from JoomForest, I already changed to our default jomsocial template, and its working fine.

thank you!