View covers for this year • Return to the publisher page
| Title | Date | Author/Editor | Publication series | ISBN/Catalog ID | Price | Pages | Format | Type | Cover Artist | Verif |
|---|---|---|---|---|---|---|---|---|---|---|
| <class 'MySQLdb._exceptions.ProgrammingError'> | Python 2.7.18: /usr/bin/python Tue Apr 30 02:42:59 2024 |
A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.
| /home/stoecker/isfdb/install/cgi-bin/publisheryear.cgi in <module>() |
| 55 print ISFDBLinkNoName('publisher.cgi', publisher_id, 'Return to the publisher page') |
| 56 print '<p>' |
| => 57 PrintPubsTable(pubs, 'publisher') |
| 58 |
| 59 PrintTrailer('publisheryear', publisher_id, publisher_id) |
| PrintPubsTable = <function PrintPubsTable>, pubs = [(17821, 'Illywhacker', 'BKTG22725', '1986-00-00', 145, '600', 'pb', 'NOVEL', '0060913312', None, '$9.95', None, None, None, None), (450396, 'Lulu and the Witch Baby', 'LLNDTHWTCH1986', '1986-00-00', 145, '65', 'hc', 'CHAPBOOK', '006024626X', 'https://m.media-amazon.com/images/I/51YdeHJb9sL.jpg', '', 387353, 294, None, None), (651084, 'Always Coming Home', 'LWSCMNGHMC1986', '1986-00-00', 145, '523+[2]', 'tp', 'NOVEL', '006015456X', 'http://www.isfdb.org/wiki/images/1/14/LWSCMNGHMR1985.jpg', '$25.00', 671849, None, None, None), (682772, 'The Bee-Man of Orn', 'THBMNFRNXH1986', '1986-00-00', 145, '44', 'hc', 'CHAPBOOK', '0060258187', 'https://images-na.ssl-images-amazon.com/images/I/51ypQFCaS3L.jpg', None, 727650, None, None, None), (171531, 'Hawksmoor', 'HWKSMRFBNR1985', '1986-01-00', 145, '217', 'hc', 'NOVEL', '0060155035', 'http://www.isfdb.org/wiki/images/a/a4/HWKSMRFBNR1985.jpg', '$16.95', 129076, None, None, None), (37223, 'The Clearing', 'BKTG05474', '1986-03-00', 145, '186', 'hc', 'NOVEL', '0062500325', 'https://covers.openlibrary.org/b/id/6932665-L.jpg', '$12.95', 950835, 9924, None, None), (47964, 'The Stolen Law', 'BKTG10369', '1986-03-00', 145, '218', 'hc', 'NOVEL', '0060241187', 'https://images-na.ssl-images-amazon.com/images/I/A1z1mM1D5QL.jpg', '$12.50', None, None, None, None), (55811, 'Young Star Travelers', 'YNGSTRTRVL1986', '1986-03-00', 145, 'xiii+209', 'hc', 'ANTHOLOGY', '0060201789', '', '$13.50', 974155, None, None, None), (582718, 'The Stolen Law', 'THSTLNLWBC1986', '1986-03-00', 145, '218', 'hc', 'NOVEL', '0060241195', 'https://images-na.ssl-images-amazon.com/images/I/A1z1mM1D5QL.jpg', '$11.89', 558959, None, None, None), (636666, 'Young Star Travelers', 'NGSTRTRVLR1986', '1986-03-00', 145, 'xiii+209', 'hc', 'ANTHOLOGY', '0060201797', 'http://www.isfdb.org/wiki/images/c/ca/NGSTRTRVLR1986.jpg', '$12.80', 647156, None, None, None), (11235, 'Dragons & Dreams: A Collection of New Fantasy and Science Fiction Stories', 'DRGNSNDDRM1986', '1986-04-00', 145, '180', 'hc', 'ANTHOLOGY', '0060267933', 'http://www.isfdb.org/wiki/images/4/43/DRGNSNDDRM1986.jpg', '$11.89', 924010, None, None, None), (917496, 'Dragons & Dreams: A Collection of New Fantasy and Science Fiction Stories', 'DRGNSDRMSC1986', '1986-04-00', 145, 'x+180', 'hc', 'ANTHOLOGY', '0060267925', None, '$12.50', None, None, None, None), (27247, 'Racso and the Rats of NIMH', 'BKTG00189', '1986-05-00', 145, '278', 'hc', 'NOVEL', '0060213612', 'https://m.media-amazon.com/images/I/51JEP3R0PML.jpg', '$12.50', 521183, None, None, None), (27248, 'Racso and the Rats of NIMH', 'RCSNDTHRTS1986', '1986-05-00', 145, '278', 'hc', 'NOVEL', '0060213620', 'https://m.media-amazon.com/images/P/0060213620.jpg', '$11.89', 521184, None, None, None), (13512, 'Figures of Enchantment', 'BKTG04222', '1986-07-00', 145, '256', 'hc', 'NOVEL', '0060155752', 'https://m.media-amazon.com/images/I/51M186hfJ%2BL.jpg', '$15.95', 1060825, None, None, None), (682775, 'The Griffin and the Minor Canon', 'THGRFFNNDT1986', '1986-09-25', 145, '55', 'hc', 'CHAPBOOK', '0060258160', 'https://images-na.ssl-images-amazon.com/images/I/51TbvnUI74L.jpg', '$12.95', 727653, None, None, None), (22789, 'Moonwind', 'BKTG08979', '1986-10-00', 145, '180', 'hc', 'NOVEL', '0060237333', 'https://m.media-amazon.com/images/I/31x-IWzZpyL.jpg', '$12.50', None, None, None, None), (22790, 'Moonwind', 'MNWND1986', '1986-10-00', 145, '180', 'hc', 'NOVEL', '0060237341', 'https://m.media-amazon.com/images/G/01/ciu/f5/97/172d228348a03eb914066110.L.jpg', '', 197970, None, None, None), (28844, 'Sandeagozu', 'BKTG07146', '1986-10-00', 145, '442', 'hc', 'NOVEL', '0060156333', 'http://www.isfdb.org/wiki/images/e/eb/BKTG07146.jpg', '$18.95', 183415, None, None, None), (491831, 'Clive Staples Lewis: A Dramatic Life', 'CLVSTPLSLW1986', '1986-10-00', 145, 'xxv+507', 'hc', 'NONFICTION', '0062503529', 'https://m.media-amazon.com/images/I/7181jlYecuL.jpg', '$24.95', 434863, None, None, None), ...] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(17821, 'Illywhacker', 'BKTG22725', '1986-00-00', 145, '600', 'pb', 'NOVEL', '0060913312', None, '$9.95', None, None, None, None), (450396, 'Lulu and the Witch Baby', 'LLNDTHWTCH1986', '1986-00-00', 145, '65', 'hc', 'CHAPBOOK', '006024626X', 'https://m.media-amazon.com/images/I/51YdeHJb9sL.jpg', '', 387353, 294, None, None), (651084, 'Always Coming Home', 'LWSCMNGHMC1986', '1986-00-00', 145, '523+[2]', 'tp', 'NOVEL', '006015456X', 'http://www.isfdb.org/wiki/images/1/14/LWSCMNGHMR1985.jpg', '$25.00', 671849, None, None, None), (682772, 'The Bee-Man of Orn', 'THBMNFRNXH1986', '1986-00-00', 145, '44', 'hc', 'CHAPBOOK', '0060258187', 'https://images-na.ssl-images-amazon.com/images/I/51ypQFCaS3L.jpg', None, 727650, None, None, None), (171531, 'Hawksmoor', 'HWKSMRFBNR1985', '1986-01-00', 145, '217', 'hc', 'NOVEL', '0060155035', 'http://www.isfdb.org/wiki/images/a/a4/HWKSMRFBNR1985.jpg', '$16.95', 129076, None, None, None), (37223, 'The Clearing', 'BKTG05474', '1986-03-00', 145, '186', 'hc', 'NOVEL', '0062500325', 'https://covers.openlibrary.org/b/id/6932665-L.jpg', '$12.95', 950835, 9924, None, None), (47964, 'The Stolen Law', 'BKTG10369', '1986-03-00', 145, '218', 'hc', 'NOVEL', '0060241187', 'https://images-na.ssl-images-amazon.com/images/I/A1z1mM1D5QL.jpg', '$12.50', None, None, None, None), (55811, 'Young Star Travelers', 'YNGSTRTRVL1986', '1986-03-00', 145, 'xiii+209', 'hc', 'ANTHOLOGY', '0060201789', '', '$13.50', 974155, None, None, None), (582718, 'The Stolen Law', 'THSTLNLWBC1986', '1986-03-00', 145, '218', 'hc', 'NOVEL', '0060241195', 'https://images-na.ssl-images-amazon.com/images/I/A1z1mM1D5QL.jpg', '$11.89', 558959, None, None, None), (636666, 'Young Star Travelers', 'NGSTRTRVLR1986', '1986-03-00', 145, 'xiii+209', 'hc', 'ANTHOLOGY', '0060201797', 'http://www.isfdb.org/wiki/images/c/ca/NGSTRTRVLR1986.jpg', '$12.80', 647156, None, None, None), (11235, 'Dragons & Dreams: A Collection of New Fantasy and Science Fiction Stories', 'DRGNSNDDRM1986', '1986-04-00', 145, '180', 'hc', 'ANTHOLOGY', '0060267933', 'http://www.isfdb.org/wiki/images/4/43/DRGNSNDDRM1986.jpg', '$11.89', 924010, None, None, None), (917496, 'Dragons & Dreams: A Collection of New Fantasy and Science Fiction Stories', 'DRGNSDRMSC1986', '1986-04-00', 145, 'x+180', 'hc', 'ANTHOLOGY', '0060267925', None, '$12.50', None, None, None, None), (27247, 'Racso and the Rats of NIMH', 'BKTG00189', '1986-05-00', 145, '278', 'hc', 'NOVEL', '0060213612', 'https://m.media-amazon.com/images/I/51JEP3R0PML.jpg', '$12.50', 521183, None, None, None), (27248, 'Racso and the Rats of NIMH', 'RCSNDTHRTS1986', '1986-05-00', 145, '278', 'hc', 'NOVEL', '0060213620', 'https://m.media-amazon.com/images/P/0060213620.jpg', '$11.89', 521184, None, None, None), (13512, 'Figures of Enchantment', 'BKTG04222', '1986-07-00', 145, '256', 'hc', 'NOVEL', '0060155752', 'https://m.media-amazon.com/images/I/51M186hfJ%2BL.jpg', '$15.95', 1060825, None, None, None), (682775, 'The Griffin and the Minor Canon', 'THGRFFNNDT1986', '1986-09-25', 145, '55', 'hc', 'CHAPBOOK', '0060258160', 'https://images-na.ssl-images-amazon.com/images/I/51TbvnUI74L.jpg', '$12.95', 727653, None, None, None), (22789, 'Moonwind', 'BKTG08979', '1986-10-00', 145, '180', 'hc', 'NOVEL', '0060237333', 'https://m.media-amazon.com/images/I/31x-IWzZpyL.jpg', '$12.50', None, None, None, None), (22790, 'Moonwind', 'MNWND1986', '1986-10-00', 145, '180', 'hc', 'NOVEL', '0060237341', 'https://m.media-amazon.com/images/G/01/ciu/f5/97/172d228348a03eb914066110.L.jpg', '', 197970, None, None, None), (28844, 'Sandeagozu', 'BKTG07146', '1986-10-00', 145, '442', 'hc', 'NOVEL', '0060156333', 'http://www.isfdb.org/wiki/images/e/eb/BKTG07146.jpg', '$18.95', 183415, None, None, None), (491831, 'Clive Staples Lewis: A Dramatic Life', 'CLVSTPLSLW1986', '1986-10-00', 145, 'xxv+507', 'hc', 'NONFICTION', '0062503529', 'https://m.media-amazon.com/images/I/7181jlYecuL.jpg', '$24.95', 434863, None, None, None), ...], display_type='publisher', user=<login.User instance>, limit=100000) |
| 1080 index = 1 |
| 1081 for pub in pubs: |
| => 1082 PrintOnePub(pub, pub_authors, pub_publishers, pub_series, cover_artists, bgcolor, display_type, user, index) |
| 1083 bgcolor ^= 1 |
| 1084 index += 1 |
| global PrintOnePub = <function PrintOnePub>, pub = (17821, 'Illywhacker', 'BKTG22725', '1986-00-00', 145, '600', 'pb', 'NOVEL', '0060913312', None, '$9.95', None, None, None, None), pub_authors = {11235: [(509, 'Martin H. Greenberg', 'Greenberg'), (7778, 'Charles G. Waugh', 'Waugh'), (250, 'Jane Yolen', 'Yolen')], 13512: [(5867, 'Zulfikar Ghose', 'Ghose')], 14021: [(360, 'Chelsea Quinn Yarbro', 'Yarbro')], 17821: [(2368, 'Peter Carey', 'Carey')], 22789: [(1649, 'Louise Lawrence', 'Lawrence')], 22790: [(1649, 'Louise Lawrence', 'Lawrence')], 27247: [(6212, 'Jane Leslie Conly', 'Conly')], 27248: [(6212, 'Jane Leslie Conly', 'Conly')], 28844: [(126859, 'Janann V. Jenner', 'Jenner')], 37223: [(5730, 'Alan Arkin', 'Arkin')], ...}, pub_publishers = {145: 'Harper & Row'}, pub_series = {294: 'I Can Read Book', 9924: 'A Charlotte Zolotow Book'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(17821, 'Illywhacker', 'BKTG22725', '1986-00-00', 145, '600', 'pb', 'NOVEL', '0060913312', None, '$9.95', None, None, None, None), pub_authors={11235: [(509, 'Martin H. Greenberg', 'Greenberg'), (7778, 'Charles G. Waugh', 'Waugh'), (250, 'Jane Yolen', 'Yolen')], 13512: [(5867, 'Zulfikar Ghose', 'Ghose')], 14021: [(360, 'Chelsea Quinn Yarbro', 'Yarbro')], 17821: [(2368, 'Peter Carey', 'Carey')], 22789: [(1649, 'Louise Lawrence', 'Lawrence')], 22790: [(1649, 'Louise Lawrence', 'Lawrence')], 27247: [(6212, 'Jane Leslie Conly', 'Conly')], 27248: [(6212, 'Jane Leslie Conly', 'Conly')], 28844: [(126859, 'Janann V. Jenner', 'Jenner')], 37223: [(5730, 'Alan Arkin', 'Arkin')], ...}, pub_publishers={145: 'Harper & Row'}, pub_series={294: 'I Can Read Book', 9924: 'A Charlotte Zolotow Book'}, cover_artists={}, bgcolor=1, display_type='publisher', user=<login.User instance>, index=1) |
| 1105 |
| 1106 # Publication title |
| => 1107 print '<td dir="ltr">%s</td>' % ISFDBLink('pl.cgi', pub[PUB_PUBID], pub[PUB_TITLE], argument=getStylePub(pub[PUB_PUBID])) |
| 1108 |
| 1109 # Publication date unless this is a Publication Series, in which case we have already displayed the date |
| global ISFDBLink = <function ISFDBLink>, pub = (17821, 'Illywhacker', 'BKTG22725', '1986-00-00', 145, '600', 'pb', 'NOVEL', '0060913312', None, '$9.95', None, None, None, None), global PUB_PUBID = 0, global PUB_TITLE = 1, argument undefined, global getStylePub = <function getStylePub> |
| /home/stoecker/isfdb/install/cgi-bin/library.py in ISFDBLink(script='pl.cgi', record_id=17821, displayed_value='Illywhacker', brackets=False, argument='', transliterations=None) |
| 463 # use that function to retrieve transliterations |
| 464 elif trans_function and str(record_id).isdigit(): |
| => 465 trans_values = trans_function(record_id) |
| 466 # If transliterated values have been found, add them to the link |
| 467 if trans_values: |
| trans_values = None, trans_function = <function SQLloadTransPubTitles>, record_id = 17821 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=17821) |
| 1806 def SQLloadTransPubTitles(pub_id): |
| 1807 query = "select trans_pub_title from trans_pubs where pub_id=%d" % int(pub_id) |
| => 1808 return _OneField(query) |
| 1809 |
| 1810 def SQLLoadTransPubTitlesList(pub_ids): |
| global _OneField = <function _OneField>, query = 'select trans_pub_title from trans_pubs where pub_id=17821' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=17821') |
| 53 |
| 54 def _OneField(query): |
| => 55 db.query(query) |
| 56 result = db.store_result() |
| 57 record = result.fetch_row() |
| global db = <_mysql.connection open to '127.0.0.1'>, db.query = <bound method Connection.query of <_mysql.connection open to '127.0.0.1'>>, query = 'select trans_pub_title from trans_pubs where pub_id=17821' |
| /usr/lib64/python2.7/site-packages/MySQLdb/connections.py in query(self=<_mysql.connection open to '127.0.0.1'>, query='select trans_pub_title from trans_pubs where pub_id=17821') |
| 237 if isinstance(query, bytearray): |
| 238 query = bytes(query) |
| => 239 _mysql.connection.query(self, query) |
| 240 |
| 241 def _bytes_literal(self, bs): |
| global _mysql = <module 'MySQLdb._mysql' from '/usr/lib64/python2.7/site-packages/MySQLdb/_mysql.so'>, _mysql.connection = <type '_mysql.connection'>, _mysql.connection.query = <method 'query' of '_mysql.connection' objects>, self = <_mysql.connection open to '127.0.0.1'>, query = 'select trans_pub_title from trans_pubs where pub_id=17821' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''