lexter

Спасибо , извините за тупость , пойду разбираться

Ребят помогите пожалуйста решить проблему после нажатия на кнопку "подтверждение заказа" страница index.php?route=checkout/success - белый экран ошибок не наблюдаю ((

Чпу есть у всех ))) первый покупатель всегда самый сложный , давайте смотреть ошибки вместе , чтоб вы могли продавать дальше ) 016-06-07 15:55:15 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 27 2016-06-07 15:55:15 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category pc ON ( p.product_id = pc.product_id ) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pc.category_id = '63'AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 15:55:15 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 22 2016-06-07 15:55:15 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 30 2016-06-07 15:55:15 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 15:55:15 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 40 2016-06-07 15:55:15 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 33 2016-06-07 15:55:15 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/view/theme/default/template/module/last_reviews.tpl on line 10 2016-06-07 15:56:54 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 27 2016-06-07 15:56:54 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category pc ON ( p.product_id = pc.product_id ) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pc.category_id = '99'AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 15:56:54 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 22 2016-06-07 15:56:54 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 30 2016-06-07 15:56:54 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 15:56:54 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 40 2016-06-07 15:56:54 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 33 2016-06-07 15:56:54 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/view/theme/default/template/module/last_reviews.tpl on line 10 2016-06-07 16:03:55 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 27 2016-06-07 16:03:55 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category pc ON ( p.product_id = pc.product_id ) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pc.category_id = '66'AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:03:55 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 22 2016-06-07 16:03:55 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 30 2016-06-07 16:03:55 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:03:55 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 40 2016-06-07 16:03:55 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 33 2016-06-07 16:03:55 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/view/theme/default/template/module/last_reviews.tpl on line 10 2016-06-07 16:04:07 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 27 2016-06-07 16:04:07 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category pc ON ( p.product_id = pc.product_id ) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pc.category_id = '63'AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:04:07 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 22 2016-06-07 16:04:07 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 30 2016-06-07 16:04:07 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:04:07 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 40 2016-06-07 16:04:07 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 33 2016-06-07 16:04:07 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/view/theme/default/template/module/last_reviews.tpl on line 10 2016-06-07 16:05:46 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 27 2016-06-07 16:05:46 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category pc ON ( p.product_id = pc.product_id ) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pc.category_id = '62'AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:05:46 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 22 2016-06-07 16:05:46 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 30 2016-06-07 16:05:46 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:05:46 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 40 2016-06-07 16:05:46 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 33 2016-06-07 16:05:46 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/view/theme/default/template/module/last_reviews.tpl on line 10 2016-06-07 16:06:11 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 27 2016-06-07 16:06:11 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category pc ON ( p.product_id = pc.product_id ) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pc.category_id = '63'AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:06:11 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 22 2016-06-07 16:06:11 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 30 2016-06-07 16:06:11 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:06:11 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 40 2016-06-07 16:06:11 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 33 2016-06-07 16:06:11 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/view/theme/default/template/module/last_reviews.tpl on line 10 2016-06-07 16:07:17 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 27 2016-06-07 16:07:17 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category pc ON ( p.product_id = pc.product_id ) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pc.category_id = '62'AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:07:17 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 22 2016-06-07 16:07:17 - PHP Notice: Undefined index: num_reviews in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 30 2016-06-07 16:07:17 - PHP 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 '' at line 1<br />Error No: 1064<br />SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3' ORDER BY r.date_added DESC LIMIT 0, in /var/www/2wins/data/www/dush.com.ua/system/library/db/mysqli.php on line 40 2016-06-07 16:07:17 - PHP Notice: Trying to get property of non-object in /var/www/2wins/data/www/dush.com.ua/catalog/model/module/last_reviews.php on line 40 2016-06-07 16:07:17 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/controller/module/last_reviews.php on line 33 2016-06-07 16:07:17 - PHP Warning: Invalid argument supplied for foreach() in /var/www/2wins/data/www/dush.com.ua/catalog/view/theme/default/template/module/last_reviews.tpl on line 10

1) 3 2) да , ну он как бы отображается )) 3) oc_review статусы 1 4) Добавлялось микро разметка

https://dush.com.ua/dushevye-boksy/gidromassazhnyy-dushevoy-boks-artex-99-1.html?mfp=manufacturers[35]

Модуль включил , добавил поле с 3 отзывами.. Отзывы в товаре показывает ) Вот к примеру категории где в товаре есть отзывы https://dush.com.ua/dushevye-boksy под описанием в низу добавил модуль

ну я заливал папку 2.0.x

в левой колонке тоже отзывы не вылазят

Купил, установил )) вылезло во всех категориях табличка пустая "Последние отзывы", там где есть отзывы и нету, но самих отзывов нету. По макету добовлял в низ страници

Буду первый , на опенкарт 2.0.1.1

Ну если отзовов нету , то и модуль выводить не надо :))

Было бы не плохо группировать вывод отзывов к конкретным категориям А с этим справились?

Вот Rassol2 напишите ему , он очень хорошо разбирается в модуле. Дмаю за сумму договоритесь

:cry: :cry: :cry:

вы не сможете зайти на ресурс, можете попробовать через онлайн прокси зайти и проверить

Наймите спеца , если самому лень занматьс я))

https://opencartforum.com/topic/16297-%D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%B0%D1%82%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B0%D1%8F-%D0%BE%D0%B1%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0-%D0%BF%D1%80%D0%B0%D0%B9%D1%81-%D0%BB%D0%B8%D1%81%D1%82%D0%BE%D0%B2/ Лучше решения пока не находи, стоит копейки, тех поддержка на высочайшем уровне.

Доброго времени суток уважаемые форумчане. Ищу модель который добавит и будет выводить в карточке дополнительное описание Пред история - У меня в карточке товара есть красивые ссылки на дополнительную и полезную информацию... Яндекс маркет не пропускает :( Хочу эти ссылки перенести в отдельное описание и не отдавать яндекс маркету через yml. и не мало важно чтоб это доп описание можно было выгружать загружать с помощью "CSV Price Pro 4" Заранее спасибо за ваше потраченное время и помощь.

Господа смоделирую ситуацию, подскажите пожалуйста )) Есть залитый товар через модулю , на данный момент надо допросить один атрибут. Вопрос в чем .... как указать модулю не обновлять категории товара ? (к сожалению старый прайс с категориями потерялся) заранее спасибо

да , и можно втулить микро разметку в категории ) будут шикарные снипеты )

Я просто думал , что можно настроить как то парсингом ...

так не пойдет, так как есть товары залитые без модуля :(

Ребят подскажите можно ли обновлять цену наличие из того файла ? http://laris.inf.ua/ если да, с чего начинать копать ?

Спасибо большое а скажите как правильно поступить курс в магазина гривна по умолчанию по курсу 25 к 1 доллару как обновить правильно цены к примеру по курсу 25.1

Огромное человеческое спасибо!!! все переклацал до этого не додумался)))