Search in Admin found no results ?????
Moderator: Staff
1 post
• Page 1 of 1
Search in Admin found no results ?????
I searched for a product in my shop and found it.
I searched for the same product in my Admin CP and got no result, no product found.
I immediately thought it was due to me upgrading to 1.3.9e but before I ranted I searched the Zen-Cart.com forum.....Bingo !!! someone else had the same problem, and found the cure.
It's due to a file being changed when installing Easy Populate with some templates.
___________________________________________________________________
http://www.zen-cart.com/forum/showthread.php?t=131282
A post by fortune 81......
-----------------------------------
After much work I've traced the problem to admin/include/modules/ category_product_listing.php
In this file resides the section of code that performs the select for the search. The file contains a comment (// fix duplicates and force search to use master_categories_id) and under this comment is code that has been commented out and below it is the replacement code.
When I swap them by un-commenting the first and commenting the second code, the search works perfect.
The part causing the problem is the part that selects p.master_categories_id from the products table and runs it against the products_to_categories table, specifically
"and p.master_categories_id = p2c.categories_id"
_________________________________________________________________
Worked OK for me on my heavily modified site.
I searched for the same product in my Admin CP and got no result, no product found.
I immediately thought it was due to me upgrading to 1.3.9e but before I ranted I searched the Zen-Cart.com forum.....Bingo !!! someone else had the same problem, and found the cure.
It's due to a file being changed when installing Easy Populate with some templates.
___________________________________________________________________
http://www.zen-cart.com/forum/showthread.php?t=131282
A post by fortune 81......
-----------------------------------
After much work I've traced the problem to admin/include/modules/ category_product_listing.php
In this file resides the section of code that performs the select for the search. The file contains a comment (// fix duplicates and force search to use master_categories_id) and under this comment is code that has been commented out and below it is the replacement code.
When I swap them by un-commenting the first and commenting the second code, the search works perfect.
The part causing the problem is the part that selects p.master_categories_id from the products table and runs it against the products_to_categories table, specifically
"and p.master_categories_id = p2c.categories_id"
_________________________________________________________________
Worked OK for me on my heavily modified site.
1 post
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 0 guests




