Problems with Sort by Price

[JohnBoyCR]

I have a problem. I believe that the Sort by price feature
used to work but it no longer does. We are running version
1.3.8a with security upgrades. MySql version 5.0.91
PHP version 5.2.11 .

In the Zen Cart Admin I have done the following:

Reset Master Categories ID
Reset Price Sorter


In phpMyAdmin :

I have verified that the master_categories_ id and
products_price_sorter values are set in the products table
of the DB.


What might I have done to cause the sort by price
feature to not work?

Thanks for any help. If you need more info please
feel free to contact me.

[Ajeh]

Are you getting errors? Perhaps you have an URL that we could peek at to see what is happening ...

[Ajeh]

NOTE: there are numerous Known Bug Fixes for v1.3.8 ...
http://www.zen-cart.com/forum/showthread.php?t=82619

Plus a good time to review all of the Security Patches and Updates ...
http://www.zen-cart.com/forum/showthread.php?t=131115

NOTE: all of these and more are in the current v1.3.9 release on our home page ...

[JohnBoyCR]

linda,

No, I am not getting errors. Right now the server response time
seems to be really bad, but here is a product page you can look at:

http://www.postlynx.com/index.php?ma...dex&cPath=1093

Thanks for any help you can give.

[JohnBoyCR]

By the way, I THINK I have all of the security patches and
updates, for 1.3.8.a, installed.

John

[Ajeh]

Check that you have all of the Known Bug Fixes that mention master_categories_id or categories ...

Also be sure that the update by price is completing when you run it in the Store Manager ...

[JohnBoyCR]

Linda,

I have checked that I have bug and security updates in place, to
the best of my knowledge.

I have updated the product price sorter several times.

The thing I find most unsettling is that the sort by price seems to work in one or two categories, but not in most of them. Since I can
not imagine that the code performing the sort function works
differently for different categories, I can only assume that there
is something in the database that is causing the problem.

I have looked at the database, using phpMyAdmin, and the
product table shows that the products_price_sorter and
master_categories_id fields have values. However, one thing
I see that is peculiar is that some products have the
manufacturers_id = NULL and others have the
manufacturers_id = 0 (zero) . Might this be having an adverse
effect on the sort function?

If you want it, I can send a copy of the product table.

Any suggestions ?

[JohnBoyCR]

YIKES ! I just found something that disturbs me. One product
in the table has a master_categories_id of 0 (zero). This
was one of the earliest products that I created manually (prior
to using EasyPopulate).

I am not a mySql guru but I am sure that there is a way to
delete that product id.

Can somebody help me with the mySql code? Will I have
to delete items from multiple tables?

I don't know if this DB error has anything to do with the
sort problem or not.

[Ajeh]

If you have Products in the products table with the master_categories_id of 0 and then run the Reset Master Categories ID and still have Products in the products table with the master_categories_id of 0 then you have bad data ...

NOTE: if using Linked Products, running the Reset Master Categories ID can be a problem as the lowest value categories_id will be used for the master_categories_id ...

You can use the Multiple Categories Link Manager and set an entire Category of Products to use that Category as the categories_id for the master_categories_id or set them individually by Product ...

[JohnBoyCR]

Well, I have tried everything I could think of and still have no
luck.

I have NO linked products.

I found one product that had an error and deleted it.
I reloaded the entire product table, 11000+ products,
using EasyPopulate.

I reset the master categories ID and then updated the
price sorter. Same results. Some categories sort properly
but most do not.

I give up !

Thanks for the suggestions given.