vn.hsv.productCategory plugin problem

[carlos]

Hi Hiep:

I installed on my source idempiere 3.0 instance your plugin: vn.hsv.productCategory.  However, when I enter to info product window using GardenWorld and search by product category alone or combined with other search option I got the following error (in this case I just searched by product category=patio):

SEVERE: SELECT COUNT(*) FROM ( SELECT DISTINCT p.M_Product_ID, p.Discontinued AS Discontinued, p.Value AS Value, p.Name AS Name, bp.Name AS Vendor, pa.IsInstanceAttribute AS IsInstanceAttribute FROM M_Product p
LEFT OUTER JOIN M_ProductPrice pr ON (p.M_Product_ID=pr.M_Product_ID AND pr.IsActive='Y')
LEFT OUTER JOIN M_AttributeSet pa ON (p.M_AttributeSet_ID=pa.M_AttributeSet_ID)
LEFT OUTER JOIN M_Product_PO ppo ON (p.M_Product_ID=ppo.M_Product_ID AND ppo.IsCurrentVendor='Y' AND ppo.IsActive='Y')
LEFT OUTER JOIN C_BPartner bp ON (ppo.C_BPartner_ID=bp.C_BPartner_ID) WHERE p.IsActive='Y' AND M_Product_Category_ID IN (110)  AND p.AD_Client_ID IN(0,11) AND p.AD_Org_ID IN(50007,0,50004,50005,50006,50000,50001,50002,11,12) AND  (p.M_Product_ID IS NULL OR p.M_Product_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 208 AND AD_User_ID <> 101 AND IsActive = 'Y' ))  AND  (pa.M_AttributeSet_ID IS NULL OR pa.M_AttributeSet_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 560 AND AD_User_ID <> 101 AND IsActive = 'Y' ))  AND  (bp.C_BPartner_ID IS NULL OR bp.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 101 AND IsActive = 'Y' ))  ) a
org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
    at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:56)
    at org.postgresql.core.v3.SimpleParameterList.setBinaryParameter(SimpleParameterList.java:122)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.bindBytes(AbstractJdbc2Statement.java:2294)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.setInt(AbstractJdbc2Statement.java:1279)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1882)
    at org.postgresql.jdbc3g.AbstractJdbc3gStatement.setObject(AbstractJdbc3gStatement.java:36)
    at org.postgresql.jdbc4.AbstractJdbc4Statement.setObject(AbstractJdbc4Statement.java:47)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setObject(NewProxyPreparedStatement.java:955)
    at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.compiere.db.StatementProxy.invoke(StatementProxy.java:128)
    at com.sun.proxy.$Proxy3.setObject(Unknown Source)
    at org.adempiere.webui.info.InfoWindow.setParameter(InfoWindow.java:982)
    at org.adempiere.webui.info.InfoWindow.setParameters(InfoWindow.java:954)
    at org.adempiere.webui.info.InfoWindow.testCount(InfoWindow.java:1705)
    at org.adempiere.webui.info.InfoWindow.testCount(InfoWindow.java:1670)
    at org.adempiere.webui.panel.InfoPanel.executeQuery(InfoPanel.java:538)
    at org.adempiere.webui.info.InfoWindow.executeQuery(InfoWindow.java:1499)
    at org.adempiere.webui.info.InfoProductWindow.executeQuery(InfoProductWindow.java:871)
    at org.adempiere.webui.panel.InfoPanel.onQueryCallback(InfoPanel.java:1973)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2736)
    at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2664)
    at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
    at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1765)
    at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1550)
    at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1260)
    at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:603)
    at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:485)
    at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:494)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
    at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
    at org.eclipse.jetty.server.Server.handle(Server.java:497)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
    at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
    at java.lang.Thread.run(Thread.java:745)

I tried to debug the code but I do not understand why it enters the setparameter function in infowindow and got lost. any idea how to solve this?

Regards,

[Hiep Lq]

sorry for late response. not yet update it to 3.0 i will check and feedback to you soon.