Jump to content

Recommended Posts

Люди, в истории заказов, если пытаешься просмотреть заказ, появляется чистая страница с такой ошибкой:

Notice: Error: Таблица 'ceram737_slavceramika.product' не существует
Error No: 1146
SELECT ma.name FROM oc_manufacturer ma JOIN product USING (manufacturer_id) JOIN order_product USING (product_id) WHERE order_id = '35' AND order_product_id = '65' in /home/ceram737/public_html/system/database/mysql.php on line 50

 

 

Подскажите в какую сторону копать (((

Share this post


Link to post
Share on other sites

какой-то ужас к коде.

Префикс есть, префикса нет. Какой-то модуль кривой наверное.

Share this post


Link to post
Share on other sites

Знать бы какой...

Share this post


Link to post
Share on other sites

поиск по строке "USING (manufacturer_id) JOIN" даст ответ

Share this post


Link to post
Share on other sites

спасибо. запустил поиск...

Share this post


Link to post
Share on other sites

файл order.php там есть такой код

public function getOrderManufact($order_id, $order_product_id) {
  $query = $this->db->query("SELECT ma.name FROM " . DB_PREFIX . "manufacturer ma JOIN product USING (manufacturer_id) JOIN order_product USING (product_id) WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$order_product_id . "'");

  return $query->rows;

 

только не понятно какой модуль мог заменить этот файл

Share this post


Link to post
Share on other sites
$query = $this->db->query("SELECT ma.name FROM " . DB_PREFIX . "manufacturer ma JOIN product USING (manufacturer_id) JOIN " . DB_PREFIX . "order_product USING (product_id) WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$order_product_id . "'");

исправить вот так и все заработает

Share this post


Link to post
Share on other sites

Notice: Error: Таблица 'ceram737_slavceramika.product' не существует
Error No: 1146
SELECT ma.name FROM oc_manufacturer ma JOIN product USING (manufacturer_id) JOIN order_product USING (product_id) WHERE order_id = '36' AND order_product_id = '66' in /home/ceram737/public_html/system/database/mysql.php on line 50

 

тоже самое(((

кеш почистил

Share this post


Link to post
Share on other sites
$query = $this->db->query("SELECT ma.name FROM " . DB_PREFIX . "manufacturer ma JOIN " . DB_PREFIX . "product USING (manufacturer_id) JOIN " . DB_PREFIX . "order_product USING (product_id) WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$order_product_id . "'");

пропустил

Edited by nikifalex

Share this post


Link to post
Share on other sites

блин, вот я олух!!! на другом фтп правил... спасибо, добрый человек!!! что я вам должен?

Share this post


Link to post
Share on other sites

добавьтесь в скайп (в профиле есть), будут еще вопросы, обращайтесь. Первая задача была бесплатной :)

Share this post


Link to post
Share on other sites

Еще раз огромное спасибо.

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.