Hello Andy, seems as if you did not run [dspace]/bin/index-init. This is part of the new installation (or change of browse configuration).
Hope that helps Claudia Jürgen Am 22.07.2010 14:25, schrieb Speagle, Andy: > Hi All, > > I've just completed an upgrade from 1.4.2 to 1.5.0 per the documentation and > I'm running into a SQL error. It seems that I'm missing a > table/index/column. Here's the relevant error in my dspace.log: > > 2010-07-22 06:54:15,427 ERROR org.dspace.browse.BrowseDAOPostgres @ caught > exception: > org.postgresql.util.PSQLException: ERROR: column "sort_3" does not exist > > 2010-07-22 06:54:15,430 ERROR org.dspace.app.xmlui.cocoon.DSpaceFeedGenerator > @ Caught BrowseException > org.dspace.browse.BrowseException: problem with query: SELECT bi_item.* FROM > bi_item, (SELECT collection2item.item_id FROM collection2item WHERE colle > ction2item.collection_id=? ) mappings WHERE > bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ? > > Can someone point me at what I can look for? I ran the schema update script > and I didn't notice any errors out of that... > > Thanks, > > Andy Speagle > System& Storage Administrator > UCATS - Wichita State University > > P: 316.978.3869 > C: 316.617.2431 > > > > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > > > > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Mit freundlichen Gruessen Claudia Juergen Universitaetsbibliothek Dortmund Eldorado 0231/755-4043 https://eldorado.tu-dortmund.de/ ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
