Ругается print_product_info.php

[Boris Kramarenko 0]

Вот собственно проблема.

Вот лог

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 'and products_parameters.products_parameters_id is not null and products_paramete' at line 1

SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id =  and products_parameters.products_parameters_id is not null and products_parameters_order >= 0 and products_parameters2products_order >= 0 order by IF(products_parameters2products_order > 0, products_parameters2products_order, products_parameters_order)
---------------------------------------
Server Name   : esotrance.ru
Remote Address: 213.247.155.40
Referer       : http://esotrance.ru/print_product_info.php/products_id/10
Requested     : /print_product_info.php/products_id/templates/esotrance//db_error.htm
Trace Back    : print_product_info.php:149(vamDBqueryarray(1) {;   [0]=>;   &string(376) "SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id =  and products_parameters.products_parameters_id is not null and products_parameters_order >= 0 and products_parameters2products_order >= 0 order by IF(products_parameters2products_order > 0, products_parameters2products_order, products_parameters_order)"; }; ) => includes/application_top.php:199(vam_db_queryarray(1) {;   [0]=>;   &string(376) "SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id =  and products_parameters.products_parameters_id is not null and products_parameters_order >= 0 and products_parameters2products_order >= 0 order by IF(products_parameters2products_order > 0, products_parameters2products_order, products_parameters_order)"; }; ) => inc/vam_db_query.inc.php:34(vam_db_errorarra
 y(3) {;   [0]=>;   &string(376) "SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id =  and products_parameters.products_parameters_id is not null and products_parameters_order >= 0 and products_parameters2products_order >= 0 order by IF(products_parameters2products_order > 0, products_parameters2products_order, products_parameters_order)";   [1]=>;   &int(1064);   [2]=>;   &string(226) "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 'and products_parameters.products_parameters_id is not null and products_paramete' at line 1"; }; )
[/code]


или

[code]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 'and products_parameters.products_parameters_id is not null and products_paramete' at line 1

SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id =  and products_parameters.products_parameters_id is not null and products_parameters_order >= 0 and products_parameters2products_order >= 0 order by IF(products_parameters2products_order > 0, products_parameters2products_order, products_parameters_order)
---------------------------------------
Server Name   : esotrance.ru
Remote Address: 67.195.110.176
Referer       : http://esotrance.ru/print_product_info.php/products_id/222
Requested     : /print_product_info.php/products_id/templates/esotrance//db_error.htm
Trace Back    : print_product_info.php:149(vamDBqueryarray(1) {;   [0]=>;   &string(376) "SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id =  and products_parameters.products_parameters_id is not null and products_parameters_order >= 0 and products_parameters2products_order >= 0 order by IF(products_parameters2products_order > 0, products_parameters2products_order, products_parameters_order)"; }; ) => includes/application_top.php:199(vam_db_queryarray(1) {;   [0]=>;   &string(376) "SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id =  and products_parameters.products_parameters_id is not null and products_parameters_order >= 0 and products_parameters2products_order >= 0 order by IF(products_parameters2products_order > 0, products_parameters2products_order, products_parameters_order)"; }; ) => inc/vam_db_query.inc.php:34(vam_db_errorarra
 y(3) {;   [0]=>;   &string(376) "SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id =  and products_parameters.products_parameters_id is not null and products_parameters_order >= 0 and products_parameters2products_order >= 0 order by IF(products_parameters2products_order > 0, products_parameters2products_order, products_parameters_order)";   [1]=>;   &int(1064);   [2]=>;   &string(226) "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 'and products_parameters.products_parameters_id is not null and products_paramete' at line 1"; }; )

такое ощущение, что он не модет найти что-то.

[Bububu 0]

Обсуждалось вчера, там же и решение: http://vamshop.ru/forum/index.php?topic=5198.msg43305#msg43305

[Boris Kramarenko 0]

Спасибо, но поиск не помог )))

а за ссылку спасибо