Problems with Sort by Price

[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

[JohnBoyCR]

Linda,

The sort by price, low to high and high to low, are now available.

Yes, the sort seems to work correctly for new product. Also,
the sort by price also works for the Emergency Stamps category.

I really do appreciate your looking at this.

I downloaded code from the live site to my localhost and the
sort works on the localhost. Sure looks like a DB problem but then
one would think that the New Products sort by price would not work
correctly if it were a DB problem. I guess I am still an EGG !

John

[JohnBoyCR]

Linda,

I am seeing a pattern in the categories that sort properly and
those that do not. I believe that the problem may be related to
a recent upload I performed using EasyPopulate.

I believe that in the last upload there was some kind of problem
and there was a message for each of the products that the data
was not stored because the v_product_model was missing.
The tab delimited file looked fine but there was apparently
something not correct. I re-created the tab delimited text file
and reloaded the data and everything seemed to work.
HOWEVER, when I looked at the Categories and Products, in
admin, there were about 80 new Categories. Those categories all
had names that were the same as the v_products_image.

I deleted all of those new categories, as they had no products in them, but now I am beginning to wonder if that is were the problem
originated.

The categories that seem to sort correctly have NOT had any
new products uploaded recently. Those that do not sort
properly had product uploaded in that last upload.

I think we are getting somewhere.

So, here is the next question. The backups I have on the
server are FULL backups. I know that I can have the
support folks do a complete restore of a backup. However,
I would like to just do a restore of the database. Do you
suppose that they can extract just the DB files from the full
backup and restore just the DB?

John