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.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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
