HTTP/1.1 500 Internal Server Error Content-type:text/html Error Encountered
Error Encountered
DBD::mysql::db selectall_arrayref failed: Unknown column 'ct.city_name' in 'where clause' [for Statement "e;/* /www/UCC/portals/usedcarscanada.com/production/http/cgi-bin/home (VehicleSearch::_getYears) */
select
v.year, v.year value, count(v.v_id) vehicle_count

from
tblDealer d

inner join tblDealerGroup dg
on d.d_id = dg.d_id
inner join tblGroup g
on dg.group_id = g.group_id and dg.group_id = ?

inner join
tblVehicle v
on v.d_id=d.d_id
and v.status=?
where v.class = ? and lower(ct.city_name) = ? group by v.year order by v.year desc"e;] at /www/lib/perl/DBconnect.pm line 262.
DBconnect::all_array_hashref('DBconnect=HASH(0x4c6bc98)', '\x{a}\x{9}\x{9}\x{9}\x{9}\x{9}\x{9}select\x{a}\x{9}\x{9}\x{9}\x{9}\x{9}\x{9}\x{9}v.year, v.year value, count(v.v_id) vehi...', 1, 'in stock', 'USED', 'winnipeg') called at /www/UCC/strathcom_api/production/trunk/cgi-bin/API/VehicleSearch.pm line 1729
VehicleSearch::_getYears('VehicleSearch=HASH(0x4c71128)', 'group_id', 1, 'class', 'used', 'thumb_size', '150x100', 'page', 1, ...) called at /www/UCC/portals/usedcarscanada.com/production/http/cgi-bin/home line 40

Please contact support@strathcom.com