Hi Stuart :) I've already run the index-init script several times.
Here is an item in our restored 1.5.2 production server: http://vle.bromley.ac.uk/dspace/handle/2045/22 and here is the same item in our 1.6.2 test server: http://standbyvle.bromley.ac.uk/dspace/handle/2045/22 You can clearly see the difference in the issue date display format. Do you know "off hand" the postgres commands l need to use to view the tables or is it better I reinstall phpPgAdmin? Thanks very much Clive On Sat, Aug 7, 2010 at 9:32 AM, Stuart Lewis <s.le...@auckland.ac.nz> wrote: > Hi Clive / Rajshekhar, > >> I notice that with DSpace 1.5.2 on our server the strange codes were >> already there before the database upgrade: >> >> dc date accessioned 2009-04-29T05:57:26Z >> dc date available 2009-04-29T05:57:26Z >> dc date issued 2009-04-29T05:57:26Z > > These dates are completely normal. See: > http://en.wikipedia.org/wiki/ISO_8601#UTC > > Basically it is a way of describing date / time fields in a timezone neutral > way. > > year-month-day T (to denote the start of the Time part) hour:minute:second Z > (zulu time) > > Therefore the contents of your database appear to be fine. When you view an > item, are the dates correct in there - is it just the browse screens that > appear wrong? > > Since upgrading, have you re-indexed your browse tables? Step 10 of the > upgrade instructions > (http://www.dspace.org/1_6_2Documentation/ch04.html#N10FE6) says to run: > > - [dspace]/bin/dspace index-init > > You could look in your browse index tables bi_* and see what values they are > holding. Are they holding the expected dates in the format you would expect? > > Thanks, > > > Stuart Lewis > IT Innovations Analyst and Developer > Te Tumu Herenga The University of Auckland Library > Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand > Ph: +64 (0)9 373 7599 x81928 > > ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech