Store Front not displaying any products

Bug #457534 reported by Rob Broomfield
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Exponent Content Management System
Fix Released
Medium
Jonathan Worent

Bug Description

Products do not display when you use a custom table prefix (anything other than exponent - the default) The problem seems to be line 71 and line 80 of the storeController.php file.

They both read..
$sql .= 'SELECT id FROM exponent_storeCategories WHERE rgt BETWEEN '.$category->lft.' AND '.$category->rgt.')';

However they should be...
$sql .= 'SELECT id FROM '.DB_TABLE_PREFIX.'_storeCategories WHERE rgt BETWEEN '.$category->lft.' AND '.$category->rgt.')';

Note the '.DB_TABLE_PREFIX.' not present in the install code at present.

Changed in exponent-cms:
status: New → Fix Released
importance: Undecided → Medium
assignee: nobody → Jonathan Worent (jonathan-oicgroup)
milestone: none → 2.0-preview
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.