Im looking at the code now - om/dbpsml/JetspeedUserProfilePeer.java, line 158. It would appear that its an easy fix, but the problem is that this same code is in two different cases:
1. public PSMLDocument getDocument(ProfileLocator locator) 2. public Iterator query(QueryLocator locator) In the first case, it would be OK to set the language to NULL, but not in the second. ----- Original Message ----- From: "Emmanuel Bardet" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Thursday, January 10, 2002 1:51 AM Subject: RE: Converting from PSML files to a PSML Database > Gents, > > I know this is a boring thread but hey I guess it references a bug. Shall I > raise it on Bugzilla or dig the source code myself ? > > Rgds, > > Emmanuel. > > > > -----Original Message----- > From: Emmanuel Bardet [mailto:[EMAIL PROTECTED]] > Sent: mercredi 9 janvier 2002 14:01 > To: Jetspeed Users List > Subject: RE: Converting from PSML files to a PSML Database > > > As the French nor the German entries exist in the table, Jetspeed tries to > load an entry regardless of the language. > > SELECT JETSPEED_ANON_PROFILE.PSML_ID, JETSPEED_ANON_PROFILE.MEDIA_TYPE, > JETSPEED_ANON_PROFILE.LANGUAGE, JETSPEED_ANON_PROFILE.COUNTRY, > JETSPEED_ANON_PROFILE.PAGE, JETSPEED_ANON_PROFILE.PROFILE FROM > JETSPEED_ANON_PROFILE WHERE (JETSPEED_ANON_PROFILE.MEDIA_TYPE='html') AND > (JETSPEED_ANON_PROFILE.PAGE='default.psml') > > This returns 3 entries: the default, the English and the Spanish. > > +---------+------------+----------+---------+--------------+- > | PSML_ID | MEDIA_TYPE | LANGUAGE | COUNTRY | PAGE | > +---------+------------+----------+---------+--------------+- > | 120 | html | NULL | NULL | default.psml | PROFILES... > | 121 | html | en | NULL | default.psml | > | 123 | html | es | NULL | default.psml | > +---------+------------+----------+---------+--------------+- > > Jetspeed seems to take the last returned ie the Spanish which is why I get > the tabs in Spanish. Jetspeed should query for the default: > > SELECT JETSPEED_ANON_PROFILE.PSML_ID, JETSPEED_ANON_PROFILE.MEDIA_TYPE, > JETSPEED_ANON_PROFILE.LANGUAGE, JETSPEED_ANON_PROFILE.COUNTRY, > JETSPEED_ANON_PROFILE.PAGE, JETSPEED_ANON_PROFILE.PROFILE FROM > JETSPEED_ANON_PROFILE WHERE (JETSPEED_ANON_PROFILE.MEDIA_TYPE='html') AND > (JETSPEED_ANON_PROFILE.PAGE='default.psml') AND > (JETSPEED_ANON_PROFILE.LANGUAGE IS NULL) > > In order to get: > > +---------+------------+----------+---------+--------------+- > | PSML_ID | MEDIA_TYPE | LANGUAGE | COUNTRY | PAGE | PROFILE > +---------+------------+----------+---------+--------------+- > | 120 | html | NULL | NULL | default.psml | > +---------+------------+----------+---------+--------------+- > > It's really cosmetic and not high priority however I wouldn't mind a fix. In > the meantime, I'll create my local version. > > Thanks for your great efforts. > > Emmanuel. > > > > -----Original Message----- > From: Emmanuel Bardet [mailto:[EMAIL PROTECTED]] > Sent: mercredi 9 janvier 2002 11:29 > To: Jetspeed Users List > Subject: RE: Converting from PSML files to a PSML Database > > > 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]> > > > -- > 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]>
