Menu

#88 pub_content corruption

None
open
Editing (2)
5
2015-10-10
2010-11-24
Ahasuerus
No

pub_content corruption - some entries in the pub_content table point to non-existent (deleted? merged?) titles. They need to be deleted and the software bug that lets them appear needs to be found and fixed. As of November 2010, the bug apparently still exists since the last known occurrence (pub 329094) appeared in August 2010. According to http://www.isfdb.org/wiki/index.php/User_talk:Hauck#M.C3.A9duse , \"I created the first printing of this title here with the merging of titles (as it\'s an original french collection) then probably cloned it for this subsequent printing the one you\'re citing. That\'s all I remember but the 1981 one is, in temr of contents, a strict duplicate of the 1978 one.\"

Discussion

  • Jesse Weinstein

    Jesse Weinstein - 2010-12-22

    As a precondition of solving this, we need to have a clear writeup on the wiki of which actions should alter the pub_content table (i.e. should alter a link between a publication and a title). Currently, the list of files that touch the pub_content table are: (ta = Title, pa = Publication)

    ta_unmerge, ta_delete, ta_remove (removing a link, but not deleting the title record itself), pa_delete, pa_update, pa_new, ca_new and common (setTitlePage and addPubArtist).

    Is this the correct set, or are there some missing or present that shouldn't be?

     
  • Ahasuerus

    Ahasuerus - 2015-10-10

    Ticket moved from /p/isfdb/bugs/184/

     

Anonymous
Anonymous

Add attachments
Cancel