date_added: Incorrect datetime value: ''

[ByDcc]

   Hi all,
   I installed KonaKart-6.5.0.0 on Windows 7 manually.
   I used mysql 5.6.10.1 inmoDB and konakart_demo.sql.
   I copied the duplicated jars and generated konakart and konakartadmin wars.

   I deployed them successfully on apache-tomcat-6.0.36.
   The first call to the application with http://localhost:8080/konakart shows the next error:

Unfortunately we have encountered a malfunction.
Please contact the system administrator.

   Logs on Tomcat show the nect:

Data truncation: Incorrect datetime value: '' for column 'date_added' at row 1

   Could you tell me what I missed?

   Thank you in advance.

Complete trace:

Code Select Expand

28-feb 22:11:41 ERROR (?:handleException:?) A customer has received the followin
g exception message: : Exception Name = com.konakart.app.KKException : Exception
Message = org.apache.torque.TorqueException: com.mysql.jdbc.MysqlDataTruncation
: Data truncation: Incorrect datetime value: '' for column 'date_added' at row 1
<br>The full exception is:
com.konakart.app.KKException: org.apache.torque.TorqueException: com.mysql.jdbc.
MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'd
ate_added' at row 1
        at com.konakart.app.KKEng.manageThrowable(Unknown Source)
        at com.konakart.app.KKEng.setCookie(Unknown Source)
        at com.konakart.actions.BaseAction.setKKCookie(Unknown Source)
        at com.konakart.actions.BaseAction.manageCookies(Unknown Source)
        at com.konakart.actions.BaseAction.getKKAppEng(Unknown Source)
        at com.konakart.actions.CatalogMainPageAction.execute(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
ctionInvocation.java:453)
        at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
ultActionInvocation.java:292)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:255)
        at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.interce
pt(DebuggingInterceptor.java:256)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.interc
ept(ConversionErrorInterceptor.java:138)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
(ParametersInterceptor.java:211)
        at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(MethodFilterInterceptor.java:98)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
(ParametersInterceptor.java:211)
        at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(MethodFilterInterceptor.java:98)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
cept(StaticParametersInterceptor.java:190)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(Multi
selectInterceptor.java:75)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(Checkbox
Interceptor.java:90)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUp
loadInterceptor.java:243)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(
ModelDrivenInterceptor.java:100)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.inte
rcept(ScopedModelDrivenInterceptor.java:141)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(Cha
iningInterceptor.java:145)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(Pr
epareInterceptor.java:171)
        at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(MethodFilterInterceptor.java:98)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInt
erceptor.java:176)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(Ser
vletConfigInterceptor.java:164)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasI
nterceptor.java:192)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.inter
cept(ExceptionMappingInterceptor.java:187)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at org.apache.struts2.json.JSONInterceptor.intercept(JSONInterceptor.jav
a:172)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at com.konakart.actions.interceptors.LoggingInterceptor.intercept(Unknow
n Source)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:249)
        at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j
ava:54)
        at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.jav
a:511)
        at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(Exec
uteOperations.java:77)
        at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
.doFilter(StrutsPrepareAndExecuteFilter.java:91)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:879)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:600)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:17
03)
        at java.lang.Thread.run(Thread.java:722)
Caused by: org.apache.torque.TorqueException: com.mysql.jdbc.MysqlDataTruncation
: Data truncation: Incorrect datetime value: '' for column 'date_added' at row 1

        at org.apache.torque.util.BasePeer.throwTorqueException(Unknown Source)
        at org.apache.torque.util.BasePeer.insertOrUpdateRecord(Unknown Source)
        at org.apache.torque.util.BasePeer.doInsert(Unknown Source)
        at org.apache.torque.util.BasePeer.doInsert(Unknown Source)
        at com.konakart.bl.CookieMgr.setCookie(Unknown Source)
        ... 67 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect dateti
me value: '' for column 'date_added' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2868)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt
atement.java:1169)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared
Statement.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 org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del
egatingPreparedStatement.java:105)
        at com.workingdogs.village.Record.saveWithInsert(Unknown Source)
        at com.workingdogs.village.Record.save(Unknown Source)
        at com.workingdogs.village.Record.save(Unknown Source)
        ... 71 more


[ming]

Hi,

I just tried a default installation on the new MySQL 5.6.10.1 and ran into a problem...

When you loaded the db you will probably have got (?):

ALTER TABLE products_description MODIFY products_name VARCHAR(256);
Message:   Specified key was too long; max key length is 767 bytes
SQLState:  42000
ErrorCode: 1071

(This error would stop other essential SQL executing)

This occurs if you have a UTF8 db (which I do).  (Because 3*256 > 767)   (varchar(255 would work!))

Some consider it a MySQL bug - MySQL/Oracle beg to differ.   I'd say it was a very inconvenient regression 

A simple solution would be to use an earlier version of MySQL and the database would be loaded just fine.


There are workarounds for this particular problem if you insist on using MySQL 5.6.10.1:

See:

http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_large_prefix

There may be other problems that I haven't seen yet.  I haven't tried it out completely yet.

I'd go back to an earlier MySQL if you can (or use Oracle, PostgreSQL, DB2 or MS SQL Server).   Oracle may fix this in a future point release of MySQL at which point you could upgrade and have it working without extra configuratons.

For helping others... please let us know which you decided to do and how you got on !

Thanks.

[ByDcc]

   Hi,
   I had the first problem you show in your post

Specified key was too long; max key length is 767 bytes

but, once I fixed it, I had the problem I wrote in my post

date_added: Incorrect datetime value: ''

   Do you think an older version of mysql fixed that problem?
   Could you tell me a version of mysql where the last version of konakart will work fine?

   Thanks in advance.

[ming]

I'm still trying to get to the bottom of this but I found that the incorrect datetime value problem seemed to be resolved by replacing the mysqljdbc.jar with mysql-connector-java-5.1.23-bin.jar.

However, this (5.6.10.1) new version of MySQL seems to have broken a few things that we weren't able to test before releasing v6.5.0.0 of KonaKart. 

We will look into solutions for this but for now I would encourage you to use an earlier version of MySQL.

When we released 6.5.0.0 we were testing up to v5.5 of MySQL.

[ByDcc]

Thank you very much.

[Brian]

For those who wish to use KonaKart on MySQL 5.6.10.1 there is a new release of KonaKart (v6.5.1.0) that is now available for download that is compatible:

See: http://www.konakart.com/downloads/community_edition