Еще подобные ошибки возникают когда открываю товар для редактирования
Warning: mysqli::query() [mysqli.query]: (21000/1242): Subquery returns more than 1 row in Z:\home\stroika\www\system\library\db\mysqli.php on line 18Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT GROUP_CONCAT(cd1.name ORDER BY level SEPARATOR ' > ') FROM category_path cp LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id AND cp.category_id != cp.path_id) WHERE cp.category_id = c.category_id AND cd1.language_id = '3' GROUP BY cp.category_id) AS path, (SELECT DISTINCT keyword FROM url_alias WHERE query = 'category_id=41') AS keyword FROM category c LEFT JOIN category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '41' AND cd2.language_id = '3' in Z:\home\stroika\www\system\library\db\mysqli.php on line 40Notice: Trying to get property of non-object in Z:\home\stroika\www\admin\model\catalog\category.php on line 213Warning: mysqli::query() [mysqli.query]: (21000/1242): Subquery returns more than 1 row in Z:\home\stroika\www\system\library\db\mysqli.php on line 18Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT GROUP_CONCAT(cd1.name ORDER BY level SEPARATOR ' > ') FROM category_path cp LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id AND cp.category_id != cp.path_id) WHERE cp.category_id = c.category_id AND cd1.language_id = '3' GROUP BY cp.category_id) AS path, (SELECT DISTINCT keyword FROM url_alias WHERE query = 'category_id=42') AS keyword FROM category c LEFT JOIN category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '42' AND cd2.language_id = '3' in Z:\home\stroika\www\system\library\db\mysqli.php on line 40Notice: Trying to get property of non-object in Z:\home\stroika\www\admin\model\catalog\category.php on line 213Warning: mysqli::query() [mysqli.query]: (21000/1242): Subquery returns more than 1 row in Z:\home\stroika\www\system\library\db\mysqli.php on line 18Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT GROUP_CONCAT(cd1.name ORDER BY level SEPARATOR ' > ') FROM category_path cp LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id AND cp.category_id != cp.path_id) WHERE cp.category_id = c.category_id AND cd1.language_id = '3' GROUP BY cp.category_id) AS path, (SELECT DISTINCT keyword FROM url_alias WHERE query = 'category_id=50') AS keyword FROM category c LEFT JOIN category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '50' AND cd2.language_id = '3' in Z:\home\stroika\www\system\library\db\mysqli.php on line 40Notice: Trying to get property of non-object in Z:\home\stroika\www\admin\model\catalog\category.php on line 213