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 file
https://github.com/Cineca/DSpace/blob/dspace-cris-master/dspace/etc/postgres/addon-crismodule.sql
or if you use oracle
https://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 run
https://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:
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 @ anonymous:session_id=80CE880BB2219B91D5669975E7DFBFA2:ip_addr=175.159.73.163:authenticate:attempting password auth of user=em...@xxx.com 2014-09-25 12:02:13,814 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42703 2014-09-25 12:02:13,814 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ 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
DSpace-tech@lists.sourceforge.net
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
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Reply via email to