You have an error in your SQL syntax near

[coala4]

:'( Please help me with this one (it's the error when I try to access product listing)

http://sportbenz.de/os/index.php?cPath=24

 

 

 

-----------------------------

1064 - You have an error in your SQL syntax near '.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(' at line 1

 

select m.manufacturers_name, p.products_image, pd.products_name, pd.products_description p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '24' order by pd.products_name limit 0, 20

 

[TEP STOP]

----------------------------------------

 

 

 

 

I can't find the file where I would be able to fix this problem ... and how????

 

thank you

[Jan Zonjee]

There is a comma missing (the red one):

pd.products_name, pd.products_description, p.products_id,

Possibly it is in one of the sql queries half way down till 2/3 the index.php page. Doesn't look like stock osC on first glance to me since there the p.products_id is second in the list.

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as

I could be very wrong of course.

[coala4]

There is a comma missing (the red one):

Possibly it is in one of the sql queries half way down till 2/3 the index.php page. Doesn't look like stock osC on first glance to me since there the p.products_id is second in the list.

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as

I could be very wrong of course.

<{POST_SNAPBACK}>

 

 

 

 

 

Thanks JanZ, that was the problem ....

 

But now, another problem in front of me .... :

 

 

Fatal error: Call to undefined function: tep_flatten_product_description()

 

...product_listing.php on line 145

 

 

 

That two lines are from contribution and I'm not sure what is the wrong because I did everything described in the install instruction? ... contribution is "product_description 1.2d"

 

 

any idea?