Error! Please report the follwing to the administrator. Thanks.
PDO Error Information
array(3) {
[0]=>
string(5) "42703"
[1]=>
int(7)
[2]=>
string(187) "ERROR: column "calculator_name" does not exist
LINE 13: ...ve=TRUE AND v_www_market_home.sold=FALSE ORDER BY calculator...
^"
}
Backtrace
[0]/usr/local/www/jhh/markethomes.php:248:
handleDBerrorSELECT v_www_market_home.availability_id, availability.name AS availability_name, v_www_floorplan.name AS floorplan_name,v_www_market_home.*,v_www_community.name AS community_name, (SELECT COUNT(v_www_market_home_feature.home_feature_id) FROM v_www_market_home_feature WHERE v_www_market_home_feature.market_home_id=v_www_market_home.id AND home_feature_id=:energy_star) AS energystar_cert, school_districts.name AS school_district_name,
v_www_community.city,
v_www_community.state,
sq_feet,
v_www_sleeping_areas.top AS sleeping_areas_name
FROM v_www_market_home
INNER JOIN v_www_community ON v_www_community.id=v_www_market_home.community_id
INNER JOIN availability ON availability.id=v_www_market_home.availability_id
INNER JOIN v_www_floorplan ON v_www_floorplan.id=v_www_market_home.floorplan_id
INNER JOIN v_www_sleeping_areas ON v_www_floorplan.sleeping_areas_id=v_www_sleeping_areas.id
INNER JOIN community_school_district ON community_school_district.community_id=v_www_market_home.community_id
INNER JOIN school_districts ON community_school_district.school_district_id=school_districts.id
AND v_www_community.active=TRUE AND v_www_market_home.sold=FALSE ORDER BY calculator_name
array(2) {
[0]=>
object(PDOStatement)#2 (1) {
["queryString"]=>
string(1200) "SELECT v_www_market_home.availability_id, availability.name AS availability_name, v_www_floorplan.name AS floorplan_name,v_www_market_home.*,v_www_community.name AS community_name, (SELECT COUNT(v_www_market_home_feature.home_feature_id) FROM v_www_market_home_feature WHERE v_www_market_home_feature.market_home_id=v_www_market_home.id AND home_feature_id=:energy_star) AS energystar_cert, school_districts.name AS school_district_name,
v_www_community.city,
v_www_community.state,
sq_feet,
v_www_sleeping_areas.top AS sleeping_areas_name
FROM v_www_market_home
INNER JOIN v_www_community ON v_www_community.id=v_www_market_home.community_id
INNER JOIN availability ON availability.id=v_www_market_home.availability_id
INNER JOIN v_www_floorplan ON v_www_floorplan.id=v_www_market_home.floorplan_id
INNER JOIN v_www_sleeping_areas ON v_www_floorplan.sleeping_areas_id=v_www_sleeping_areas.id
INNER JOIN community_school_district ON community_school_district.community_id=v_www_market_home.community_id
INNER JOIN school_districts ON community_school_district.school_district_id=school_districts.id
AND v_www_community.active=TRUE AND v_www_market_home.sold=FALSE ORDER BY calculator_name"
}
[1]=>
&string(1200) "SELECT v_www_market_home.availability_id, availability.name AS availability_name, v_www_floorplan.name AS floorplan_name,v_www_market_home.*,v_www_community.name AS community_name, (SELECT COUNT(v_www_market_home_feature.home_feature_id) FROM v_www_market_home_feature WHERE v_www_market_home_feature.market_home_id=v_www_market_home.id AND home_feature_id=:energy_star) AS energystar_cert, school_districts.name AS school_district_name,
v_www_community.city,
v_www_community.state,
sq_feet,
v_www_sleeping_areas.top AS sleeping_areas_name
FROM v_www_market_home
INNER JOIN v_www_community ON v_www_community.id=v_www_market_home.community_id
INNER JOIN availability ON availability.id=v_www_market_home.availability_id
INNER JOIN v_www_floorplan ON v_www_floorplan.id=v_www_market_home.floorplan_id
INNER JOIN v_www_sleeping_areas ON v_www_floorplan.sleeping_areas_id=v_www_sleeping_areas.id
INNER JOIN community_school_district ON community_school_district.community_id=v_www_market_home.community_id
INNER JOIN school_districts ON community_school_district.school_district_id=school_districts.id
AND v_www_community.active=TRUE AND v_www_market_home.sold=FALSE ORDER BY calculator_name"
}