Thank you Danny, but this seems to confirm it is a bug rather than a problem in setting up the proper configuration before buidling with Maven etc. I would like to be sure I did not make any error in setting properties before modifying code. Are developers aware of this "presumed" bug for J1.5?
Bye Stefano ----- Original Message ----- From: "Danny Gehl" <[EMAIL PROTECTED]> To: "'Jetspeed Users List'" <jetspeed-user@jakarta.apache.org> Sent: Thursday, March 31, 2005 10:56 AM Subject: AW: Problem with MySQL 4.1 and Jetpeed 1.5 (1.4-B4) > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
