AdminPublishProductMgr functionality has not been installed

[ganesh.boil]

Hi,
i'm new to konakart. I have installed konakart 3.2 in my windows machine by using windows setup file. While installing it asks me for creating the DB and created DB sucessfully. And i just logged in with konakartadmin app using admin@konakart.com and pwd princess. I entered into that sucessfully. After entering i have created a couple of manufacturers and try to create new products. I have created manufactures sucessfully But while creating the new product i'm getting the following error.

java.sql.SQLException: Incorrect arguments to mysql_stmt_execute


Exception Stack Trace =
at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:109)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:688)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:554)
at com.konakartadmin.bl.AdminProductMgr.insertProduct(AdminProductMgr.java:190)
at com.konakartadmin.bl.KKAdmin.insertProduct(KKAdmin.java:1935)
at com.konakartadmin.server.KKAdminGWTServiceImpl.insertProduct(KKAdminGWTServiceImpl.java:3741)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:164)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509)
at java.lang.Thread.run(Thread.java:619)

Exception Cause =
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at com.workingdogs.village.Record.saveWithInsert(Record.java:438)
at com.workingdogs.village.Record.save(Record.java:234)
at com.workingdogs.village.Record.save(Record.java:201)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:685)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:554)
at com.konakartadmin.bl.AdminProductMgr.insertProduct(AdminProductMgr.java:190)
at com.konakartadmin.bl.KKAdmin.insertProduct(KKAdmin.java:1935)
at com.konakartadmin.server.KKAdminGWTServiceImpl.insertProduct(KKAdminGWTServiceImpl.java:3741)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:164)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509)
at java.lang.Thread.run(Thread.java:619)

And in tomcat i'm getting the following warning.

WARN  (AdminMgrFactory.java:instantiateAdminPublishProdMgr:1070)
AdminPublishProductMgr functionality has not been installed



Any help is appriciated...

Regards,
Ganesh

[heidi]

Which version of MySQL are you using?

[heidi]

And in tomcat i'm getting the following warning.

WARN  (AdminMgrFactory.java:instantiateAdminPublishProdMgr:1070)
AdminPublishProductMgr functionality has not been installed

This isn't part of the Community Edition product. 
It's part of the Enterprise Extensions. 
There's no problem... you just don't have that functionality in the Community Edition.

[ganesh.boil]

Hi heidi,

I'm using mysql version 5.0.18

[heidi]

I believe 5.0.18 was released in 2005...    I'd upgrade MySQL if I were you.

There were identical problems with 5.0.16, so maybe also with 5.0.18.

[ganesh.boil]

Hi heidi,
thanks 4 ur support. I have installed mysql 5.0.45 in my local machine. And now its working like a champ.
And some time in tomcat console i'm getting the following warning. I thinks it's also related to some enterprise edition's stuff.plz check ones.

"WARN  (MgrFactory.java:instantiateWishListMgr:782) WishList functionality has not been installed"

[heidi]

Yes, that's another Enterprise feature.

[ganesh.boil]

Thank heidi,
thanks 4 ur support.
After overcoming with this problem i'm comingup with a new one.
The problem is yesterday i logged in to the admin application sucessfully. But now when i'm trying to enter into the admin application with the existeed credentials (those are having the role called "Super User") i'm getting the following error.

User with id = 2 cannot access the API call : getAllRoles
Exception Message = User with id = 2 cannot access the API call : getAllRoles

plz give any sugession on this.. onesagain thanks 4 ur support.

[ganesh.boil]

Hi heidi plz look into the above one!!!