Menu
▾
▴
#17 Page numbers are lost
1.I open the pub from the listings and click on the content title(s) that have a false pseudonym, which leads me to the title page containing all publications with that title and the corresponding pseudonym.
2.I must decide which of the pubs are not correct in order to unmerge them from the wrong title/pseudonym attribution. Sometimes there are more than one pub with the wrong attribution. So when I've chosen the "Unmerge Titles" option, I'll check all pubs that apply.
3.After approving the unmerge, I go to the pseudonymous author's page where the title(s) are now listed. If I had to unmerge more than one, I must first merge the duplicate titles into one title.
4.After approving the merge, I go back to the single title record and edit it, correcting the author.
5.After approving the title edit, I go to the correct author's summary page and merge the title with any duplicate title.
The page loss always occurs when I approve the first unmerge (step 3 above). [[User:Mhhutchins|Mhhutchins]] 21:07, 17 Oct 2007 (CDT)
I forgot to add that the title record also loses its length designation as well. [[User:Mhhutchins|Mhhutchins]] 21:08, 17 Oct 2007 (CDT)
Discussion
Anonymous
Logged In: YES
user_id=792831
Originator: NO
Reproduced for simpler cases:
Novels:
Go to http://yourserver/cgi-bin/pl.cgi?FMNNDMNSTR2001
(Of Men and Monsters by William Tenn; a novel, no additional content)
Edit it, adding page number 1 to the Content (for the NOVEL title);
submit, approve. The novel title won't be displayed but when you open the pub
for editing, you see Page: 1.
Go to the title by clicking on Title Reference link.
Unmerge your pub (Of Men and Monsters, 2001)
Submitting the following record:
<?xml version="1.0" encoding="iso-8859-1" ?>
<IsfdbSubmission>
<TitleUnmerge>
<Submitter>Demo</Submitter>
<Subject>Of Men and Monsters</Subject>
<Record>6354</Record>
<PubRecord>128661</PubRecord>
</TitleUnmerge>
</IsfdbSubmission>
Unmerging these works:
Publication Unmerged Title Name
Of Men and Monsters Of Men and Monsters
SQL Updates:
* delete from pub_content where title_id=6354 and pub_id=128661
* insert into titles(title_title, title_copyright, title_ttype) values('Of Men and Monsters', '2001-00-00', 'NOVEL');
* insert into canonical_author(title_id, author_id, ca_status) values('879374', '484', 1);
* insert into pub_content(pub_id, title_id) values(128661, 879374);
* ##########################################################
* update submissions set sub_state='I' where sub_id='969637'
* update submissions set sub_reviewer='13535' where sub_id='969637'
* update submissions set sub_reviewed=NOW() where sub_id='969637'
Go to http://fed8.roglo.net/cgi-bin/ea.cgi?William%20Tenn
There is a new novel title: Of Men and Monsters (2001).
Click on it, click on the pub, go to editing mode:
The Page field for the only title is empty.
Cause of the problem:
During Unmerging, a new title record is created, and only title, date
and ttype are set; also a new pub_content record is created and
only ids of the pub and the new title are set. Other title data (length)
and content data (page number) are lost.
To see the case of title length lost, repeat the procedure above
for a CHAPTERBOOK publication. E.g.:
http://yourserever/cgi-bin/pl.cgi?MSFFRGJNHN2008
(Muse of Fire by Dan Simmons; chapbook with a single story).
Click on the Title Reference, go to edit mode to see the length (nv).
Go back to the title and unmerge the 'Muse of Fire'.
Unmerging these works:
Publication Unmerged Title Name
Muse of Fire Muse of Fire
SQL Updates:
* delete from pub_content where title_id=534265 and pub_id=260549
* insert into titles(title_title, title_copyright, title_ttype) values('Muse of Fire', '2008-12-28', 'SHORTFICTION');
* insert into canonical_author(title_id, author_id, ca_status) values('879375', '170', 1);
* insert into pub_content(pub_id, title_id) values(260549, 879375);
* ##########################################################
* update submissions set sub_state='I' where sub_id='969638'
* update submissions set sub_reviewer='13535' where sub_id='969638'
* update submissions set sub_reviewed=NOW() where sub_id='969638'
The new title (dated 2008-12-28) doesn't have the length field set.
[And now the question is: should other fields (series, number in the series,
wikipedia link, synopsis, notes) be copied to the new title?]
mod/ta_unmerge.py v1.6 created, which will save and transfer pagenum (if any) and storylen (if any).
Fixed in r2011-11. Also added a link to the original title record in the post-approval screen and reworked the code to be more readable.