Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by crazymaster » Wed Apr 14, 2010 1:49 am

I am not 100% sure that it is working, but if somebody want - can try it.
http://www.mediafire.com/?iyydxe1cyhq
If everything is OK i will upload it in the Extensions category.

I am getting this error when i select category and click 'filter':

Code: Select all

Error: Unknown column 'p2c.category_id' 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 p2c.category_id ='62'
but i am not sure if the problem is from the plugin or from my opencart database, so somebody can test it and fix it if it have the same problem

if somebody test it - post the results here
crazymaster
New member
Posts
67
Joined
Wed Apr 07, 2010 10:29 pm
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by crazymaster » Wed Apr 14, 2010 10:13 pm

nobody ?
crazymaster
New member
Posts
67
Joined
Wed Apr 07, 2010 10:29 pm
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by i2Paq » Fri Apr 16, 2010 10:07 pm

You want me to install your Mod?

No time, sorry.

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
i2Paq
Global Moderator
Posts
12244
Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by crazymaster » Fri Apr 16, 2010 10:44 pm

hehe, no, just to tell me what this error means, and if somebody tried this module to tell if it works :)
crazymaster
New member
Posts
67
Joined
Wed Apr 07, 2010 10:29 pm
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by i2Paq » Fri Apr 16, 2010 10:48 pm

In one of the query's the p2c.category_id is not found.

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
i2Paq
Global Moderator
Posts
12244
Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by cmebd » Sat Apr 17, 2010 6:47 am

i2Paq wrote:In one of the query's the p2c.category_id is not found.
Wow that was so helpful - even I could have figured that one out and I don't profess to be a programmer or know about dbases....

Please provide useful responses that help others who may not be as experienced (as you seem to think you are). Too much space is taken up on the forum with these inane counter productive responses.

A stupid question is the one you -don't- ask.........(Anon)

)C1.5.0.1 (IN devel)
OC V1.4.9.5
OC V1.4.9.2
OC V1.4.7
OC V1.3.4

User avatar
cmebd
Active Member
Posts
402
Joined
Fri Nov 13, 2009 11:17 am
Location - Tasmania, Australia
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by i2Paq » Sat Apr 17, 2010 9:49 pm

cmebd wrote:
i2Paq wrote:In one of the query's the p2c.category_id is not found.
Wow that was so helpful - even I could have figured that one out and I don't profess to be a programmer or know about dbases....

Please provide useful responses that help others who may not be as experienced (as you seem to think you are). Too much space is taken up on the forum with these inane counter productive responses.
I'm sorry but where did I ever profess to be a programmer or said that I have extended knowledge about databases?

The question is;
crazymaster wrote:hehe, no, just to tell me what this error means, and if somebody tried this module to tell if it works :)
The answer is that what I'm given him, telling him that there is something wrong with his query. So, what is your point or problem?

To return the ball: why did you not came up with an answer instead of posting your troll?
"Too much space is taken up on the forum with these inane counter productive responses."

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
i2Paq
Global Moderator
Posts
12244
Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by crazymaster » Sat Apr 17, 2010 10:03 pm

heheh, we don't need to argue here, we are here to use opencart and to upgrade it :)

i tried to fix this problem, but without success

i thought that the problem is that i copied my categories from the old database(1.4.6), but i deleted them and added them manually from the admin panel, but the problem is still there

if somebody fix the problem - post here, how that is done/i want to know where is my mistake/ :)

Edit:
also in my file the code for admin filter category is marked with //filter category start// and //filter category end// so it can be changed and used easy... if it is fixed :)
crazymaster
New member
Posts
67
Joined
Wed Apr 07, 2010 10:29 pm
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by OSWorX » Tue Apr 20, 2010 2:17 pm

I would say it should be something like this (untested):

Code: Select all

$query = 'SELECT COUNT(*) AS total'
. ' FROM product AS p'
. ' LEFT JOIN product_description AS pd ON (p.product_id = pd.product_id)'
. ' LEFT JOIN product_to_category AS p2c ON (p.product_id = p2c.product_id)'
. ' WHERE pd.language_id = \'' . (int) $id1 . '\''
. ' AND p2c.category_id = \'' . (int) $id2 . '\''
;
p.s.: start building your queries how they should be, not that confused way they are now everywhere!
Use

1. AS (e.g. product_to_category AS p2c)
2. use a readable format (like above).

This would help everybody in reading these lines of code AND finding what is searched for in case of errors and/or adding additional lines.

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.

User avatar
OSWorX
Administrator
Posts
7828
Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by pepiw » Sat May 01, 2010 4:36 pm

I`m totaly rebuild this contr. Now works fine in version 1.4.7

Download here:
http://www.opencart.com/index.php?route ... sion_id=37
pepiw
Newbie
Posts
4
Joined
Thu Mar 25, 2010 7:17 pm
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by selida » Tue Jul 06, 2010 4:34 pm

Hello, it doesn't work on the latest version 1.4.8b. Any updates?
selida
Newbie
Posts
1
Joined
Tue Jul 06, 2010 4:31 pm
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

Post by tommyla » Sat Jul 10, 2010 9:01 am

selida wrote:Hello, it doesn't work on the latest version 1.4.8b. Any updates?
am looking for update to 1.4.8b to :choke:
tommyla
Active Member
Posts
144
Joined
Wed Jul 22, 2009 9:49 pm
Location - Norway
Top

Re: Admin Product Filter By Category[1.4.7 UPDATE]

Quote

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

Here is two solution for 1.5.1 on more .

For selecting Multiple category at a time.

http://www.opencart.com/index.php?route ... on_id=2663

and
Single category filtering
http://www.opencart.com/index.php?route ... on_id=2663

Opencart Extension ,Theme
Web development


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



Global Technology Advancement

saif11
Newbie
Posts
9
Joined
Thu Aug 18, 2011 1:14 pm
Top
Post Reply
Return to “Free Contributions”
Who is online

Users browsing this forum: No registered users and 9 guests