Product description

[PVK]

I have installed the contribution : product_description 1.2d

 

 

after i installed it and returned to the shop i received following error:

 

1109 - Unknown table 'pd.products_descriptionp' in field list

 

select p.products_image, pd.products_name, pd.products_descriptionp.products_quantity, m.manufacturers_name, 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 = '5' group by p.products_id order by pd.products_name limit 0, 9

 

[TEP STOP]

 

 

Now i can see that the error propably lies in the fact that there is no , sign between products_description and p.products_quantity in the code above.

 

What i don't know is where this is defined .

As far as i know i haven't written this anywhere since i just followed the directions in the contribution [to be sure i did the contribution 3 times to make sure it wasn't a typo error from my side]

 

Does anyone have a clue how to solve this ??

 

 

Thanks

Edited July 19, 2004 by PVK

[PVK]

Solved it, the problem was in the index.php file.

 

Very weird, but for some reason a , sign was not recogniced, and when editing directly on the server via ftp it suddenly worked :)

 

Still have no clue why this is, but hey it works.