hi everyone,
I've just tested the cart some more and got the following exception at checkout:
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
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
hi julie,
thanks for the answer. I'm not that sure about mysql. would the command be like this:
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
Hi,
This is the command :
ALTER TABLE orders_products MODIFY products_model VARCHAR(64);
which is what you said :)
great, thanks :)