Post by Boekel » Thu Sep 30, 2010 11:27 pm

bump

Newbie

Posts

Joined
Mon Aug 30, 2010 9:38 pm

Post by bluelight » Tue Oct 05, 2010 12:09 pm

dramony wrote:will this work on the latest version(OC 1.4.9.1)?
Change: admin/model/catalog/product.php.
JAY6390 wrote:For those interested, the reason for the grouping in line 238

Code: Select all

$sql .= " GROUP BY pd.name"  ;  
This should actually be

Code: Select all

$sql .= " GROUP BY pd.product_id"  ;  
It work for v1.4.9.1

Newbie

Posts

Joined
Tue Oct 05, 2010 12:03 pm

Post by Boekel » Tue Oct 05, 2010 9:06 pm

I still get the following error:

Error: Unknown column 'p2c.category_id' in 'where clause'
Error No: 1054
SELECT * FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND p2c.category_id = '38' GROUP BY pd.product_id ORDER BY pd.name ASC LIMIT 0,20

Version 1.4.8b

Newbie

Posts

Joined
Mon Aug 30, 2010 9:38 pm

Post by dramony » Sat Nov 20, 2010 2:44 pm

macmillank wrote:Hi, thanks for the module... works great!

I noticed a minor bug and was wondering how i should go about fixing it.

After you filter by a category, the number of pages showing does update.

For example if I have a total of 73 products (4 pages in total if I show 20 items per page) and I have 20 products in category A. And if I filter by category A, the number of pages shown in still 4 pages. Message on bottom left -> "showing 1-20 of 73 (4 pages)". But when you click on page 2, 3 or 4 it will show "no products"

Thanks.

I also got this error.

User avatar
Active Member

Posts

Joined
Sat Oct 24, 2009 12:34 pm

Post by liwzy » Mon Jan 10, 2011 6:50 pm

this mod should be included in the cart by default, its not there in 1.4.9.3 yet

Newbie

Posts

Joined
Sat Dec 04, 2010 6:25 am

Post by i2Paq » Tue Jan 11, 2011 7:51 pm

liwzy wrote:this mod should be included in the cart by default, its not there in 1.4.9.3 yet
I agree.

It does work with 1.4.9.2 etc.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by afwollis » Wed Jan 12, 2011 1:04 am

Boekel wrote:I still get the following error:

Code: Select all

Error: Unknown column 'p2c.category_id' in 'where clause'
Error No: 1054
SELECT * FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND p2c.category_id = '38' GROUP BY pd.product_id ORDER BY pd.name ASC LIMIT 0,20
Version 1.4.8b
you need to change the query.
adding simple

Code: Select all

 LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
right after

Code: Select all

 LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
must solve this problem

Русское коммьюнити разработчиков OpenCart - myopencart.ru

some useful mods:
[Released] Orders and Comments AT-A-GLANCE, [Released] Prof. Invoice and Packingslip, [Released] Recently viewed

My commercial modules: [W]ebme Compare Products, [W]ebme Bought With This


Active Member

Posts

Joined
Tue Jan 11, 2011 5:41 am
Location - Ukraine

Post by micdansan » Sun May 15, 2011 4:27 pm


New member

Posts

Joined
Fri Apr 01, 2011 10:25 pm

Post by saif11 » Fri Feb 24, 2012 7:40 pm

Here is an Commercial Extension for Select Multiple category for filtering.

http://www.opencart.com/index.php?route ... ion_id=512

Opencart Extension ,Theme
Web development


Preview Product Page in Admin Panel
Admin product filter by Multiple category



Global Technology Advancement


Newbie

Posts

Joined
Thu Aug 18, 2011 1:14 pm
Who is online

Users browsing this forum: No registered users and 2 guests