Hello, we have encountered a serious problem while updating our MySQL DB server to version 4.1. When a new User is created, the fields CREATED and PASSWORD_CHANGED in the TURBINE_USER table are set to '0000-00-00 00:00:00'. When Jetspeed attempts to read this user later, the following exeption is thrown:
============================================================================ ================= java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 9 to TIMESTAMP. at com.workingdogs.village.DataSet.fetchRecords(Unknown Source) at com.workingdogs.village.DataSet.fetchRecords(Unknown Source) at com.workingdogs.village.DataSet.fetchRecords(Unknown Source) at org.apache.torque.util.BasePeer.getSelectResults(BasePeer.java:1657) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1545) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1391) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1368) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doSelectVillageR ecords(BaseTurbineUserPeer.java:416) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doSelectVillageR ecords(BaseTurbineUserPeer.java:384) at org.apache.jetspeed.om.security.turbine.TurbineUserPeer.doSelectUsers(Turbin eUserPeer.java:70) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUsers (TurbineUserManagement.java:186) at org.apache.jetspeed.services.JetspeedUserManagement.getUsers(JetspeedUserMan agement.java:68) at org.apache.jetspeed.services.JetspeedSecurity.getUsers(JetspeedSecurity.java :195) at org.apache.jetspeed.modules.actions.portlets.security.UserBrowserAction.buil dNormalContext(UserBrowserAction.java:129) at org.apache.jetspeed.modules.actions.portlets.VelocityPortletAction.buildNorm alContext(VelocityPortletAction.java:74) at org.apache.jetspeed.modules.actions.portlets.GenericMVCAction.doPerform(Gene ricMVCAction.java:169) at org.apache.jetspeed.modules.actions.portlets.GenericMVCAction.perform(Generi cMVCAction.java:76) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.jetspeed.portal.portlets.GenericMVCPortlet.buildContent(GenericMV CPortlet.java:276) at org.apache.jetspeed.portal.portlets.GenericMVCPortlet.getContent(GenericMVCP ortlet.java:207) ============================================================================ ================== I've searched the list and found several hints, but none of them seem to work. The first thing I tried was updating to jetspeed version 1.5 (from 1.4b4), but the problem stays. I recompiled everything for MySQL, but no effect. If anyone could help me on this, that would be great. Sincerely, Danny Gehl ========================================== T-Systems Multimedia Solutions GmbH Danny Gehl Authorized Java Center (AJC) Hausanschrift: Riesaer Straße 5, 01029 Dresden Tel.: (0351) 8505 845 Fax.: (in Arbeit) E-Mail: mailto:[EMAIL PROTECTED] http://www.T-Systems-MMS.com
