ТЕМА:

Собственно ответ с темы Нашел как убрать в VamShop Сравнение товаров.

Надобно открыть 2 файла product_listing_columns и product_listing_list, которые находятся в папке по адресу /templates/шаблон/module/product_listing/ и удалить коды содержащие compare

в product_listing_columns

и

в файле product_listing_list

и

На этом все

Это понадобилось потому, что иногда приходит ошибка db_error от базы данных MySQL такого рода :

MYSQL ERROR REPORT
- 23/01/2014 14:01:26

---

1064 - 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 ''25''' at line 1

select m.manufacturers_name, mi.manufacturers_meta_title, mi.manufacturers_meta_description, mi.manufacturers_meta_keywords from manufacturers m left join manufacturers_info mi on mi.manufacturers_id = m.manufacturers_id where m.manufacturers_id = '25''

---

Server Name : avtomagazin.biz.ua
Remote Address: 176.9.246.99
Referer :
Requested : /dvigatel.html?filter_id=25'
Trace Back : manager.php:53(includearray(1) {; [0]=>; string(65) "index.php"; }; ) => index.php:55(requirearray(1) {; [0]=>; string(75) "includes/header.php"; }; ) => includes/header.php:39(includearray(1) {; [0]=>; string(85) "includes/modules/metatags.php"; }; ) => includes/modules/metatags.php:91(vamDBqueryarray(1) {; [0]=>; &string(253) "select m.manufacturers_name, mi.manufacturers_meta_title, mi.manufacturers_meta_description, mi.manufacturers_meta_keywords from manufacturers m left join manufacturers_info mi on mi.manufacturers_id = m.manufacturers_id where m.manufacturers_id = '25''"; }; ) => includes/application_top.php:202(vam_db_queryarray(1) {; [0]=>; &string(253) "select m.manufacturers_name, mi.manufacturers_meta_title, mi.manufacturers_meta_description, mi.manufacturers_meta_keywords from manufacturers m left join manufacturers_info mi on mi.manufacturers_id = m.manufacturers_id where m.manufacturers_id = '25''"; }; ) => inc/vam_db_query.inc.php:34(vam_db_errorarray(3) {; [0]=>; &string(253) "select m.manufacturers_name, mi.manufacturers_meta_title, mi.manufacturers_meta_description, mi.manufacturers_meta_keywords from manufacturers m left join manufacturers_info mi on mi.manufacturers_id = m.manufacturers_id where m.manufacturers_id = '25''"; [1]=>; &int(1064); [2]=>; &string(151) "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 ''25''' at line 1"; }; )