Sort by Zipcode not showing as an opton

[h2ojunkie]

I just upgraded from 2.11 to 2.5.

And for some reason, the "sort by zipcode" is not showing in the drop down menu for sorting a catagory.

I have the "enable zip code integration" set to yes, and the distance column is showing on showcat.php and is working correctly there.

And I can do a search by distance just fine, but the sort by zipcode option isn't appearing the the drop down.

Does anyone have any idea what the cause could be?

UPDATE: I found the problem. It appears the upgrade didn't insert the zip code entry in to the sort table

[Chuck S]

There is no ORDER BY zipcode that I see in the upgrade

[h2ojunkie]

Well that might explain why it never got inserted into the table then