Hi Stuart and all, I asked the community administrator of this repository and he's positive that each item have only one title. I now know the reason for the discrepancy in the figures when he showed me one problematic item. It turned out that this particular item have two assigned handles. The figures in the community list (or strengths) seemed to compute this from the number of handles. Is it safe to delete the (duplicate) row in the handle table? And how can I locate duplicate entries (one item ID, multiple handle_id)? Another question I would like to ask is that why this happened in the first place and how to avoid this problem? I thought the assignment of handles incrementally upon submission would avoid this.
Thanks in advance and best regards, euler On Thursday, November 12, 2015 at 9:48:52 AM UTC+8, Stuart Yeates wrote: > > (a) try rebuilding the solr indexes to ensure they're up-to-date > > (b) does every item have one and exactly one title? > > cheers > stuart > > -- > ...let us be heard from red core to black sky > > On Thu, Nov 12, 2015 at 2:46 PM, euler <esn...@seafdec.org.ph > <javascript:>> wrote: > >> Dear All, >> >> I am reposting my query from October since I did not received any >> response from the list. Hope someone can help me to figure out how to >> reconcile the figures in the browse by titles and in the strengths >> displayed. >> >> Thanks in advance and best regards, >> euler >> >> On Thursday, October 8, 2015 at 8:58:13 PM UTC+8, euler wrote: >>> >>> Dear All, >>> >>> This is somewhat related to George's post: Question about Totals of >>> Items >>> <http://dspace.2283337.n4.nabble.com/Question-about-Totals-of-Items-tp4678795.html> >>> from >>> a few days ago. I am wondering why the figures being displayed in the >>> community-list is not the same from the number of items in the browse by >>> titles? I suppose the figures from the community-list comes from querying >>> SOLR? The repository manager told me that in this repository, there were no >>> restricted items (so restricted items are out of the question). I tried >>> querying SOLR based from this page: >>> https://wiki.duraspace.org/display/DSPACE/Solr#Solr-Numberofitemsinaspecificcommunity >>> and >>> the results are equal to the figures in the browse by titles. >>> >>> Here's the community-list link of the repository: >>> http://iris.wpro.who.int/community-list and here's the link of the >>> browse by title: >>> http://iris.wpro.who.int/handle/10665.1/9971/browse?type=title >>> >>> As I write this, there are 6,231 titles in the browse by titles but >>> there are 6,316 items being displayed in the community-list. >>> >>> Please help where should I look and how to fix the discrepancy in the >>> figures. >>> >>> Thanks in advance, >>> euler >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "DSpace Technical Support" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to dspace-tech...@googlegroups.com <javascript:>. >> To post to this group, send email to dspac...@googlegroups.com >> <javascript:>. >> Visit this group at http://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at http://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
