Problems with Sort by Price

[JohnBoyCR]

Linda,

By the way, I did reload all my product data. No help.
I could, I suppose restore a backup. The problem is that I
am not sure when the problem started and I have not kept backups
that are older than about 2 months. My BAD ?

I had a thought about something that I could try. Assuming that
perhaps some PHP code might be corrupt, if I knew which code
might be culpable I could try reloading the code from my localhost
up to the live site. The reason for that is that the sort functions
appear to work correctly on the localhost. Just a thought!

Again, thanks for all your help. When we get this fixed I will talk to the store owner and see if we can't send something to the TEAM !
You folks are great !

John

[Ajeh]

If you look at those two functions in the Known Bug Fixes you have the wrong ones ...

You need to fix those functions to what is posted for the bug fix ... and it leads me to think you have other bugs not fixed as well ...

[JohnBoyCR]

Linda,

Thank you. I will go through the list of bug fixes and hopefully fix
all of the bugs.

I am still somewhat confused as to why the sort works on my
localhost server but not on the live server, unless the bug fixes
had been incorporated into the 1.3.8a download I fetched last
week.

Again, thanks for your help.

John

[JohnBoyCR]

Linda,

I went through the list of bugs and security patches (about 5
pages of fixes and bugs) as per the links you sent me, and updated the files.

The problem still exists so I guess there is most likely a DB
error. I will use the mysqlcheck function to look for
corrupt tables in the DB and will let you know the outcome.

Again, thanks for all your help.

John

[JohnBoyCR]

Linda,

I checked the MySql tables using the CHECK TABLE tablename
function and there do not seem to be any tables that are corrupt.
I believe that the CHECK TABLE function looks at the keys for
each table to ensure that links to other tables are not broken, as
well as other checks.

This is really puzzling. As the sort by price works in the admin I have to assume (maybe a BAD IDEA) that the DB is okay.
That leaves me with trying to find out what PHP code might be
causing the problem.

As I stated earlier, I made all of the code changes as outlined
in the link you sent

http://www.zen-cart.com/forum/showthread.php?t=82619

so unless I goofed when making the code updates then there is
still something not quite right. I am going to keep after this until
I find the solution.

Thanks again for you help. I will let you know when I find the
problem.

John

[Ajeh]

I don't see a way to sort your Products by Price ...

You appear to be using some kind of Add On that has taken away that feature ...

If I go to the New Products, and sort the Products in reverse order, they appear correct but I did not go through the whole list ...

What specifically is not sorting by Price right now? How are you altering the Sort Order where this is not working?

[JohnBoyCR]

Linda,

As they were not working, I removed the options for sort by price.
I did not want to present the customers with something that did not
work.

I will make those sort options available for you so look at them.

They should be available at around 2PM ET on 24OCT.

John