Jump to content
Sign in to follow this  
egor11223

Ошибка при закрытии заказа в админке

Recommended Posts

Всем доброго времени суток! При попытке закрыть заказ в админке появляется белая страничка, и ничего не происходит. При этом в логах пишется ошибка:

- PHP Warning:  mysql_query(): Unable to save result set in /home/.../.../www/system/database/mysql.php on line 22
- PHP Notice:  Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=1181') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '1181' AND pd.language_id = '1' in /home/.../.../www/system/database/mysql.php on line 50

Прошу помочь в данной проблеме.

Edited by egor11223

Share this post


Link to post
Share on other sites

Посмотрите, какой урл у товара product_id=1181

вероятно есть ещё одна страница с таким же чпу

поищите в oc_url_alias дубли

Share this post


Link to post
Share on other sites

1. backup

2. backup

 

3

CREATE TEMPORARY TABLE `t_temp`  as
(SELECT min(`url_alias_id`) as id
   FROM url_alias
   GROUP BY `query`
);
SELECT * FROM url_alias u 
WHERE u.`url_alias_id` not in (
   SELECT id FROM t_temp
);

Будут выведены все повторные 

Share this post


Link to post
Share on other sites

Да, оказалось очень много дублей страниц на сайте, проверил при помощи Seo Keyword Cheker. Не подскажите как удалить все дубли? При помощи Seo Keyword Cheker пытался удалить, но он удаляет только по одной странице, что очень долго при большом количестве страниц.

Share this post


Link to post
Share on other sites

Я дал практически готовый скрипт для удаления

 

И даже написал, что делать

1. бекап

2. бекап

3

CREATE TEMPORARY TABLE `t_temp`  as
(SELECT min(`url_alias_id`) as id
   FROM url_alias
   GROUP BY `query`
);
DELETE FROM url_alias  
WHERE `url_alias_id` not in (
   SELECT id FROM t_temp
);

Share this post


Link to post
Share on other sites

 

Я дал практически готовый скрипт для удаления

 

И даже написал, что делать

1. бекап

2. бекап

3

CREATE TEMPORARY TABLE `t_temp`  as
(SELECT min(`url_alias_id`) as id
   FROM url_alias
   GROUP BY `query`
);
DELETE FROM url_alias  
WHERE `url_alias_id` not in (
   SELECT id FROM t_temp
);

Благодарю! Все получилось)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.