search

hassanakbar4 / test-usernames

0 stars 0 forks source link

Duplicate RFC number in internet_drafts table (causes exceptions) #336

Closed hassanakbar4 closed 14 years ago

hassanakbar4 commented 14 years ago

resolution_fixed type_defect | by pasi.eronen@nokia.com

mysql> select id_document_tag,filename,rfc_number from internet_drafts where rfc_number in (select rfc_number from internet_drafts where rfc_number>0 group by rfc_number having count(*)>1);
+-----------------+-------------------------+------------+
| id_document_tag | filename                | rfc_number |
+-----------------+-------------------------+------------+
|            3013 | draft-iab-case-for-ipv6 |       3002 | 
|            5448 | draft-iab-wirelessws    |       3002 | 
+-----------------+-------------------------+------------+

This causes a "MultipleObjectsReturned" exception for URL /ipr/search/?option=rfc_search&rfc_search=3002 (and may cause other problems, too).

Issue migrated from trac:336 at 2021-12-13 14:46:45 +0500

hassanakbar4 commented 14 years ago

@pasi.eronen@nokia.com commented

Probably the entry for draft-iab-case-for-ipv6 is wrong (RFC 3002 seems to be draft-iab-wirelessws); sent email to Charlie Perkins asking.

hassanakbar4 commented 14 years ago

@pasi.eronen@nokia.com commented

Leslie Daigle confirmed that draft-iab-case-for-ipv6 was never published as RFC. I asked the secretariat to change the status to "Expired" (ticket rt.amsl.com 25682).

hassanakbar4 commented 14 years ago

@pasi.eronen@nokia.com changed status from new to closed

hassanakbar4 commented 14 years ago

@pasi.eronen@nokia.com set resolution to fixed

hassanakbar4 commented 14 years ago

@pasi.eronen@nokia.com commented

Fixed yesterday.