Support Forums

Support Online : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

Property modul is giving me an error

Featured Lock Resolved Issue
I am using the Empire template installed with Quickstart and by clicking on property, hence opening the sp-property page I am getting the following error: :(

Column 'language' in where clause is ambiguous SQL=SELECT a.*,`b`.`title` AS `category_name` FROM `#__spproperty_properties` AS `a` LEFT JOIN `#__spproperty_categories` AS `b` ON (`a`.`spproperty_category_id` = `b`.`spproperty_category_id`) WHERE `a`.`enabled` = '1' AND (`language` LIKE '%de-DE%') ORDER BY `a`.`ordering` DESC LIMIT 0, 6

Actually I have several languages installed and I am using PHP 7.1.0, what's the problem here? Please solve it, because the pages with properties and Featured properties on the main page are just working fine.

6 Answers

Please login to view replies.

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 178


Total Accepted Answers: 161


Total Accepted Answers: 67


Total Accepted Answers: 3
Rifat Wahid Alif

Rifat Wahid Alif

Total Accepted Answers: 2




Community Users


Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us