New Zenner
- Join Date:
- May 2006
- Location:
- UK
- Posts:
- 31
- Plugin Contributions:
- 0
Search error '1109 Unknown table 'p' in field list' after upgrade from v137 to v138
After upgrade, an error message appears in the search result page, says:
Advanced Search
1109 Unknown table 'p' in field list
in:
[select count(p.products_id) as total]
The search and advanced search work fine before I upgraded the site.
When I replaced the changed file /includes/modules/pages/advanced_search_result/header_php.php with the old one, then it works again.
I haven't found anybody else posted this problem, I wonder if it's just me have this problem. Any ideas?
To be simple and genuine - we are naturally the same.
Review My Zen Cart Shop - **Clothing & Accessories Wholesale** , **Silk Store** , Studio Flash Lights