eprints_tech messages

Thanks John, that's very helpful,

I'm looking at the web interface (Eprints 3.0.5 on Ubuntu) now to edit
these items with subjects that have been removed - the subjects are
not shown, leaving me able to apply the new subjects. Obviously the
old subjects are still referred to in the database, leaving me with
entries such as:

http://library.thehumanjourney.net/86/

With the ?subjects?

Editing the database is one option, but could the web interface be
changed to allow me to fix broken things like this? I don't know the
workings of these things, but I imagine the webinterface is used to
write to a file based representation of the entry and not the db?

Thanks again, Joseph

On 26 February 2010 16:05, John Salter <J.Salter AT leeds.ac.uk> wrote:
> Joseph,
> I did something like this on the database recently (after some imported ↵
eprints had mangled subject id's):
> In our archive we have a subject field called 'iau' - replace this with ↵
whatever the mangled subject field is called!
>
> Get eprint ID's and bad subject codes:
> mysql> SELECT eprintid, iau FROM eprint_iau WHERE iau NOT IN (SELECT ↵
subjectid FROM subject) ORDER BY eprintid;
>
> Get titles/status' of items with bad subject codes:
> mysql> SELECT eprintid, eprint_status, title FROM eprint WHERE eprintid ↵
IN (SELECT eprintid FROM eprint_iau WHERE iau NOT IN (SELECT subjectid FROM ↵
subject)) ORDER BY eprintid;
>
> This will give you a list of eprints where the subject code assigned to it ↵
has no entry in the subject tree.
> You can then either:
> 1) Add subjects as necessary
> 2) Update eprint_subject as necessary.
>
> I was going to post this sometime soon as a 'One-liner' short ↵
database/perl hacks to test things in EPRints.
> Does anyone else have anything they've worked out that might be useful to ↵
share?
>
> Cheers,
> John
>
>
>
> -----Original Message-----
> From: eprints-tech-bounces AT ecs.soton.ac.uk [mailto:eprints-tech-bounces ↵
AT ecs.soton.ac.uk] On Behalf Of Joseph Reeves
> Sent: 26 February 2010 13:58
> To: eprints-tech AT ecs.soton.ac.uk
> Subject: [EP-tech] Re: Changed my subjects list - now I have a problem ↵
with old items...
>
> Thanks Ranju,
>
> I've just gone through the same process and the mention of the old ↵
subjects still remain:
>
> http://library.thehumanjourney.net/86/
>
> I've since restarted Apache as well, but this did not solve the problem ↵
either.
>
> Thanks again, Joseph
>
>
>
>
> On 26 February 2010 13:41, Ranju Upadhyay <Ranju.Upadhyay AT ↵
nuim.ie> wrote:
>> Hi Joseph,
>>
>> We also changed our subject files recently and doing, import_subject
>> generate_views and generate_abstract
>>
>> took care of everything for us.We did not need any database changes.
>>
>> Ranju
>> National University of Ireland Maynooth.
>>
>> ----- Original Message -----
>> From: Joseph Reeves <iknowjoseph AT gmail.com>
>> Date: Friday, February 26, 2010 1:34 pm
>> Subject: [EP-tech] Changed my subjects list - now I have a problem
>> with old items...
>> To: eprints-tech AT ecs.soton.ac.uk
>>
>>> Dear all,
>>>
>>> Cutting a long story short, I have been asked to change the ↵
subjects
>>> file on our eprints installation - this all went fine and all our
>>> live items have been updated with their new subjects.
>>>
>>> Unfortunately, however, I discovered that there was a large amount ↵
of
>>> items in the review area that were tagged with the old subjects. ↵
I've
>>> applied the new subjects and can see no mention of the old ones, ↵
but
>>> in the item view I see links to "?? Old Subject ??". Of ↵
course, these
>>> 404 when clicked.
>>>
>>> I've ran generate_abstracts and the mention of the old subjects
>>> remain, although I can't find where these would be defined.
>>>
>>> Will this need a database update to resolve? If so, could somebody
>>> please point me in the right direction? Would it be possible to
>>> remove subject information for every item under review?
>>>
>>> We're all very pleased with our Eprints repository and resolving ↵
this
>>> issue will give us the opportunity to add much more content to it ↵
(at
>>> which point it'll go public).
>>>
>>> Thanks in advance, Joseph
>>> *** Options:
>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>> *** Archive: http://www.eprints.org/tech.php/
>>> *** EPrints community wiki: http://wiki.eprints.org/
>> *** Options:
>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>> *** Archive: http://www.eprints.org/tech.php/
>> *** EPrints community wiki: http://wiki.eprints.org/
>>
>>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
>
*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/

eprints_tech messages

[EP-tech] Re: Changed my subjects list - now I have a problem with old items...