hi
i have a problem
1- i cliked my photo
2- clicked tab my photo
3- sort photo = featured --->link (photos?sort=featured)

page reload and show error cod 1064 :


1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) DESC, a.id LIMIT 0,12' at line 1 SQL=SELECT a.*, COUNT( DISTINCT(b.id) ) AS count, MAX(b.created) AS lastupdated, c.thumbnail as thumbnail, c.storage AS storage, c.id as photoid FROM `SrTbUXTkPlFnD_community_photos_albums` AS a LEFT JOIN `SrTbUXTkPlFnD_community_photos` AS b ON a.id=b.albumid LEFT JOIN `SrTbUXTkPlFnD_community_photos` AS c ON a.photoid=c.id WHERE a.type != '' AND a.creator='72' AND a.permissions <='40' AND a.type NOT LIKE '%group%' AND a.type NOT LIKE '%event%' GROUP BY a.id ORDER BY (a.`id` IN ()) DESC, a.id LIMIT 0,12

Hi,

I confirmed this is a bug. here the temporary fix:
edit /components/com_community/models/photos.php at 835, change the code from

$order = " ORDER BY (a.`id` IN (".$featuredAlbums.")) DESC, a.id ";

if ($featuredAlbums) $order = " ORDER BY (a.`id` IN (".$featuredAlbums.")) DESC, a.id ";
else $order = " ORDER BY a.id  DESC";

for everyone is bug?
update jomsocial for bug?

Hi,

yes it is. if confirmed bug, all jomsocial users will facing this issue.
the bug fixes will be at 4.1.2

Regards

Thank you very much jomsocial team.
my problem is fixed.
good luck.