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 Mon Apr 29 05:01:04 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 = [(135061, 'Damaged Goods', 'DMGDGDSPFX1996', '1996-00-00', 515, '263', 'pb', 'NOVEL', '0426204832', 'http://www.isfdb.org/wiki/images/5/59/DMGDGDSPFX1996.jpg', '\xc2\xa34.99', 39061, None, None, None), (126511, 'Downtime', 'DWNTMRPJJF1996', '1996-01-00', 515, '263', 'pb', 'NOVEL', '042620462X', 'http://www.isfdb.org/wiki/images/0/06/DWNTMRPJJF1996.jpg', '\xc2\xa34.99', 31071, None, None, None), (135011, 'Just War', 'JSTWRZPQQL1996', '1996-01-00', 515, '257', 'pb', 'NOVEL', '0426204638', 'http://www.isfdb.org/wiki/images/1/11/JSTWRZPQQL1996.jpg', '\xc2\xa34.99', 151337, None, None, None), (126501, 'The Man in the Velvet Mask', 'THMNNTHVLV1996', '1996-02-00', 515, '250', 'pb', 'NOVEL', '0426204611', 'http://www.isfdb.org/wiki/images/f/fd/THMNNTHVLV1996.jpg', '\xc2\xa34.99', 31051, None, None, None), (135001, 'Warchild', 'WRCHLDDTVH1996', '1996-02-00', 515, '310', 'pb', 'NOVEL', '0426204646', 'http://www.isfdb.org/wiki/images/7/7c/WRCHLDDTVH1996.jpg', '\xc2\xa34.99', 143764, None, None, None), (126491, 'The English Way of Death', 'THNGLSHWFD1996', '1996-03-00', 515, '278', 'pb', 'NOVEL', '0426204662', 'http://www.isfdb.org/wiki/images/e/e8/THNGLSHWFD1996.jpg', '\xc2\xa34.99', 31041, None, None, None), (135051, 'Sleepy', 'SLPSDWCJHV1996', '1996-03-00', 515, '255', 'pb', 'NOVEL', '0426204654', 'http://www.isfdb.org/wiki/images/8/80/SLPSDWCJHV1996.jpg', '\xc2\xa34.99', 151319, None, None, None), (445699, 'Ace!', 'CLTKMFTPRZ1996', '1996-03-00', 515, '124', 'hc', 'NONFICTION', '185227574X', 'https://m.media-amazon.com/images/I/618Zxi4cHaL.jpg', '\xc2\xa317.99', None, None, None, None), (127641, 'Who Killed Kennedy', 'WHKLLDKNND1996', '1996-04-00', 515, '281', 'pb', 'NOVEL', '0426204670', 'https://m.media-amazon.com/images/I/51E0ulXgyuL.jpg', '\xc2\xa34.99', 32301, None, None, None), (135041, 'Death and Diplomacy', 'DTHNDDPLMC1996', '1996-04-00', 515, '280', 'pb', 'NOVEL', '0426204689', 'http://www.isfdb.org/wiki/images/4/49/DTHNDDPLMC1996.jpg', '\xc2\xa34.99', 151322, None, None, None), (135241, 'The Eye of the Giant', 'THFTHGNTMP1996', '1996-04-00', 515, '315', 'pb', 'NOVEL', '0426204697', 'http://www.isfdb.org/wiki/images/b/b1/THFTHGNTMP1996.jpg', '\xc2\xa34.99', 39111, None, None, None), (725, 'A History of the Universe', 'HSTRYUNV1996', '1996-05-00', 515, '273', 'tp', 'NONFICTION', '0426204719', 'https://m.media-amazon.com/images/I/61r1Sf1oVSL.jpg', '\xc2\xa37.99', 380632, None, None, None), (10859, 'Happy Endings', 'HPPYENDG1997', '1996-05-00', 515, '291', 'pb', 'NOVEL', '0426204700', 'http://www.isfdb.org/wiki/images/3/3c/HPPYENDG1997.jpg', '\xc2\xa34.99', 145352, None, None, None), (135231, 'The Sands of Time', 'THSNDSFTMM1996', '1996-05-00', 515, '292', 'pb', 'NOVEL', '0426204727', 'http://www.isfdb.org/wiki/images/b/b6/THSNDSFTMM1996.jpg', '\xc2\xa34.99', 39101, None, None, None), (10858, 'Godengine', 'GDENGN1996', '1996-06-00', 515, '243', 'pb', 'NOVEL', '0426204735', 'http://www.isfdb.org/wiki/images/c/c5/GDENGN1996.jpg', '\xc2\xa34.99', 171166, None, None, None), (140401, 'Killing Ground', 'KLLNGGRNDB1996', '1996-06-00', 515, '246', 'pb', 'NOVEL', '0426204743', 'http://www.isfdb.org/wiki/images/b/b2/KLLNGGRNDB1996.jpg', '\xc2\xa34.99', 201781, None, None, None), (10857, 'Christmas on a Rational Planet', 'XMASRATP1996', '1996-07-00', 515, '277', 'pb', 'NOVEL', '042620476X', 'http://www.isfdb.org/wiki/images/4/4b/XMASRATP1996.jpg', '\xc2\xa34.99', 151314, None, None, None), (76211, 'Decalog 3: Consequences', 'DCLGCNSQNC1996', '1996-07-00', 515, '308', 'pb', 'ANTHOLOGY', '0426204786', 'http://www.isfdb.org/wiki/images/1/1a/DCLGCNSQNC1996.jpg', '\xc2\xa34.99', 153620, None, None, None), (140411, 'The Scales of Injustice', 'THSCLSFNJS1996', '1996-07-00', 515, '262', 'pb', 'NOVEL', '0426204778', 'https://m.media-amazon.com/images/I/415SQ537QXL.jpg', '\xc2\xa34.99', 246213, None, None, None), (135031, 'Return of the Living Dad', 'RTRNFTHLVN1996', '1996-08-00', 515, '281', 'pb', 'NOVEL', '0426204824', 'http://www.isfdb.org/wiki/images/e/ee/RTRNFTHLVN1996.jpg', '\xc2\xa34.99', 151336, None, None, None), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(135061, 'Damaged Goods', 'DMGDGDSPFX1996', '1996-00-00', 515, '263', 'pb', 'NOVEL', '0426204832', 'http://www.isfdb.org/wiki/images/5/59/DMGDGDSPFX1996.jpg', '\xc2\xa34.99', 39061, None, None, None), (126511, 'Downtime', 'DWNTMRPJJF1996', '1996-01-00', 515, '263', 'pb', 'NOVEL', '042620462X', 'http://www.isfdb.org/wiki/images/0/06/DWNTMRPJJF1996.jpg', '\xc2\xa34.99', 31071, None, None, None), (135011, 'Just War', 'JSTWRZPQQL1996', '1996-01-00', 515, '257', 'pb', 'NOVEL', '0426204638', 'http://www.isfdb.org/wiki/images/1/11/JSTWRZPQQL1996.jpg', '\xc2\xa34.99', 151337, None, None, None), (126501, 'The Man in the Velvet Mask', 'THMNNTHVLV1996', '1996-02-00', 515, '250', 'pb', 'NOVEL', '0426204611', 'http://www.isfdb.org/wiki/images/f/fd/THMNNTHVLV1996.jpg', '\xc2\xa34.99', 31051, None, None, None), (135001, 'Warchild', 'WRCHLDDTVH1996', '1996-02-00', 515, '310', 'pb', 'NOVEL', '0426204646', 'http://www.isfdb.org/wiki/images/7/7c/WRCHLDDTVH1996.jpg', '\xc2\xa34.99', 143764, None, None, None), (126491, 'The English Way of Death', 'THNGLSHWFD1996', '1996-03-00', 515, '278', 'pb', 'NOVEL', '0426204662', 'http://www.isfdb.org/wiki/images/e/e8/THNGLSHWFD1996.jpg', '\xc2\xa34.99', 31041, None, None, None), (135051, 'Sleepy', 'SLPSDWCJHV1996', '1996-03-00', 515, '255', 'pb', 'NOVEL', '0426204654', 'http://www.isfdb.org/wiki/images/8/80/SLPSDWCJHV1996.jpg', '\xc2\xa34.99', 151319, None, None, None), (445699, 'Ace!', 'CLTKMFTPRZ1996', '1996-03-00', 515, '124', 'hc', 'NONFICTION', '185227574X', 'https://m.media-amazon.com/images/I/618Zxi4cHaL.jpg', '\xc2\xa317.99', None, None, None, None), (127641, 'Who Killed Kennedy', 'WHKLLDKNND1996', '1996-04-00', 515, '281', 'pb', 'NOVEL', '0426204670', 'https://m.media-amazon.com/images/I/51E0ulXgyuL.jpg', '\xc2\xa34.99', 32301, None, None, None), (135041, 'Death and Diplomacy', 'DTHNDDPLMC1996', '1996-04-00', 515, '280', 'pb', 'NOVEL', '0426204689', 'http://www.isfdb.org/wiki/images/4/49/DTHNDDPLMC1996.jpg', '\xc2\xa34.99', 151322, None, None, None), (135241, 'The Eye of the Giant', 'THFTHGNTMP1996', '1996-04-00', 515, '315', 'pb', 'NOVEL', '0426204697', 'http://www.isfdb.org/wiki/images/b/b1/THFTHGNTMP1996.jpg', '\xc2\xa34.99', 39111, None, None, None), (725, 'A History of the Universe', 'HSTRYUNV1996', '1996-05-00', 515, '273', 'tp', 'NONFICTION', '0426204719', 'https://m.media-amazon.com/images/I/61r1Sf1oVSL.jpg', '\xc2\xa37.99', 380632, None, None, None), (10859, 'Happy Endings', 'HPPYENDG1997', '1996-05-00', 515, '291', 'pb', 'NOVEL', '0426204700', 'http://www.isfdb.org/wiki/images/3/3c/HPPYENDG1997.jpg', '\xc2\xa34.99', 145352, None, None, None), (135231, 'The Sands of Time', 'THSNDSFTMM1996', '1996-05-00', 515, '292', 'pb', 'NOVEL', '0426204727', 'http://www.isfdb.org/wiki/images/b/b6/THSNDSFTMM1996.jpg', '\xc2\xa34.99', 39101, None, None, None), (10858, 'Godengine', 'GDENGN1996', '1996-06-00', 515, '243', 'pb', 'NOVEL', '0426204735', 'http://www.isfdb.org/wiki/images/c/c5/GDENGN1996.jpg', '\xc2\xa34.99', 171166, None, None, None), (140401, 'Killing Ground', 'KLLNGGRNDB1996', '1996-06-00', 515, '246', 'pb', 'NOVEL', '0426204743', 'http://www.isfdb.org/wiki/images/b/b2/KLLNGGRNDB1996.jpg', '\xc2\xa34.99', 201781, None, None, None), (10857, 'Christmas on a Rational Planet', 'XMASRATP1996', '1996-07-00', 515, '277', 'pb', 'NOVEL', '042620476X', 'http://www.isfdb.org/wiki/images/4/4b/XMASRATP1996.jpg', '\xc2\xa34.99', 151314, None, None, None), (76211, 'Decalog 3: Consequences', 'DCLGCNSQNC1996', '1996-07-00', 515, '308', 'pb', 'ANTHOLOGY', '0426204786', 'http://www.isfdb.org/wiki/images/1/1a/DCLGCNSQNC1996.jpg', '\xc2\xa34.99', 153620, None, None, None), (140411, 'The Scales of Injustice', 'THSCLSFNJS1996', '1996-07-00', 515, '262', 'pb', 'NOVEL', '0426204778', 'https://m.media-amazon.com/images/I/415SQ537QXL.jpg', '\xc2\xa34.99', 246213, None, None, None), (135031, 'Return of the Living Dad', 'RTRNFTHLVN1996', '1996-08-00', 515, '281', 'pb', 'NOVEL', '0426204824', 'http://www.isfdb.org/wiki/images/e/ee/RTRNFTHLVN1996.jpg', '\xc2\xa34.99', 151336, 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 = (135061, 'Damaged Goods', 'DMGDGDSPFX1996', '1996-00-00', 515, '263', 'pb', 'NOVEL', '0426204832', 'http://www.isfdb.org/wiki/images/5/59/DMGDGDSPFX1996.jpg', '\xc2\xa34.99', 39061, None, None, None), pub_authors = {725: [(21161, 'Lance Parkin', 'Parkin')], 10857: [(3259, 'Lawrence Miles', 'Miles')], 10858: [(3258, 'Craig Hinton', 'Hinton')], 10859: [(3257, 'Paul Cornell', 'Cornell')], 76211: [(16516, 'Andy Lane', 'Lane'), (3500, 'Justin Richards', 'Richards')], 126491: [(3426, 'Gareth Roberts', 'Roberts')], 126501: [(3729, "Daniel O'Mahony", "O'Mahony")], 126511: [(3711, 'Marc Platt', 'Platt')], 127631: [(3723, 'Christopher Bulis', 'Bulis')], 127641: [(2613, 'David Bishop', 'Bishop'), (11463, 'James Stevens', 'Stevens')], ...}, pub_publishers = {515: 'Doctor Who Books'}, pub_series = {}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(135061, 'Damaged Goods', 'DMGDGDSPFX1996', '1996-00-00', 515, '263', 'pb', 'NOVEL', '0426204832', 'http://www.isfdb.org/wiki/images/5/59/DMGDGDSPFX1996.jpg', '\xc2\xa34.99', 39061, None, None, None), pub_authors={725: [(21161, 'Lance Parkin', 'Parkin')], 10857: [(3259, 'Lawrence Miles', 'Miles')], 10858: [(3258, 'Craig Hinton', 'Hinton')], 10859: [(3257, 'Paul Cornell', 'Cornell')], 76211: [(16516, 'Andy Lane', 'Lane'), (3500, 'Justin Richards', 'Richards')], 126491: [(3426, 'Gareth Roberts', 'Roberts')], 126501: [(3729, "Daniel O'Mahony", "O'Mahony")], 126511: [(3711, 'Marc Platt', 'Platt')], 127631: [(3723, 'Christopher Bulis', 'Bulis')], 127641: [(2613, 'David Bishop', 'Bishop'), (11463, 'James Stevens', 'Stevens')], ...}, pub_publishers={515: 'Doctor Who Books'}, pub_series={}, 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 = (135061, 'Damaged Goods', 'DMGDGDSPFX1996', '1996-00-00', 515, '263', 'pb', 'NOVEL', '0426204832', 'http://www.isfdb.org/wiki/images/5/59/DMGDGDSPFX1996.jpg', '\xc2\xa34.99', 39061, 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=135061, displayed_value='Damaged Goods', 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 = 135061 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=135061) |
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=135061' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=135061') |
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=135061' |
/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=135061') |
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=135061' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''