I imported my buzilla database into JIRA and could not search on external id field after the import.
I was getting the following error in the logs:
Step 1 was to remove the Freetext search from the External ID custom field.
I then added the freetext search back to the custom field.
I then reindexed and like magic my error went away.