Problems with Sort by Price

[JohnBoyCR]

Linda,

Thanks for the offer. For right now I want to keep working on the
issue to see if I can figure it out. I might actually learn something.

Since my last post I have gone through all of the admin configuration
and catalog settings and compared them to the settings on my local server. They all appear to be the same. As I posted earlier, the
sort by price works on my local server.

So, it would appear that there is either a difference in the software,
which I think is unlikely but possible, or the database is corrupt.

I did notice that the version of MySql running on my local server is
5.0.24A and on the hosting service it is 5.0.91-community.
I doubt that is an issue, and I don't think the hosting service
has made any changes, but thought I would present that to you
anyway.

If I get really frustrated with this I will take you up on your
offer. For the moment we will continue to run the site without
the price sorting feature enabled.

I may see if I can find a MySql expert that can look at the DB
to determine what problems there might be.

Thanks for your help.

[JohnBoyCR]

Linda,

YAAAAAYYYYY ! I found the problem and it WAS in the Admin.

I compared all the settings in my localhost setup versus the
live site setup and finally found the setting that was incorrect.
It was in the Product Listing table, the Display Product Model field.

I don't know how, when, or why I might have changed that setting
but when I made it the same as in my localhost settings (which
I presume were the default settings as I just recently installed
the site there), the sort by price started working.

Thanks for ALL your help. I really appreciate the time and effort
you spent.

Regards,
JohnBoyCr

[Ajeh]

Thanks for the update that you found the missing setting and got everything working correctly ...