problem on site using search function - occured after an upgrade.

2 posts by 2 authors in: Forums > CMS Builder
Last Post: January 26, 2011   (RSS)

By Codee - January 26, 2011

Hello,
I have 2 equipment for sale sites running separate CMSB licenses and databases, but VERY similar in design. One was utilizing v1.22 and the other 2.06. We did an overhaul upgrade on the one with v1.22. Everything things to be working fine on the admin side as well as public side EXCEPT on the admin side the search function isn't providing a proper keyword search for the fields.

In the admin searching tab page we installed the following in the search field box:

Keyword|createdByUserNum,quantity_available,num,title,year,make,model,price,stock_number,description,color,rental,overall_condition,miles,hours,vin,serial,gvw,engine_type,fuel_type_gas,fuel_type_diesel,fuel_type_propane,speed,cylinders,air_conditioning,attachments,rearend,undercarriage_percentage,brakes_hydraulic,brakes_air_brakes,transmission_standard,transmission_automatic,transmission_speed,two_speed_rearend,tracks,tire_size,tire_condition_front,tire_condition_rear,bed,bed_type,bed_size,bed_condition_excellent,bed_condition_good,bed_condition_fair,boom,blade,bucket_size,lift_height,additional_comments,location_city,location_state,equipment_type,4_x_4,featured_ad,rental_rate_hourly,rental_rate_daily,rental_rate_weekly,rental_rate_monthly,keywords,rental|keyword
Equipment Type|equipment_type|match

The equipment type field search works under the Advanced tab but searching by Stock Number or any other field always provides a result of "total number out of total number" such as "78 out of 78" records even if only 1 or 2 vehicles in the database should result (2 out of 78).

Originally, with v1.22 this search field was modified by IT staff to have:
createdByUserNum,quantity_available,num,title,year,make,model,price,stock_number,description,color,rental,overall_condition,miles,hours,vin,serial,gvw,engine_type,fuel_type_gas,fuel_type_diesel,fuel_type_propane,speed,cylinders,air_conditioning,attachments,rearend,undercarriage_percentage,brakes_hydraulic,brakes_air_brakes,transmission_standard,transmission_automatic,transmission_speed,two_speed_rearend,tracks,tire_size,tire_condition_front,tire_condition_rear,bed,bed_type,bed_size,bed_condition_excellent,bed_condition_good,bed_condition_fair,boom,blade,bucket_size,lift_height,additional_comments,location_city,location_state,equipment_type,4_x_4,featured_ad,rental_rate_hourly,rental_rate_daily,rental_rate_weekly,rental_rate_monthly,keywords,rental

but after the upgrade leaving it alone didn't work either.

Please help.