[Dspace-tech] dspace item import
In the item import command, how does one specify the handle? I don't want the system to generate a new one, I want to use an existing one. Thanks. John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Statistics Question
Hello, We've been experiencing some problems with our statistics for a while now. Here are a few symptoms: 1. General report only shows about 10 weeks of data, keeps cutting off the older stuff 2. Monthly reports follow this pattern, as only the most recent 3 months have data, the rest show all zeros 3. Presently, our general report cuts off at 12/30, no 2008 data 4. Monthly report for 1/2008 is all zeros, with the exception of the 'Archive Information' section The systems administrator who set up this installation, has since moved on, and we're trying to get our stats back on track. Two questions: 1. I notice that in addition to stat-monthly, stat-general, stat- report-monthly & stat-report-general running as a cron each night, stat-initial & stat-report-initial are also running each night. Should these initial jobs be running each night? 2. At this point would it be best to just rebuild statistics as if we were bringing up a new installation? All log data would be preserved, just the reports would be overwritten, correct? Thanks for any advice. ---- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] RSS feeds
Is is possible to configure feeds in Dspace to push out a 'smarter' feed? Such as described here: http://web.resource.org/rss/1.0/modules/dc/ We're interested in being able to see the DC tags in the RSS. Thanks. -------- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] statistics error
Just discovered a new problem with our statistics this morning. https://www.mydspace.org/statistics is returning an error page that I've never seen before. "Internal System Error - The system has experienced an internal error. Please try do what you were doing again, and if the problem persists, please contact us so we can fix the problem." I am able to manually navigate to monthly stat reports, and they look normal. It's just a problem with the "Most recent general report". I've the [dspace]/logs and [dspace]/reports and all necessary files were generated by cron this morning. I also restarted tomcat. Any ideas? -------- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Server upgrade
Hello, We're in the process of purchasing a new server and storage space for our DSpace repository (moving to 1.5). Our systems administrator has proposed the following setup. I'm hoping that some DSpace admins out there may be able to comment on this proposed purchase and let us know if we're going in the right direction. Any feedback would be most helpful. Thanks. Server: Dell PowerEdge 1950 Dual Core Intel® Xeon® 5148LV, 4MB Cache, 2.33GHz, 1333MHz FSB,ES Additional Processors : Dual Core Intel® Xeon® 5148LV, 4MB Cache, 2.33GHz, 1333MHz FSB Memory: 4GB 667MHz (4x1GB), Dual Ranked DIMMs, Energy Smart Primary Hard Driv3: 73GB 15K RPM Serial-Attach SCSI 3Gbps 2.5-in HotPlug Hard Drive Network Adapter: Dual Embedded Broadcom® NetXtreme II 5708 Gigabit Ethernet NIC 2nd Hard Drive: 73GB 15K RPM Serial-Attach SCSI 3Gbps 2.5-in HotPlug Hard Drive Storage: PowerVault MD1000 External Storage Array, SAS and SATA support Hard Drives and Filler Panels: (15) 1TB 7.2K RPM Universal SATA 3Gbps 3.5-in HotPlug Hard Drive -------- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] ERROR: duplicate key violates unique constraint "epersongroup_name_key"
eline.java:564) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:943) at org.apache.catalina.connector.warp.WarpRequestHandler.handle (WarpRequestHandler.java:217) at org.apache.catalina.connector.warp.WarpConnection.run (WarpConnection.java:194) at java.lang.Thread.run(Thread.java:595) ---- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Moving to a new server
We're moving to a new server, and also moving from 1.4.2 to 1.5. What's the best method of moving all the items, item exporter and item importer? ---- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] migrate data to 1.5
We're in the process of upgrading from 1.4.2 to 1.5, and we're also moving to a new server. We've got 1.5 up and running and we're trying to figure out the best way of migrating our data. Is it possible to do a pg_dump from the 1.4.2 server and do a pg_restore on the 1.5 server? Or will 1.5's new db schema prevent this? Thanks for any response, I have not been able to find any documentation for this scenario. ---- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] assetstore across multiple partitions
Is it possible to split up the assetstore directory across multiple partitions? John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] bitstream import on 1.4.2
Hello, Is there a way on 1.4.2 to import a bitstream and add it to an existing record from the command line? Our config file indicates that we should be able to upload items as big as 512 MB, but the UI keeps timing out when we try to add a 135MB bitstream to this record. In the past, we've gotten around this by using the Item Importer, but that was with complete item packages. In this case, I'm just looking to bring in an additional bitstream file. Thanks for any guidance. - John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole, MA 02543 USA PHONE: 508-289-7435 EMAIL: jfur...@mbl.edu http://www.mblwhoilibrary.org -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] help with error
Hi, We're getting an error like this about once a minute. Almost everytime someone does a search. Any ideas? An internal server error occurred on https:// darchive.mblwhoilibrary.org: Date: 1/16/09 10:20 AM Session ID: 9CA25E32A826A66F7F0F0F8D1501237E -- URL Was: https://darchive.mblwhoilibrary.org/simple-search?query=GSC&submit=Go -- Method: GET -- Parameters were: -- submit: "Go" -- query: "GSC" Exception: javax.servlet.ServletException: Servlet execution threw an exception at org .apache .catalina .core .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 269) at org .apache .catalina .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org .apache .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 243) at org .apache .catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 943) at org .apache .catalina.core.StandardContextValve.invoke(StandardContextValve.java: 190) at org .apache .catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org .apache .catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org .apache .catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2347) at org .apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 180) at org .apache .catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org .apache .catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java: 170) at org .apache .catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org .apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 170) at org .apache .catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 943) at org .apache .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org .apache .catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 943) at org .apache .catalina .connector.warp.WarpRequestHandler.handle(WarpRequestHandler.java:217) at org .apache.catalina.connector.warp.WarpConnection.run(WarpConnection.java: 194) at java.lang.Thread.run(Thread.java:595) ----- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole, MA 02543 USA PHONE: 508-289-7435 EMAIL: jfur...@mbl.edu http://www.mblwhoilibrary.org -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Eperson error in 1.5 migration
StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:619) 2009-01-23 10:29:42,569 WARN org.dspace.app.webui.util.UIUtil @ Unable to send email alert javax.mail.NoSuchProviderException: smtp at javax.mail.Session.getService(Session.java:782) at javax.mail.Session.getTransport(Session.java:708) at javax.mail.Session.getTransport(Session.java:651) at javax.mail.Session.getTransport(Session.java:631) at javax.mail.Session.getTransport(Session.java:686) at javax.mail.Transport.send0(Transport.java:166) at javax.mail.Transport.send(Transport.java:98) at org.dspace.core.Email.send(Email.java:362) at org.dspace.app.webui.util.UIUtil.sendAlert(UIUtil.java:480) at org.dspace.app.webui.servlet.InternalErrorServlet.doGet(InternalErrorServlet.java:86) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364) at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:213) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:619) ----- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole, MA 02543 USA PHONE: 508-289-7435 EMAIL: jfur...@mbl.edu http://www.mblwhoilibrary.org -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Eperson error in 1.5 migration
Thank you! Not sure how we missed this, it was very clear in the docs. - John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole, MA 02543 USA PHONE: 508-289-7435 EMAIL: jfur...@mbl.edu http://www.mblwhoilibrary.org - Original Message - From: "Claudia Juergen" To: "John Furfey" Cc: "Dspace Tech" Sent: Friday, January 23, 2009 11:15:17 AM GMT -05:00 US/Canada Eastern Subject: Re: [Dspace-tech] Eperson error in 1.5 migration Hi John, during upgrade, did you run database_schema_14-15.sql as indicated in the docs. This will create the language column in eperson, see alter table eperson add column language VARCHAR(64); update eperson set language = 'en'; Hope that helps Claudia Jürgen > Hello, > > We're in the process of bringing up a new server with 1.5, migrating from > 1.4. One problem we're encountering is that we can't see any of the > epeople in the system. On checking the database, the table exists and > there's data for the epeople, but we can't see them in the jspui. Here are > some errors from dspace.log when trying to perform actions on epeople list > (/dspace-admin/edit-people). > > Any ideas? > > > 2009-01-23 10:29:42,566 ERROR > org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/jspui].[jsp] > @ Servlet.service() for servlet jsp threw exception > java.lang.IllegalArgumentException: No such column language > at org.dspace.storage.rdbms.TableRow.getStringColumn(TableRow.java:247) > at org.dspace.eperson.EPerson.getLanguage(EPerson.java:509) > at > org.apache.jsp.tools.eperson_002dlist_jsp._jspService(eperson_002dlist_jsp.java:643) > > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328) > > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > > at > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) > > at > org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469) > > at > org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403) > > at > org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) > > at org.dspace.app.webui.util.JSPManager.showJSP(JSPManager.java:91) > at > org.dspace.app.webui.servlet.admin.EPersonListServlet.doDSGet(EPersonListServlet.java:138) > > at > org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151) > > at org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:99) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > > at > org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) > > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:5
[Dspace-tech] rolling back a patch: database_schema_13-14.sql
I erred in applying the above patch to a 1.4 system, and the results are that now there are duplicate metadata fields for each item view. Example: Issue Date: Oct-2007 Oct-2007 Abstract: Conference presentations from IAMSLIC Conference and SAIL Meeting held October 7-11 2007 in Sarasota, Florida, USA. Conference presentations from IAMSLIC Conference and SAIL Meeting held October 7-11 2007 in Sarasota, Florida, USA. Is there an easy way to rollback a patch, or is it better to restore the db from a backup? Thanks. - John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole, MA 02543 USA PHONE: 508-289-7435 EMAIL: jfur...@mbl.edu http://www.mblwhoilibrary.org -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] rolling back a patch: database_schema_13-14.sql
Thanks. Recovered from backup. - John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole, MA 02543 USA PHONE: 508-289-7435 EMAIL: jfur...@mbl.edu http://www.mblwhoilibrary.org - Original Message - From: "Mark Diggory" To: "Dorothea Salo" Cc: "Dspace Tech" Sent: Friday, January 23, 2009 3:37:11 PM GMT -05:00 US/Canada Eastern Subject: Re: [Dspace-tech] rolling back a patch: database_schema_13-14.sql I tend to agree with Dorothea on this one. I suspect it will be difficult to roll back all the changes unless someone out there knows how to magically unto completed transactions. If you can restore from backup that would possibly be the safest decision. Otherwise, reviewing the file, I see the following changes That I suspect would duplicate table rows... -- Migrate the existing DCTypes into the new metadata field registry INSERT INTO MetadataFieldRegistry (metadata_schema_id, metadata_field_id, element, qualifier, scope_note) SELECT '1' AS metadata_schema_id, dc_type_id, element, qualifier, scope_note FROM dctyperegistry; -- Copy the DCValues into the new MetadataValue table INSERT INTO MetadataValue (item_id, metadata_field_id, text_value, text_lang, place) SELECT item_id, dc_type_id, text_value, text_lang, place FROM dcvalue; These will duplicate rows in the MetadataFieldRegistry and duplicate copy DCValues into the MetadataValueTable. I assume that is where your duplication is occurring. I might also be concerned about your bistream sizes now with the following update: ALTER TABLE bitstream ADD COLUMN size_bytes BIGINT; UPDATE bitstream SET size_bytes = size; ALTER TABLE bitstream DROP COLUMN size; Finally, I think if your using the ChecksumChecker, you might encounter issues with duplicates in your checker tables caused by many inserts into them as well. If you haven't had any changes you need to maintain today, I would try to recovre from a db backup instead of having to do surgery. Mark On Fri, Jan 23, 2009 at 12:21 PM, Dorothea Salo wrote: > On Fri, Jan 23, 2009 at 1:34 PM, John Furfey wrote: >> I erred in applying the above patch to a 1.4 system, and the results are >> that now there are duplicate metadata fields for each item view. Example: > >> Is there an easy way to rollback a patch, or is it better to restore the db >> from a backup? > > Oh, man, I've done that. (Only on a test install, fortunately.) If > there's an easy fix, I don't know what it is; I'd say restore from > backup. > > Dorothea > > -- > Dorothea Salo ds...@library.wisc.edu > Digital Repository Librarian AIM: mindsatuw > University of Wisconsin > Rm 218, Memorial Library > (608) 262-5493 > > -- > > This SF.net email is sponsored by: > SourcForge Community > SourceForge wants to tell your story. > http://p.sf.net/sfu/sf-spreadtheword > ___ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > -- ~ Mark R. Diggory Home Page: http://purl.org/net/mdiggory/homepage Skype ID: mdiggory -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] WHIP Announcement web page 2009
Judi, I can update this page, but I'm unfamiliar with WHIP. Do you have the link to the registration site? I'm assuming that you want the 'not open yet' message replaced with a link to register. --------- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole, MA 02543 USA PHONE: 508-289-7435 EMAIL: jfur...@mbl.edu http://www.mblwhoilibrary.org - Original Message - From: "David Space" To: "David Gallagher" , ",\"John Furfey" Sent: Friday, February 13, 2009 9:28:35 AM GMT -05:00 US/Canada Eastern Subject: Fwd: WHIP Announcement web page 2009 - Forwarded Message - From: "Judith Taylor" To: "David Space" Sent: Friday, February 13, 2009 9:25:20 AM GMT -05:00 US/Canada Eastern Subject: FW: WHIP Announcement web page 2009 Hi Dave, Noticed this morning the WHIP announcement page still states "registration not yet open"top right hand corner. Sent email to Chris to please updatebut see he is now on vacation. Can you or someone in IT handle? Don't want to put off another week. Thanks! Judi -Original Message- From: Christopher Dematos [mailto:cdema...@mbl.edu] Sent: Friday, February 13, 2009 9:20 AM To: jtay...@mbl.edu Subject: Re: WHIP Announcement web page 2009 I will be away on vacation from Friday Feb 12th, returning on Wednesday Feb 18th and will have limited access to email. Please forward any requests to helpd...@mbl.edu. Thanks, Chris Dematos -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Importing Items
Hello all, We're just beginning to investigate the importing functionality of dspace and I can't seem to find any good documentation. I'm assuming that I'll need to give dspace some sort of xml document containing the metadata, and the item itself. What's the best way of getting started, any good resources out there? Thanks, John -- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] mapfile
We've just begun to experiment with the itemimporter and I'm wondering what the 'mapfile' is. I'm brand new to dspace. -- John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: [EMAIL PROTECTED] http://www.mblwhoilibrary.org - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech