Menu
▾
▴
#87 Title Notes-id Set to 0
Was: EditBug:10103
Title notes-id set to 0 OPEN Sometimes the notes-id field for a title will get set to 0 (zero) and means that attempts to set the note get tossed into the bit bucket. I had just cloned and unmerged two titles meaning they were fresh title records and both of them got into this notes=0 state. I was unable to replicate how I got into this mode and ended up unmerging the single publication each title had to create new title records and was then able to set their notes. As there is a condition that will set notes=0 I'd have the integration code check for both NULL and 0 when deciding if it should add a new note or update the existing note. Marc Kupper (talk) 21:14, 6 Apr 2007 (CDT)
Discussion
Anonymous
It turns out that this issue is caused by the fact that the ISFDB MySQL database is set up not to use the STRICT_TRANS_TABLES start-up variable. Thus, when Python sets the value of a numeric field (including note_id, synopsis ID and series ID in the titles table) to 'None', MySQL converts it to 0.
We have a similar problem in the pub table where we have 5 records with note_id=0, which makes them ineditable, but at this time we don't know what's causing them.
Ticket moved from /p/isfdb/bugs/11/
Moved from "Bugs" to "Support Requests" because, as of 2015, this issue has no on adverse impact on user-experienced functionality.