Hi
When editing a category I get this error below.
It's only on 2 categories, other cats I can edit without a problem..
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/basdebin/public_html/system/database/mysql.php on line 21Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT keyword FROM opc_url_alias WHERE query = 'category_id=27') AS keyword FROM opc_category WHERE category_id = '27'
Any help would be highly appreciated.
Thanks!
Quokka
What version of OC, is it modified or "clean"?
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
I got same error trying to open Featured module configuration after i added some items then i found this thread. I very very new if about Opencart so i am unsure do i am right but if to change subquery to:
It looks like work, as i work with multilingual OC e-shop (6 languages), so i just checked table then it has language_id and subquery search for any record without specific language and use it later with specific language... so from db design side it's bad, but i really unsure i very new at OC.
Code: Select all
SELECT keyword
FROM opc_url_alias
WHERE query = 'category_id=27' and `language_id` = [current language id]
CHEAP, HIGH QUALITY & FAST - From these three things possible to choose just TWO.
I use opencart 1.5.5.1
when I edit product page error
"Warning: mysql_query(): Unable to save result set in /home/tabpcmar/domains/tabpcmarket.ir/public_html/system/database/mysql.php on line 22Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT GROUP_CONCAT(cd1.name ORDER BY level SEPARATOR ' > ') FROM oc_category_path cp LEFT JOIN oc_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 = '2' GROUP BY cp.category_id) AS path, (SELECT keyword FROM oc_url_alias WHERE query = 'category_id=63') AS keyword FROM oc_category c LEFT JOIN oc_category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '63' AND cd2.language_id = '2' in /home/tabpcmar/domains/tabpcmarket.ir/public_html/system/database/mysql.php on line 50 "
PLZ hepl me
thanks alot of
when I edit product page error
"Warning: mysql_query(): Unable to save result set in /home/tabpcmar/domains/tabpcmarket.ir/public_html/system/database/mysql.php on line 22Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT GROUP_CONCAT(cd1.name ORDER BY level SEPARATOR ' > ') FROM oc_category_path cp LEFT JOIN oc_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 = '2' GROUP BY cp.category_id) AS path, (SELECT keyword FROM oc_url_alias WHERE query = 'category_id=63') AS keyword FROM oc_category c LEFT JOIN oc_category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '63' AND cd2.language_id = '2' in /home/tabpcmar/domains/tabpcmarket.ir/public_html/system/database/mysql.php on line 50 "
PLZ hepl me
thanks alot of
Who is online
Users browsing this forum: No registered users and 128 guests