Re: [Dspace-tech] Author sorting

2008-08-06 Thread Kasthuri, Sriram
I feel the problem is not with the postgres version. If you look into org.dspace.browse.BrowseItem.java you can see the below SQL's holding the values for browse display and you can notice the query is not ordered by the text_value. We have our dspace running on 1.4.2 and I'm not sure whether

Re: [Dspace-tech] Author sorting

2008-08-06 Thread Mark H. Wood
Well, it does indeed seem that this is not dependent on the PostgreSQL version, because I see the same incorrect behavior out of version 8.3.3. The immediate problem is not the lack of ORDER BY; the immediate problem is that ORDER BY does not seem to work for these data. I tried the same

Re: [Dspace-tech] Author sorting

2008-08-06 Thread Kasthuri, Sriram
We are using postgresql v 7.3 and it worked fine with ORDER BY text_value. But not sure whether anything got changed in the later versions of postgre? - Sri -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark H. Wood Sent: 06 August 2008 14:26 To:

[Dspace-tech] pstgresql password question

2008-08-06 Thread Kieffer, Paul
I tried the following process after generating the dspace package... [EMAIL PROTECTED] dspace-1.5.0-build.dir]$ ant fresh_install Buildfile: build.xml init_installation: BUILD FAILED /ds/dspace-1.5.0-release/dspace/target/dspace-1.5.0-build.dir/build.xml:325: Directory /dspace/bin creation was

Re: [Dspace-tech] pstgresql password question

2008-08-06 Thread Mark H. Wood
On Wed, Aug 06, 2008 at 10:10:31AM -0400, Kieffer, Paul wrote: [EMAIL PROTECTED] dspace-1.5.0-build.dir]$ psql -U dspace -W -h localhost Password for user dspace: psql: FATAL: Ident authentication failed for user dspace It appears that PostgreSQL is set up to use Ident authentication when a

Re: [Dspace-tech] Problems with stat-initial and stat-monthly

2008-08-06 Thread Stuart Lewis
Hi Sean, Anybody have any idea what I've done wrong here? I get the following error when I try to run stat-initial or stat-monthy: [EMAIL PROTECTED]:/dspace$ bin/stat-initial Exception in thread main org.postgresql.util.PSQLException: ERROR: syntax error at or near FROM This is on a 1.5

[Dspace-tech] [EMAIL PROTECTED] upgrades to DSpace 1.5.x

2008-08-06 Thread Mark Diggory
Dear DSpace Community, Earlier this week we completed the upgrade of [EMAIL PROTECTED] from DSpace 1.4.1 (JSPUI) to the latest DSpace 1.5.x revision. Likewise, we switched over completely to use the Texas AM Manakin based XMLUI during this upgrade process. The service can now be explored

Re: [Dspace-tech] Author sorting

2008-08-06 Thread Blanco, Jose
When I was on version 7.3.15 of postgres I tested the order by just as I described in my original email, and it gave me the undesired results. There must be some sort of setting to make this work. I have seen sites where it works just fine. -Jose -Original Message- From: [EMAIL