Register

Search in Admin found no results ?????

A discussion area for other carts not listed above

Moderator: Staff

I Live Here
Posts: 7323
Joined: Mon Oct 15, 2007 8:24 pm
Location: Cheshire

Search in Admin found no results ?????

Postby eemarket » Tue Aug 03, 2010 7:42 am

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.

Return to Other Carts

Who is online

Users browsing this forum: No registered users and 1 guest