Adding/Editing products section throwing error

[aashik_zzz]

Hi,

Im new to konkart application..When im trying to add/edit a product in my konakart admin application.
It throw me the error.
But i can able to add/edit manufacture,category in my konakart admin application.

Error Msg:-

java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
Exception Stack Trace =
at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:106)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:663)
at org.apache.torque.util.BasePeer.access$000(BasePeer.java:80)
at org.apache.torque.util.BasePeer$4.process(BasePeer.java:1240)
at org.apache.torque.util.BasePeer.processTables(BasePeer.java:1726)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1235)
at com.konakartadmin.bl.AdminProductMgr.editProduct(Unknown Source)
at com.konakartadmin.bl.KKAdmin.editProduct(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.editProduct(Unknown Source)
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:585)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:528)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:265)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)

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.saveWithUpdate(Record.java:349)
at com.workingdogs.village.Record.save(Record.java:234)
at com.workingdogs.village.Record.save(Record.java:198)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:660)


Anyone one suggest me how to solve this problem
Thanks in advance,

Regards
Aashik

[greg]

Hi,

Please explain your set-up.   How did you install KonaKart?  Which version?  Which platform?  How did you create the database (and which version of mysql?).

Greg

[aashik_zzz]

Hi Greg,
i've installed KonaKart-2.2.6.0 in windows and im using mysql 5.0.16 as db.
I've used the sample data given by konakart which is comes with setup file.

Regards,
Aashik

[greg]

How did you install?  using the wizard?

[aashik_zzz]

Hi greg,

First of all thanks for your reply.
Yes. While running the setup file,it ask for db information's and port no. Db connection is successful
And the installation completed successfully.

Can u guess what the problem is about??

Regards,
Aashik

[greg]

Hi Aashik,

No idea at the moment.  If I install KonaKart using the wizard and the database loading is executed successfully, I do not get this error.

Are you sure your database loaded correctly (no errors at the end of the scolling window in the wizard)?

Have you deleted certain critical data that the products rely on?

If you installed a 2nd time and did nothing but edit a product I would expect it to work...

Greg

[aashik_zzz]

Hi Greg,

I dont get any error when database SQL dump execution and the installation was successful. And i didn't delete anything.
Actually ,what the scernario is ,when im trying to edit/add a product and click save button ,the error is thrown.

I've attached the screenshot of the error msg.
In that image i've a added a WORD called Testing in Product Description. And then i clicked the save button.

Regards,
Aashik

[greg]

I'm not sure what the problem is here.  It could be some kind of incompatibility with that 3-year old version of mysql that you're using (or the way it's configured)?  (although this is a bit puzzling as I know that KonaKart works fine on MySQL 4.1)

Can you upgrade your mysql to a more recent version?

Are you using the InnoDB engine?

Greg

[aashik_zzz]

Hello Greg,

Yes,Im using InnoDB engine.
And I'll try with the new mysql version.

Aashik.

[aashik_zzz]

Hello greg,

Problem solved. I think konakart is incompatibility with the mysql version(5.0.16) .
I've migrated mysql to newer version(5.0.67).
Now its working fine.

Thanks Greg .

Aashik