Jump to content
pasha2203

помогите понять в чем ошибка по синтаксису

Recommended Posts

Код ошибки 

Спойлер

Fatal error: Uncaught exception 'Exception' with message '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 'condition, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.' at line 1<br />Error No: 1064<br />SELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points F in C:\OSPanel\domains\Название сайта\system\library\db\mysqli.php on line 40

 

в catalog\model\catalog\product.phpcatalog\model\catalog\product.php добавляются два запроса

первый 

 (SELECT s.name FROM " . DB_PREFIX . "sklad s WHERE s.sklad_id = p.sklad_id AND s.language_id = '" . (int)$this->config->get('config_language_id') . "') AS sklad,

второй

 (SELECT c.name FROM " . DB_PREFIX . "condition c WHERE p.condition_id = p.condition_id AND c.language_id = '" . (int)$this->config->get('config_language_id') . "') AS condition,

 

так вот если оставить только первый запрос то все нормально без ошибок, только добавляю второй вылетает сразу же эта ошибка

Share this post


Link to post
Share on other sites

потому что второй кривой очевидно же

Share this post


Link to post
Share on other sites
23 минуты назад, pasha2203 сказал:

p.condition_id = p.condition_id

Тут вы наверно хотели написать c.condition_id = p.condition_id

Share this post


Link to post
Share on other sites
В 19.11.2020 в 01:27, DariyGRAY сказал:

Тут вы наверно хотели написать c.condition_id = p.condition_id

Увы так же ошибка

Share this post


Link to post
Share on other sites
В 19.11.2020 в 01:14, spectre сказал:

потому что второй кривой очевидно же

Может подскажите в чем ошибка

Share this post


Link to post
Share on other sites

пишет что ошибка в синтаксисе только вот понять не могу где именно

Спойлер

$query = $this->db->query("SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM " . DB_PREFIX . "product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM " . DB_PREFIX . "product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM " . DB_PREFIX . "product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "') AS reward, (SELECT s.name FROM " . DB_PREFIX . "sklad s WHERE s.sklad_id = p.sklad_id AND s.language_id = '" . (int)$this->config->get('config_language_id') . "') AS sklad, (SELECT c.name FROM " . DB_PREFIX . "condition c WHERE c.condition_id = p.condition_id AND c.language_id = '" . (int)$this->config->get('config_language_id') . "') AS condition, (SELECT ss.name FROM " . DB_PREFIX . "stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '" . (int)$this->config->get('config_language_id') . "') AS stock_status, (SELECT wcd.unit FROM " . DB_PREFIX . "weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS weight_class, (SELECT lcd.unit FROM " . DB_PREFIX . "length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS length_class, (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM " . DB_PREFIX . "review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '" . (int)$product_id . "' AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "'");

 

Share this post


Link to post
Share on other sites
9 часов назад, AlexDW сказал:

Спасибо вам большое, теперь понял в чем ошибка из мануала, оказалось что CONDITION  зарезервировано системой по этому и была ошибка

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.


  • 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.