KKException at checkout

[Anni]

hi everyone,

I've just tested the cart some more and got the following exception at checkout:

Code Select Expand


The details of the malfunction are :

Exception Name = com.konakart.app.KKException
Exception Message = org.apache.torque.TorqueException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'products_model' at row 1

Exception Stack Trace =
at com.konakart.app.KKEng.saveOrder(KKEng.java:1404)
at com.konakart.al.OrderMgr.saveOrder(OrderMgr.java:301)
at com.konakart.actions.CheckoutConfirmationSubmitAction.execute(CheckoutConfirmationSubmitAction.java:160)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
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:619)


can anyone help with that?

thanks,
anni

[julie]

Hi Anni,

In order to fix the problem you need to do an "alter table" on the orders_products table and make the attribute products_model a varchar(64) rather than a varchar(12) which is what the osCommerce compatible DB has . In our next version the update script will make this change for you.

Regards,

Julie

[Anni]

hi julie,

thanks for the answer. I'm not that sure about mysql. would the command be like this:

Code Select Expand

alter table orders_products modify products_model VARCHAR(64);

I don't want to mess up the database so I'd like to be sure before attempting any change.

thanks again,
anni

[julie]

Hi,

This is the command :

ALTER TABLE orders_products MODIFY products_model VARCHAR(64);

which is what you said 

[Anni]

great, thanks