Support Forums

Support Offline : 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.

7 Answers

Rifat Wahid Alif - Staff

More than a month ago #Permalink
could you please pm me your admin and FTP access for my closer look and fix ?


- Thanks

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Please make sure that you have items in property.

- Thanks

vict0r

More than a month ago #Permalink
Hi,

thanks for your fast answer. As I stated, I installed the Quickstart package and therefore already have some items in propertys and I even added some more. On the main page I see the properties and I am able to open them normally.

The only thing that is not working is the sp-property page as I click on sp-properties, /http://index.php/sp-properties

I added some photos of the problem, the last one is showing the error, 404 page not found with the error I already posted.

Attachments (3)

  • Bildschirmfoto 2016-12-28 um 22.20.49.png
    Bildschirmfoto 2016-12-28 um 22.20.49.png 41.4 KB
  • Bildschirmfoto 2016-12-28 um 22.21.25.png
    Bildschirmfoto 2016-12-28 um 22.21.25.png 63.7 KB
  • Bildschirmfoto 2016-12-28 um 22.21.40.png
    Bildschirmfoto 2016-12-28 um 22.21.40.png 83 KB

vict0r

More than a month ago #Permalink
I uploaded the properties.php file from another post and now it seems to work fine :)

Rifat Wahid Alif - Staff

More than a month ago #Permalink
great


There are no replies made for this post yet.
Be one of the first to reply to this post!

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 127
Sifat

Sifat

Total Accepted Answers: 89
Toufiq

Toufiq

Total Accepted Answers: 45
Pavel

Pavel

Total Accepted Answers: 6
Sohan

Sohan

Total Accepted Answers: 5

114

Templates

292735

Community Users

Newsletter

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. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us