Hi Everyone
I hope someone can help me
I have the problem that after upgrading from 1.5.1 to latest version i cant edit some of my categories and products
The error i get is:
Warning: mysql_query() [function.mysql-query.php]: Unable to save result set in /home/xxx/www/shop.xxxxx.xx/system/database/mysql.php on line 21Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT keyword FROM url_alias WHERE query = 'product_id=341') AS keyword FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '341' AND pd.language_id = '1' in /home/xxxxx/www/shop.xxxx/system/database/mysql.php on line 49
Similar erros on other products and categories
Everything else works fine no erros on front or so
I just cant edit any more cats and products
I really would like to get some help or advice
I think this is the first ever major error i got since I use OC from earlest versions
I just saw i have this on several other parts of the website as well
SELECT DISTINCT *, (SELECT keyword FROM url_alias WHERE query = 'information_id=7') AS keyword FROM information WHERE information_id = '7
Im really stuck, i have no clue how to fix it
SELECT DISTINCT *, (SELECT keyword FROM url_alias WHERE query = 'information_id=7') AS keyword FROM information WHERE information_id = '7
Im really stuck, i have no clue how to fix it
To fix:
- open PhpMyAdmin
- Open table url_alias
- Click at search
- In Query, change the operator to (equal)
- In Value input the name of the product_id that is displaying in the error, in my case product_id=337
- It will find two or more rows. Remove the one with the bigger url_alias_id.
- DONE.
- open PhpMyAdmin
- Open table url_alias
- Click at search
- In Query, change the operator to
Code: Select all
=
- In Value input the name of the product_id that is displaying in the error, in my case product_id=337
- It will find two or more rows. Remove the one with the bigger url_alias_id.
- DONE.
Is it solution?
I need my categories to be called in lot of ways!
Sometimes category should be site.com/best-boods-in-universe/, sometimes it should be opened by site.com/super, sometimes it should be very short url for advertisment as "Input site.com/s to get exclusive discount!"
If there a way other then asign lot of keywords to the same querry?
Temporary fixed problem by adding HAVING count(*) = 1 to this line at /model/catalog/category.php
AS path, (SELECT DISTINCT keyword FROM " . DB_PREFIX . "url_alias WHERE query = 'category_id=" . (int)$category_id . "' HAVING count(*) = 1)
Who is online
Users browsing this forum: No registered users and 6 guests