Jump to content

Recommended Posts

Доброго дня, подскажите пожалуйста форумчане, мучаюсь третий день уже.

При создании нового товара и переходе по нему появляется вот такая ошибка: 

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY co.sort_order, cod.name' at line 1
Error No: 1064
SELECT p2v.product_id, co.option_id, cod.name, cod.postfix FROM oc_category_option co LEFT JOIN oc_category_option_description cod ON (cod.option_id = co.option_id) LEFT JOIN oc_product_to_value p2v ON (co.option_id = p2v.option_id) WHERE cod.language_id = '1' AND p2v.product_id IN (1027/) ORDER BY co.sort_order, cod.name in /home/y/yuskov/mebelimpex.ru/public_html/system/database/mysql.php on line 50

Через некоторое время Seo pro отрабатывает и переименовывает ссылку с ?product_id=1027/ на banketka-gloriya например. Если руками убрать / на конце ссылки то ошибки нет, пробовал удалить слеш / через htaccess. Удалить удалось, но только не с ссылок новых товаров видом ?product_id=1027/

Share this post

Link to post
Share on other sites

А причем тут SEO Pro? у вас тут при добавлении товара в модели синтаксис sql запроса неправильный. А Seo_pro после обновления кеша делает ЧПУ ссылку, и это нормально.

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.

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.