Thanks David.
It works fine except that I did not expect anonymous users to have their tabs in Spanish (i.e. Página de Inicio, RSS, Dinámicos) if the language is either French or German. Can anybody help ? Thanks. Emmanuel -----Original Message----- From: David Sean Taylor [mailto:[EMAIL PROTECTED]] Sent: mardi 8 janvier 2002 23:04 To: Jetspeed Users List Subject: Re: Converting from PSML files to a PSML Database INSERT INTO ID_TABLE VALUES(8,'JETSPEED_USER_PROFILE',120,10); INSERT INTO ID_TABLE VALUES(9,'JETSPEED_GROUP_PROFILE',120,10); INSERT INTO ID_TABLE VALUES(10,'JETSPEED_ROLE_PROFILE',120,10); INSERT INTO ID_TABLE VALUES(11,'JETSPEED_ANON_PROFILE',120,10); looks like I did this for Hypersonic, but not the other databases, sorry bout that, I'll try to update the cvs tonight ----- Original Message ----- From: "Emmanuel Bardet" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Tuesday, January 08, 2002 2:41 PM Subject: Converting from PSML files to a PSML Database > Hi all, > > Well guessed! I was not lucky on this one. From jetspeed.log file, I can see > the PSMLImporter starting, then loading > ${webappRoot}\WEB-INF\psml\anon\html\default.psml (just a sec the "but" is > coming) but from this point Oops... > > [Tue Jan 08 22:02:50 GMT 2002] -- INFO -- Forced id retrieval - no available > vector > [Tue Jan 08 22:02:50 GMT 2002] -- DEBUG -- BasePeer.doUpdate: > whereClause=TABLE_NAME='JETSPEED_ANON_PROFILE' > [Tue Jan 08 22:02:50 GMT 2002] -- ERROR -- Error saving > profile:BaseProfile[:{},null,null,anon,html,null,null,default.psml] > [Tue Jan 08 22:02:50 GMT 2002] -- ERROR -- Error occurred in Database PSML > Manager: > Exception: org.apache.turbine.util.TurbineException: The table > JETSPEED_ANON_PROFILE does not have a proper entry in the ID_TABLE > Stack Trace follows: > org.apache.turbine.util.TurbineException: The table JETSPEED_ANON_PROFILE > does not have a proper entry in the ID_TABLE > at org.apache.turbine.util.db.IDBroker.selectRow(IDBroker.java:723) > at org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:571) > at org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:380) > at org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker.java:294) > at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:776) > at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:687) > at > org.apache.jetspeed.om.dbpsml.BaseJetspeedAnonProfilePeer.doInsert(BaseJetsp > eedAnonProfilePeer.java:111) > at > org.apache.jetspeed.om.dbpsml.BaseJetspeedAnonProfilePeer.doInsert(BaseJetsp > eedAnonProfilePeer.java:317) > at > org.apache.jetspeed.om.dbpsml.JetspeedAnonProfilePeer.doInsertOrUpdate(Jetsp > eedAnonProfilePeer.java:76) > at > org.apache.jetspeed.om.dbpsml.JetspeedAnonProfilePeer.insert(JetspeedAnonPro > filePeer.java:49) > at > org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat > eOrSaveDocument(DatabasePsmlManagerService.java:580) > at > org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat > eDocument(DatabasePsmlManagerService.java:504) > at > org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService.export(Cas > torPsmlManagerService.java:1145) > at > org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImporter.java: > 116) > > Well, Turbine is right there is no entry for this table in ID_TABLE ie > > +-------------+-------------------------+---------+----------+ > | ID_TABLE_ID | TABLE_NAME | NEXT_ID | QUANTITY | > +-------------+-------------------------+---------+----------+ > | 1 | TURBINE_PERMISSION | 100 | 10 | > | 2 | TURBINE_ROLE | 120 | 10 | > | 3 | TURBINE_GROUP | 100 | 10 | > | 4 | TURBINE_USER | 140 | 10 | > | 5 | TURBINE_SCHEDULED_JOB | 100 | 10 | > | 6 | TURBINE_ROLE_PERMISSION | 100 | 10 | > | 7 | TURBINE_USER_GROUP_ROLE | 100 | 10 | > +-------------+-------------------------+---------+----------+ > > Would you be kind enough to send me the INSERT statements ? > > Info: Jetspeed 1.3a2, MySQL, W2K > > By the way, you Jetspeed people are tremendous. > > Thanks a lot. > > Emmanuel. > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>