ISSUE SUMMARY:

After upgrading to 4.2.3, the following error appears whenever I try to view a photo album
Undeclared variable: admin SQL=SELECT * FROM `rrovg_community_featured` WHERE `type`='users' ORDER BY `id` DESC LIMIT 0,admin

is there a way to check all of the tables in mySQL to ensure they have the correct columns?

STEPS TO REPLICATE:
1 Log in to site
2 Select Photos from menu
3
4
5
RESULT Error: Undeclared variable: admin SQL=SELECT * FROM `rrovg_community_featured` WHERE `type`='users' ORDER BY `id` DESC LIMIT 0,admin
EXPECTED RESULT Photo albums displays
BROWSER Safari

Hi,

the issue not with database, but with your jomsocial configuration > layouts > Featured Item and Listing > Maximum Users
you put "admin" as value, instead of number.