Andrea Bollini <a.bollini@...> writes: > > > Hi Mary, > it looks like you have an incomplete database. > Are you trying to upgrade a previous installation or it is a fresh > one? > take a look to this filehttps://github.com/Cineca/DSpace/blob/dspace-cris- master/dspace/etc/postgres/addon-crismodule.sql > or if you use oraclehttps://github.com/Cineca/DSpace/blob/dspace-cris- master/dspace/etc/oracle/addon-crismodule.sql > on line 79 you have the rpage table definition with the sourceref > column. > If you are updating an existent dspace-cris installation be sure > to runhttps://github.com/Cineca/DSpace/blob/dspace-cris- master/dspace/etc/postgres/update-crismodule_321_to_4.sql > (see line 12 for reference) > Hope this help, > Andrea > Il 25/09/2014 08.03, Mary Choi ha scritto: > > > <!-- > .hmmessage P > { > margin:0px; > padding:0px > } > body.hmmessage > { > font-size: 12pt; > font-family:Calibri > } > --> > > Hi all, > > > I > have just installed DSpace-CRIS Installation > (Development for 4.x.x) and > discovered that there is a problem with the account > registration and login. It could validate the accounts so > there should be no problem with the database connection. > After checking the logs, I found out that the problem was > the column researcher0_.sourceref does not exist but I had > no idea on how to solve this problem. Any ideas? Thank > you for your help. > > Here are > the messages shown in dspace.log: > > 2014-09-25 12:02:13,799 INFO > org.dspace.authenticate.PasswordAuthentication <at> > anonymous:session_id=80CE880BB2219B91D5669975E7DFBFA2:ip_addr=175.159.73 .163:authenticate:attempting > password auth of user=email- [email protected] > 2014-09-25 12:02:13,814 WARN > org.hibernate.engine.jdbc.spi.SqlExceptionHelper <at> SQL > Error: 0, SQLState: 42703 > 2014-09-25 12:02:13,814 ERROR > org.hibernate.engine.jdbc.spi.SqlExceptionHelper <at> > ERROR: column researcher0_.sourceref does not exist > Position: 103 > > > Best Regards, > > Mary > > > > ---------------------------------------------------------------- -------------- > Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer > Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports > Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper > Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer > http://pubads.g.doubleclick.net/gampad/clk? id=154622311&iu=/4140/ostg.clktrk > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > > -- > Andrea Bollini > Soluzioni per la Ricerca Istituzionale > Cineca > > Via dei Tizii, 6 > 00185 Roma, Italy > tel. +39 06 44 486 087 - mob. +39 348 82 77 525 > http://www.cineca.it > > > ---------------------------------------------------------------------- -------- > Slashdot TV. Videos for Nerds. Stuff that Matters. > http://pubads.g.doubleclick.net/gampad/clk? id=160591471&iu=/4140/ostg.clktrk > > ---------------------------------------------------------------------- -------- > Slashdot TV. Videos for Nerds. Stuff that Matters. > http://pubads.g.doubleclick.net/gampad/clk? id=160591471&iu=/4140/ostg.clktrk
The actual situation was actually quite messy. I was gonna install a dspace cris instance on a server with an existing dspace 3 instance but problems aroused and I'm facing this problem at the moment. I just gave it a shot and the problem is solved. Thank you very much Andrea! Do you mind if I post the solution to other websites where I issued the same question? ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
