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 Sun Apr 28 13:21:45 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 = [(152111, "Death's Master", 'DTHSMSTRJF1982', '1982-00-00', 293, '320', 'pb', 'NOVEL', '0600201910', 'https://m.media-amazon.com/images/I/51dXR45Aw4L.jpg', '\xc2\xa31.50', 226107, None, None, None), (216613, 'King and Joker', 'KNGNDJKRTF1982', '1982-00-00', 293, '189', 'pb', 'NOVEL', '0600204952', 'http://www.isfdb.org/wiki/images/3/31/KNGNDJKRTF1982.jpg', '\xc2\xa31.25', 136562, None, None, None), (84798, 'Here Comes Everybody: An Introduction to James Joyce for the Ordinary Reader', 'HRCMSVRBDN1982', '1982-00-00', 293, '276', 'pb', 'NONFICTION', '0600206734', 'https://images-na.ssl-images-amazon.com/images/I/61wNd-8u2CL.jpg', '\xc2\xa31.75', 256370, None, None, None), (233397, 'Tales of King Arthur', 'TLSFKNGRTH1982', '1982-00-00', 293, '124', 'hc', 'COLLECTION', '0600353524', None, '\xc2\xa34.95', 259349, None, None, None), (290794, 'Entombed', 'NTMBDNMRGK1982', '1982-00-00', 293, '191', 'pb', 'NOVEL', '0600203530', None, '\xc2\xa31.25', 173549, None, None, None), (296953, 'Hellborn', 'HLLBRNMFLZ1982', '1982-00-00', 293, '187', 'pb', 'NOVEL', '0600204650', 'http://www.isfdb.org/wiki/images/2/25/HLLBRNMFLZ1982.jpg', '\xc2\xa31.25', 259456, None, None, None), (352746, 'The Pike', 'THPKLJHBRS1982', '1982-00-00', 293, '160', 'pb', 'NOVEL', '0600206645', 'http://www.isfdb.org/wiki/images/a/a0/THPKLJHBRS1982.jpg', '\xc2\xa31.25', 260907, None, None, None), (383271, 'Return of the Howling', 'RTRNFTHHWL1982', '1982-00-00', 293, '193', 'pb', 'NOVEL', '0600346145', 'https://m.media-amazon.com/images/G/02/ciu/a4/04/164336c622a0f242a26b6110.L.jpg', '\xc2\xa31.25', 296688, None, None, None), (401328, 'Haunting Stories of Ghosts and Ghouls', 'HNTNGSTRSF1982', '1982-00-00', 293, '256', 'hc', 'COLLECTION', '0600366766', 'https://covers.openlibrary.org/b/id/11642291-L.jpg', '\xc2\xa31.75', 320348, 2140, None, None), (188537, 'The Dancers of Arun', 'THDNCRSFRN1982', '1982-01-00', 293, '256', 'pb', 'NOVEL', '0600202232', 'http://www.isfdb.org/wiki/images/e/e6/THDNCRSFRN1982.jpg', '\xc2\xa31.50', 259348, 10999, None, None), (296964, 'Blood Island', 'BLDSLNDVPT1982', '1982-01-07', 293, '240', 'pb', 'NOVEL', '0600204936', 'http://www.isfdb.org/wiki/images/2/28/BLDSLNDVPT1982.jpg', '\xc2\xa31.35', 1047471, None, None, None), (351703, 'Entombed', 'NTMBDFQCMK1982', '1982-03-00', 293, '191', 'pb', 'NOVEL', '0600203530', 'https://m.media-amazon.com/images/I/31tWVz1aiOL.jpg', '\xc2\xa31.25', 259452, None, None, None), (351203, 'Spend Game', 'SPNDGMSKPZ1982', '1982-04-00', 293, '160', 'pb', 'NOVEL', '0600203980', 'http://www.isfdb.org/wiki/images/7/7e/SPNDGMSKPZ1982.jpg', '\xc2\xa31.25', 258894, None, None, None), (296986, 'The Beast Within', 'THBSTWTHNM1982', '1982-04-01', 293, '219', 'pb', 'NOVEL', '0600206165', 'https://m.media-amazon.com/images/I/41UczqhFZbL.jpg', '\xc2\xa31.25', 183849, None, None, None), (296982, 'The Skull', 'THSKLLCWPL1982', '1982-04-29', 293, '188', 'pb', 'NOVEL', '0600204081', 'http://www.isfdb.org/wiki/images/e/ea/THSKLLCWPL1982.jpg', '\xc2\xa31.25', 183845, None, None, None), (297026, 'Eclipse', 'CLPSJTSBGZ1982', '1982-04-29', 293, '192', 'pb', 'NOVEL', '0600204456', 'http://www.isfdb.org/wiki/images/a/a0/CLPSJTSBGZ1982.jpg', '\xc2\xa31.35', None, None, None, None), (344983, 'The Offering', 'THFFRNGZPC1982', '1982-05-00', 293, '156', 'pb', 'NOVEL', '0600203581', 'http://www.isfdb.org/wiki/images/1/18/THFFRNGZPC1982.jpg', '\xc2\xa31.25', 259451, None, None, None), (297023, 'The Pluto Pact', 'THPLTPCTVV1982', '1982-07-00', 293, '187', 'pb', 'NOVEL', '060020488X', 'https://m.media-amazon.com/images/I/41sQQhLOqcL.jpg', '\xc2\xa31.25', 1021625, None, None, None), (293530, 'Exciting Stories of Fantasy and the Future', 'XCTNGSTRSF1982', '1982-08-00', 293, '256', 'hc', 'ANTHOLOGY', '0600366774', 'http://www.isfdb.org/wiki/images/b/bd/XCTNGSTRSF1982.jpg', '\xc2\xa31.75', 178073, 2140, None, None), (279696, 'The Fifth Sally', 'THFFTHSLLC1982', '1982-10-00', 293, '278', 'pb', 'NOVEL', '0600205207', None, '\xc2\xa31.50', 259350, None, None, None), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(152111, "Death's Master", 'DTHSMSTRJF1982', '1982-00-00', 293, '320', 'pb', 'NOVEL', '0600201910', 'https://m.media-amazon.com/images/I/51dXR45Aw4L.jpg', '\xc2\xa31.50', 226107, None, None, None), (216613, 'King and Joker', 'KNGNDJKRTF1982', '1982-00-00', 293, '189', 'pb', 'NOVEL', '0600204952', 'http://www.isfdb.org/wiki/images/3/31/KNGNDJKRTF1982.jpg', '\xc2\xa31.25', 136562, None, None, None), (84798, 'Here Comes Everybody: An Introduction to James Joyce for the Ordinary Reader', 'HRCMSVRBDN1982', '1982-00-00', 293, '276', 'pb', 'NONFICTION', '0600206734', 'https://images-na.ssl-images-amazon.com/images/I/61wNd-8u2CL.jpg', '\xc2\xa31.75', 256370, None, None, None), (233397, 'Tales of King Arthur', 'TLSFKNGRTH1982', '1982-00-00', 293, '124', 'hc', 'COLLECTION', '0600353524', None, '\xc2\xa34.95', 259349, None, None, None), (290794, 'Entombed', 'NTMBDNMRGK1982', '1982-00-00', 293, '191', 'pb', 'NOVEL', '0600203530', None, '\xc2\xa31.25', 173549, None, None, None), (296953, 'Hellborn', 'HLLBRNMFLZ1982', '1982-00-00', 293, '187', 'pb', 'NOVEL', '0600204650', 'http://www.isfdb.org/wiki/images/2/25/HLLBRNMFLZ1982.jpg', '\xc2\xa31.25', 259456, None, None, None), (352746, 'The Pike', 'THPKLJHBRS1982', '1982-00-00', 293, '160', 'pb', 'NOVEL', '0600206645', 'http://www.isfdb.org/wiki/images/a/a0/THPKLJHBRS1982.jpg', '\xc2\xa31.25', 260907, None, None, None), (383271, 'Return of the Howling', 'RTRNFTHHWL1982', '1982-00-00', 293, '193', 'pb', 'NOVEL', '0600346145', 'https://m.media-amazon.com/images/G/02/ciu/a4/04/164336c622a0f242a26b6110.L.jpg', '\xc2\xa31.25', 296688, None, None, None), (401328, 'Haunting Stories of Ghosts and Ghouls', 'HNTNGSTRSF1982', '1982-00-00', 293, '256', 'hc', 'COLLECTION', '0600366766', 'https://covers.openlibrary.org/b/id/11642291-L.jpg', '\xc2\xa31.75', 320348, 2140, None, None), (188537, 'The Dancers of Arun', 'THDNCRSFRN1982', '1982-01-00', 293, '256', 'pb', 'NOVEL', '0600202232', 'http://www.isfdb.org/wiki/images/e/e6/THDNCRSFRN1982.jpg', '\xc2\xa31.50', 259348, 10999, None, None), (296964, 'Blood Island', 'BLDSLNDVPT1982', '1982-01-07', 293, '240', 'pb', 'NOVEL', '0600204936', 'http://www.isfdb.org/wiki/images/2/28/BLDSLNDVPT1982.jpg', '\xc2\xa31.35', 1047471, None, None, None), (351703, 'Entombed', 'NTMBDFQCMK1982', '1982-03-00', 293, '191', 'pb', 'NOVEL', '0600203530', 'https://m.media-amazon.com/images/I/31tWVz1aiOL.jpg', '\xc2\xa31.25', 259452, None, None, None), (351203, 'Spend Game', 'SPNDGMSKPZ1982', '1982-04-00', 293, '160', 'pb', 'NOVEL', '0600203980', 'http://www.isfdb.org/wiki/images/7/7e/SPNDGMSKPZ1982.jpg', '\xc2\xa31.25', 258894, None, None, None), (296986, 'The Beast Within', 'THBSTWTHNM1982', '1982-04-01', 293, '219', 'pb', 'NOVEL', '0600206165', 'https://m.media-amazon.com/images/I/41UczqhFZbL.jpg', '\xc2\xa31.25', 183849, None, None, None), (296982, 'The Skull', 'THSKLLCWPL1982', '1982-04-29', 293, '188', 'pb', 'NOVEL', '0600204081', 'http://www.isfdb.org/wiki/images/e/ea/THSKLLCWPL1982.jpg', '\xc2\xa31.25', 183845, None, None, None), (297026, 'Eclipse', 'CLPSJTSBGZ1982', '1982-04-29', 293, '192', 'pb', 'NOVEL', '0600204456', 'http://www.isfdb.org/wiki/images/a/a0/CLPSJTSBGZ1982.jpg', '\xc2\xa31.35', None, None, None, None), (344983, 'The Offering', 'THFFRNGZPC1982', '1982-05-00', 293, '156', 'pb', 'NOVEL', '0600203581', 'http://www.isfdb.org/wiki/images/1/18/THFFRNGZPC1982.jpg', '\xc2\xa31.25', 259451, None, None, None), (297023, 'The Pluto Pact', 'THPLTPCTVV1982', '1982-07-00', 293, '187', 'pb', 'NOVEL', '060020488X', 'https://m.media-amazon.com/images/I/41sQQhLOqcL.jpg', '\xc2\xa31.25', 1021625, None, None, None), (293530, 'Exciting Stories of Fantasy and the Future', 'XCTNGSTRSF1982', '1982-08-00', 293, '256', 'hc', 'ANTHOLOGY', '0600366774', 'http://www.isfdb.org/wiki/images/b/bd/XCTNGSTRSF1982.jpg', '\xc2\xa31.75', 178073, 2140, None, None), (279696, 'The Fifth Sally', 'THFFTHSLLC1982', '1982-10-00', 293, '278', 'pb', 'NOVEL', '0600205207', None, '\xc2\xa31.50', 259350, 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 = (152111, "Death's Master", 'DTHSMSTRJF1982', '1982-00-00', 293, '320', 'pb', 'NOVEL', '0600201910', 'https://m.media-amazon.com/images/I/51dXR45Aw4L.jpg', '\xc2\xa31.50', 226107, None, None, None), pub_authors = {84798: [(1747, 'Anthony Burgess', 'Burgess')], 152111: [(105, 'Tanith Lee', 'Lee')], 188513: [(1040, 'Elizabeth A. Lynn', 'Lynn')], 188537: [(1040, 'Elizabeth A. Lynn', 'Lynn')], 216613: [(1442, 'Peter Dickinson', 'Dickinson')], 233397: [(28768, 'James Riordan', 'Riordan')], 279696: [(1576, 'Daniel Keyes', 'Keyes')], 290794: [(1182, 'Guy N. Smith', 'Smith')], 293530: [(20754, 'uncredited', 'uncredited')], 296953: [(1521, 'Gary Brandner', 'Brandner')], ...}, pub_publishers = {293: 'Hamlyn'}, pub_series = {2140: 'Falcon Fiction Club', 10999: 'Hamlyn Science Fantasy'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(152111, "Death's Master", 'DTHSMSTRJF1982', '1982-00-00', 293, '320', 'pb', 'NOVEL', '0600201910', 'https://m.media-amazon.com/images/I/51dXR45Aw4L.jpg', '\xc2\xa31.50', 226107, None, None, None), pub_authors={84798: [(1747, 'Anthony Burgess', 'Burgess')], 152111: [(105, 'Tanith Lee', 'Lee')], 188513: [(1040, 'Elizabeth A. Lynn', 'Lynn')], 188537: [(1040, 'Elizabeth A. Lynn', 'Lynn')], 216613: [(1442, 'Peter Dickinson', 'Dickinson')], 233397: [(28768, 'James Riordan', 'Riordan')], 279696: [(1576, 'Daniel Keyes', 'Keyes')], 290794: [(1182, 'Guy N. Smith', 'Smith')], 293530: [(20754, 'uncredited', 'uncredited')], 296953: [(1521, 'Gary Brandner', 'Brandner')], ...}, pub_publishers={293: 'Hamlyn'}, pub_series={2140: 'Falcon Fiction Club', 10999: 'Hamlyn Science Fantasy'}, 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 = (152111, "Death's Master", 'DTHSMSTRJF1982', '1982-00-00', 293, '320', 'pb', 'NOVEL', '0600201910', 'https://m.media-amazon.com/images/I/51dXR45Aw4L.jpg', '\xc2\xa31.50', 226107, 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=152111, displayed_value="Death's Master", 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 = 152111 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=152111) |
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=152111' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=152111') |
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=152111' |
/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=152111') |
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=152111' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''