The Problem is, that some 'null' or 'Date(0)' values are written to DB, which causes the DB to fill in defaults (and default is '000-00-00 00:00:00'). We fixed it by patching the Classes CreateNewUserAndConfirmAction as well as UpdateUserAction. There we added or changed the following:
user.setCreateDate(now); user.setLastLogin(now); user.setPasswordChanged(now); That should do it for 1.5 version. Hope this helps. Danny > -----Ursprüngliche Nachricht----- > Von: Stefano Bianchi [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 30. März 2005 13:22 > An: Jetspeed Users List > Betreff: Re: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4) > > > Dear Danny, > we had the same problem. > We tried to generate again all the scripts but they do not work. > Could it be a problem with MySQL version (we use 4.1.9)? > Until this is not solved we can not let users to create a new account. > I already posted this but I did not find any solution yet. > It would be great if someone with a working version of MySQL > scripts for > J1.5 could help us by posting them! > > I will post a solution as soon as I find it. > Good luck > Stefano > > ----- Original Message ----- > From: "Danny Gehl" <[EMAIL PROTECTED]> > To: "Jetspeed User Mailing List (E-Mail)" > <jetspeed-user@jakarta.apache.org> > Sent: Tuesday, March 29, 2005 2:40 PM > Subject: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4) > > > > 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.do > SelectVillageR > > ecords(BaseTurbineUserPeer.java:416) > > at > > > org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.do > SelectVillageR > > ecords(BaseTurbineUserPeer.java:384) > > at > > > org.apache.jetspeed.om.security.turbine.TurbineUserPeer.doSele > ctUsers(Turbin > > eUserPeer.java:70) > > at > > > org.apache.jetspeed.services.security.turbine.TurbineUserManag > ement.getUsers > > (TurbineUserManagement.java:186) > > at > > > org.apache.jetspeed.services.JetspeedUserManagement.getUsers(J > etspeedUserMan > > agement.java:68) > > at > > > org.apache.jetspeed.services.JetspeedSecurity.getUsers(Jetspee > dSecurity.java > > :195) > > at > > > org.apache.jetspeed.modules.actions.portlets.security.UserBrow > serAction.buil > > dNormalContext(UserBrowserAction.java:129) > > at > > > org.apache.jetspeed.modules.actions.portlets.VelocityPortletAc > tion.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.buildCon > tent(GenericMV > > CPortlet.java:276) > > at > > > org.apache.jetspeed.portal.portlets.GenericMVCPortlet.getConte > nt(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 > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
