Post by costty » Thu Feb 12, 2009 2:50 pm

I make a new install with v 1.1.2 and I receive the same error when I mark search in description.
Write “hp” push search and after that mark “search in description” box and search again.
This is the error:
Error: Unknown column 'pd.long_description' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND (pd.name LIKE '%hp%' OR pd.long_description LIKE '%hp%') AND p.date_available < NOW() AND p.status = '1'


The same error when I try to make advanced search on demo from your web site.
http://demo.opencart.com/index.php?rout ... cription=1

Newbie

Posts

Joined
Wed Feb 11, 2009 10:11 pm

Post by Blueforce » Thu Feb 12, 2009 3:52 pm

Hi there!

I think the problem is solved in v1.1.3

1.1.3 is the current version on the download link!

Regards,
Leffe

New member

Posts

Joined
Thu Feb 12, 2009 7:11 am
Location - Sweden

Post by jc » Thu Feb 12, 2009 4:12 pm

When I downloaded opencart_v1.1.3.zip on the website, unzip it and I have opencart_v1.1.2(!?!)

jc
Newbie

Posts

Joined
Sun Feb 08, 2009 3:02 pm

Post by Blueforce » Thu Feb 12, 2009 4:36 pm

Hi!

Yes I also noticed that, but I know for shure that the file with the error has been updated..
You actually just need one file from the new package, ant it is:
catalog/model/catalog/product.php
If you dont want to reinstall you can copy that file to your previous installation.

Good Luck!
/Leffe

New member

Posts

Joined
Thu Feb 12, 2009 7:11 am
Location - Sweden
Who is online

Users browsing this forum: No registered users and 16 guests