I changed the code in file catalog/controller/category.php in method index as follows on my server:
Code: Select all
.....
$results = $database->getRows("select * from category c left join category_description cd on (c.category_id = cd.category_id) left join image i on (c.image_id = i.image_id) where c.parent_id = '" . (int)(!$request->get('path') ? '0' : (int)end(explode('_', $request->get('path')))) . "' and cd.language_id = '" . (int)$language->getId() . "' ORDER BY c.sort_order, c.category_id");
.....
