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/ (VehicleSearch::_getYears) */
v.year, v.year value, count(v.v_id) vehicle_count

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/ line 262.
DBconnect::all_array_hashref('DBconnect=HASH(0x75a9ed8)', '\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', 'sainte-eulalie') called at /www/UCC/strathcom_api/production/trunk/cgi-bin/API/ line 1729
VehicleSearch::_getYears('VehicleSearch=HASH(0x75ae8d0)', 'thumb_size', '150x100', 'class', 'used', 'group_id', 1, 'city', 'Sainte-Eulalie', ...) called at /www/UCC/portals/ line 40

Please contact