SQL Error 1064

[offerandsell]

Hi,

 

I had installed the osc and all works fine.

 

Today I installed a Contrib Artikelmerkmale in Produktliste V1.0 deutsch

http://www.oscommerce.com/community/contri...ons,2438/page,6

 

After this, I got the followinfs Error ...

 

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

1064 - You have an error in your SQL syntax near 'and c.parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id=' at line 1

 

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where and c.parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id='2' order by sort_order, cd.categories_name

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

 

I have deleted my database and installed it new, but zhe error o the same ...

 

eShop http://eshop.offerandsell.de

 

Has anyone an idea, how to eliminate this error?

 

Thanx

Michael

[Guest]

it's probably something you changed. Concentrate on the where clause of the sql queries; the problem is there is starting valid argument for the where clause

 

where and

[offerandsell]

that was also my thinking, but if I delete alls and install new ...

the error is the same, if I clicked a Link in the categories ...

 

If I you an Zen-Cart contrib ... all semms to work ...