Jump to content
Sign in to follow this  

ocStore Notice: Error: Query execution was interrupted

Recommended Posts

Notice: Error: Query execution was interrupted
Error No: 1317
SELECT p.date_available AS date_available, p.quantity AS quantity, p.status AS status, p.location AS location, p.image AS image, p.price AS price, m.name AS manufacturer_id, pd.name AS name, (SELECT COUNT(pa.product_id) FROM oc_product_attribute pa WHERE p.product_id = pa.product_id AND pa.language_id = '1') AS attributes, (SELECT COUNT(po.product_id) FROM oc_product_option po WHERE p.product_id = po.product_id) AS options, (SELECT COUNT(p2c.product_id) FROM oc_product_to_category p2c WHERE p.product_id = p2c.product_id) AS categories, (SELECT COUNT(psp.product_id) FROM oc_product_special psp WHERE p.product_id = psp.product_id) AS specials, (SELECT COUNT(pdi.product_id) FROM oc_product_discount pdi WHERE p.product_id = pdi.product_id) AS discounts, (SELECT COUNT(pre.product_id) FROM oc_product_related pre WHERE p.product_id = pre.product_id) AS related, (SELECT COUNT(p2s.product_id) FROM oc_product_to_store p2s WHERE p.product_id = p2s.product_id) AS stores, (SELECT COUNT(p2d.product_id) FROM oc_product_to_download p2d WHERE p.product_id = p2d.product_id) AS downloads, (SELECT COUNT(pi.product_id) FROM oc_product_image pi WHERE p.product_id = pi.product_id) AS images, p.product_id AS product_id FROM oc_product p LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '1') WHERE p.product_id GROUP BY p.product_id ORDER BY pd.name ASC LIMIT 0,100 in /home/vipcase/aksmob/www/system/database/mysql.php on line 50


Вот такая ошибка не могу проставить связи. 

Как устранить ее? Кто что посоветует.



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.