XF 1.3 Prefix Searches Returning Incorrect Results

Joe Link

Well-known member
On my forum we have a classified section where members select their state as a prefix.

For some reason, in this specific section, when members search for the Idaho prefixes it returns results from Oregon. It also happens with a single Oregon ad in a couple other sections.

To reproduce:

1. Go here: http://www.northwestfirearms.com/forums/part-accessory-classifieds.21/
2. Click "Idaho" where it says "Quick Search: Oregon|Washington|Idaho".

You can also go to the standard advanced search, click the Search Threads & Posts, select the Part & Accessory Classifieds section, and click the first four ID: prefixes.

Joe Link

Well-known member
It seems all of the incorrect results are from April 11th or before, when I uninstalled the Multi-Prefix Add-On. Is it possible I need to rebuild a cache? If so, which one(s)?

Joe Link

Well-known member
Unfortunately, support was spotty, which is why I had to uninstall it. Do you think that plugin may have modified something to cause this? I was hoping to get away with just a cache rebuild :(

Daniel Hood

Well-known member
You can attempt to rebuild the search index for posts and threads. If the add on isn't installed it shouldn't be effecting your search results at all.

Is your prefix_id column in the xf_thread table an int(10)? If not try altering the table.

In addition, could you run this query in phpmyadmin and send me the result:
SELECT *  FROM `xf_search_index` WHERE `content_type` LIKE 'thread' AND `content_id` = 167966
Last edited: