I turned debug on for dspace code. This is what gets written to dspace.log. Below is an sql query showing the user is in eperson.
2010-10-11 11:32:30,051 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "select * from EPERSON where email = ? " with parameters:[email protected] SQL> select * from eperson where email = '[email protected]'; EPERSON_ID EMAIL ---------- ---------------------------------------------------------------- PASSWORD ---------------------------------------------------------------- FIRSTNAME ---------------------------------------------------------------- LASTNAME CAN_LOG_IN ---------------------------------------------------------------- ---------- REQUIRE_CERTIFICATE SELF_REGISTERED ------------------- --------------- LAST_ACTIVE --------------------------------------------------------------------------- SUB_FREQUENCY PHONE ------------- -------------------------------- NETID ---------------------------------------------------------------- LANGUAGE ---------------------------------------------------------------- [email protected] 1f91fd370a52b828da2b85b863e17c70 dspace dspace 1 0 0 en SQL> Marvin On 10/11/2010 10:26 AM, TAYLOR Robin wrote: > Hi Marvin, > > Is it practical to set debugging on in the logs ? Is could you do so and then > look to see what the actual query is in dspace.log, you should see something > like "Running query ... with parameters: ...". > > Cheers, Robin. > > > Robin Taylor > Main Library > University of Edinburgh > Tel. 0131 6513808 > >> -----Original Message----- >> From: Marvin Weaver [mailto:[email protected]] >> Sent: 11 October 2010 14:20 >> To: [email protected] >> Subject: Re: [Dspace-tech] eperson column and 1.6.2 importer >> >> Not really. I had had my script working on 1.5.2 with no >> errors. The user [email protected] is able to manually go >> through the add item workflow steps successfully, it's just >> when I run the batch import script that I get the error and I >> don't know what is missing. I've also write permissions in >> all the administrator groups. The error again is: >> /dspace/bin/import -a -e [email protected] -c 123456789/62 -s >> /dspace/import/cit_100-1065 -m /dspace/mapfiles/cit_100-1065 >> >>> Exception: No such column EPERSON_ID >>> java.lang.IllegalArgumentException: No such column EPERSON_ID >>> at >> org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:509) >>> at >> org.dspace.storage.rdbms.DatabaseManager.process(DatabaseManag >> er.java:1182) >>> at >> org.dspace.storage.rdbms.TableRowIterator.next(TableRowIterato >> r.java:151) >>> at >> org.dspace.storage.rdbms.DatabaseManager.querySingleTable(Data >> baseManager.java:410) >>> at >> org.dspace.storage.rdbms.DatabaseManager.findByUnique(Database >> Manager.java:550) >>> at >> org.dspace.eperson.EPerson.findByEmail(EPerson.java:161) >>> at >> org.dspace.app.itemimport.ItemImport.main(ItemImport.java:381) >>> at >> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess >> orImpl.java:39) >>> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth >> odAccessorImpl.java:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212) >>> >>> I created an administer group for each collection and >> [email protected] >>> as a member to each. >>> I went to Administer Authorization Policies and granted >> add to every >>> administrator group, anonymous, and administrator. >> Marvin >> >> >> >> On 10/8/2010 5:44 PM, [email protected] wrote: >>> Hi Marvin >>> >>> Did the wiki page link help ? >>> >>> Cheers >>> >>> hg >>> >>> On 08/10/2010 20:48, Marvin Weaver wrote: >>>>> There is, and always was. I pasted it into the email >> to the list and the space got lost. >>>>> Originally, the email address had turned into a >> hyperlink in my mail box. Sorry. >>>>> /dspace/bin/import -a [email protected] -c >> 123456789/62 -s /dspace/import/cit_100-1065 -m >> /dspace/mapfiles/cit_100-1065 >>>>> Marvin >> >> -------------------------------------------------------------- >> ---------------- >> Beautiful is writing same markup. Internet Explorer 9 >> supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, >> and DOM L2& L3. >> Spend less time writing and rewriting code and more time >> creating great experiences on the web. Be a part of the beta today. >> http://p.sf.net/sfu/beautyoftheweb >> _______________________________________________ >> DSpace-tech mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/dspace-tech >> ------------------------------------------------------------------------------ Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
