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 > -- The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336. ------------------------------------------------------------------------------ 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

