Hi Allen,
Thanks for all the help. I implemented your logic and fixed the issue.
I wrote a java program to first execute the query
myquery=select distinct
m1.metadata_value_id,m2.metadata_value_id,m1.item_id,m2.item_id from
metadatavalue m1, metadatavalue m2 where m1.item_id=m2.item_id and
Hi Koushik,
I usually like to separate queries of inspecting data from queries of
deleting data, for the sake of playing safe.
Try this.
select distinct *
from metadatavalue m1, metadatavalue m2
where m1.item_id=m2.item_id
and m1.metadata_field_id=m2.metadata_field_id
and
Hello Allen,
Thanks a lot for the guide. Here is what further investigation has unearthed
-
1 This duplicate metadata issue doesn't occur with new submissions. For
this installation, the DB was copied from an earlier version. It is only
with these old items that the duplicate metadata entries show
Probably this sql command will do the job -
delete from metadatavalue where metadata_value_id not in (select
min(metadata_value_id) from metadatavalue T2 where
T2.item_id=metadatavalue.item_id AND
T2.metadata_field_id=metadatavalue.metadata_field_id AND
T2.text_value=metadatavalue.text_value);
The same thing happens in both JSPUI and XMLUI. I guess that means the
problem is not at the UI layer but something deeper. The Browse or Handle
servlets?
This dual-display happens while viewing a particular item i.e. url like
[host]/[dspace or xmlui]/handle/number1/number2
also the author names
Hi Koushik,
First try to make sure there is no duplication in the database.
Go into the Edit item page to check.
If the problem is not with the db, it may be caused by incorrect indexing.
There could be some errors in your config file. Without extra
information it is only a wild guess.
But
Thanks Allen.
I checked the edit item page. That also has duplicate entries i.e. two
dc.contributor.author, two dc.date.issued fields etc which can be edited.
Does it mean that the database itself is wrong? In that case, how do I get
rid of this problem?
Thanks
On Thu, Jul 29, 2010 at 1:30 PM,
Hi Koushik,
The immediate task is to find out why there are duplicate entries in the
db, and stop creating duplication again.
I don't know your installation or customization history, so this is a
wild guess again. There could be some errors made in your item
submission form. Check the item
8 matches
Mail list logo
