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 Wed May 1 17:55:43 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 = [(543881, 'Twilight', 'TWLGHTXMHF0000', '2016-00-00', 500, '316', 'pb', 'NOVEL', '9781407231006', 'https://m.media-amazon.com/images/I/41scwmcciLL.jpg', '\xc2\xa36.99', 497978, None, None, None), (686843, 'Glass Sword', 'GLSSSWRDKF2016', '2016-00-00', 500, '444', 'tp', 'NOVEL', '9781409159353', 'https://m.media-amazon.com/images/I/41LhXaWpcuL.jpg', '\xc2\xa310.99', 733297, None, None, None), (548966, 'The Great Zoo of China', 'THGRTZFCHN2016', '2016-01-14', 500, '469', 'tp', 'NOVEL', '9781409155584', 'https://images-na.ssl-images-amazon.com/images/I/51qHx6I2lsL.jpg', '\xc2\xa37.99', 504455, None, None, None), (570049, 'Cruel Crown', 'CRLCRWNTGV2016', '2016-01-21', 500, '', 'ebook', 'COLLECTION', '9781409165347', 'https://m.media-amazon.com/images/I/51FYcl0HIuL.jpg', '\xc2\xa33.99', 539548, None, None, None), (948375, 'The Maker of Swans', 'THMKRFSWNC2016', '2016-02-01', 500, None, 'digital audio download', 'NOVEL', '9781409161196', 'https://m.media-amazon.com/images/I/61PQI-qFPFL.jpg', '\xc2\xa318.99', 1108771, None, None, None), (553744, 'Glass Sword', 'GLSSSWRDVN2016', '2016-02-11', 500, '440', 'tp', 'NOVEL', '9781409159353', 'https://m.media-amazon.com/images/I/41LhXaWpcuL.jpg', '\xc2\xa310.99', 510730, None, None, None), (561382, 'Glass Sword', 'GLSSSWRDLS2016', '2016-02-11', 500, '', 'ebook', 'NOVEL', '9781409150756', 'https://m.media-amazon.com/images/I/41FcDi1AcOL.jpg', '\xc2\xa35.99', 524857, None, None, None), (593570, 'Jonathan Dark or The Evidence Of Ghosts', 'JNTHNDRKRT2016', '2016-02-25', 500, '272', 'tp', 'NOVEL', '9781409144557', 'https://m.media-amazon.com/images/I/51fa9IK3ihL.jpg', '\xc2\xa312.99', 577974, None, None, None), (593571, 'Jonathan Dark or The Evidence Of Ghosts', 'JNTHNDRKRB2016', '2016-02-25', 500, '', 'ebook', 'NOVEL', '9781409144564', 'https://m.media-amazon.com/images/I/51X4VuVn6RL.jpg', '\xc2\xa36.99', 577975, None, None, None), (559373, 'Cruel Crown', 'CRLCRWNMTT2016', '2016-04-21', 500, '208', 'pb', 'COLLECTION', '9781409165330', 'https://m.media-amazon.com/images/I/51Wx0n%2BLxbL.jpg', '\xc2\xa35.99', 521614, None, None, None), (570106, "The Hummingbird's Cage", 'THHMMNGBRD2016', '2016-04-21', 500, '', 'ebook', 'NOVEL', '9781409166498', 'https://m.media-amazon.com/images/I/51BfuO749hL.jpg', '\xc2\xa34.99', 539609, None, None, None), (571988, 'The City of Mirrors', 'THCTFMRRRD2016', '2016-05-24', 500, '624', 'tp', 'NOVEL', '9780752897912', 'https://m.media-amazon.com/images/I/51MmDhAVI7L.jpg', '\xc2\xa313.99', 542309, None, None, None), (572862, 'The City of Mirrors', 'THCTFMRRRG2016', '2016-05-24', 500, '', 'ebook', 'NOVEL', '9781409151005', 'https://m.media-amazon.com/images/I/51RfvsYNkbL.jpg', '\xc2\xa39.99', 543475, None, None, None), (568143, 'The City of Mirrors', 'THCTFMRRRC2016', '2016-06-16', 500, '624', 'hc', 'NOVEL', '9780752897899', 'https://m.media-amazon.com/images/I/510KMQJTbsL.jpg', '\xc2\xa320.00', 536277, None, None, None), (572057, 'Glass Sword', 'GLSSSWRDNH2016', '2016-07-21', 500, '464', 'pb', 'NOVEL', '9781409150749', 'https://m.media-amazon.com/images/I/413rDOjFNyL.jpg', '\xc2\xa37.99', 542400, None, None, None), (575665, "The Hummingbird's Cage", 'THHMMNGBRB2016', '2016-08-25', 500, '368', 'tp', 'NOVEL', '9781409166481', 'https://m.media-amazon.com/images/I/413wu6T-ZtL.jpg', '\xc2\xa37.99', 547515, None, None, None), (579407, 'The Damned', 'THDMNDSWZB2016', '2016-09-08', 500, '304', 'tp', 'NOVEL', '9781409149187', 'https://m.media-amazon.com/images/I/51H3M4tj56L.jpg', '\xc2\xa38.99', 553381, None, None, None), (585609, 'Thin Air', 'THNRRTVFCZ2016', '2016-10-06', 500, '240', 'hc', 'NOVEL', '9781409163343', 'https://m.media-amazon.com/images/I/51zxgvquB8L.jpg', '\xc2\xa312.99', 563551, None, None, None), (585610, 'Thin Air', 'THNRZSWGLS2016', '2016-10-06', 500, '240', 'tp', 'NOVEL', '9781409163350', 'https://m.media-amazon.com/images/I/51ZoC8GvRDL.jpg', '\xc2\xa312.99', 563552, None, None, None), (592303, 'Thin Air', 'THNRZKCBMV2016', '2016-10-06', 500, '', 'ebook', 'NOVEL', '9781409163374', 'https://m.media-amazon.com/images/I/51Vqg3CtWSL.jpg', '\xc2\xa36.99', 575812, None, None, None), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(543881, 'Twilight', 'TWLGHTXMHF0000', '2016-00-00', 500, '316', 'pb', 'NOVEL', '9781407231006', 'https://m.media-amazon.com/images/I/41scwmcciLL.jpg', '\xc2\xa36.99', 497978, None, None, None), (686843, 'Glass Sword', 'GLSSSWRDKF2016', '2016-00-00', 500, '444', 'tp', 'NOVEL', '9781409159353', 'https://m.media-amazon.com/images/I/41LhXaWpcuL.jpg', '\xc2\xa310.99', 733297, None, None, None), (548966, 'The Great Zoo of China', 'THGRTZFCHN2016', '2016-01-14', 500, '469', 'tp', 'NOVEL', '9781409155584', 'https://images-na.ssl-images-amazon.com/images/I/51qHx6I2lsL.jpg', '\xc2\xa37.99', 504455, None, None, None), (570049, 'Cruel Crown', 'CRLCRWNTGV2016', '2016-01-21', 500, '', 'ebook', 'COLLECTION', '9781409165347', 'https://m.media-amazon.com/images/I/51FYcl0HIuL.jpg', '\xc2\xa33.99', 539548, None, None, None), (948375, 'The Maker of Swans', 'THMKRFSWNC2016', '2016-02-01', 500, None, 'digital audio download', 'NOVEL', '9781409161196', 'https://m.media-amazon.com/images/I/61PQI-qFPFL.jpg', '\xc2\xa318.99', 1108771, None, None, None), (553744, 'Glass Sword', 'GLSSSWRDVN2016', '2016-02-11', 500, '440', 'tp', 'NOVEL', '9781409159353', 'https://m.media-amazon.com/images/I/41LhXaWpcuL.jpg', '\xc2\xa310.99', 510730, None, None, None), (561382, 'Glass Sword', 'GLSSSWRDLS2016', '2016-02-11', 500, '', 'ebook', 'NOVEL', '9781409150756', 'https://m.media-amazon.com/images/I/41FcDi1AcOL.jpg', '\xc2\xa35.99', 524857, None, None, None), (593570, 'Jonathan Dark or The Evidence Of Ghosts', 'JNTHNDRKRT2016', '2016-02-25', 500, '272', 'tp', 'NOVEL', '9781409144557', 'https://m.media-amazon.com/images/I/51fa9IK3ihL.jpg', '\xc2\xa312.99', 577974, None, None, None), (593571, 'Jonathan Dark or The Evidence Of Ghosts', 'JNTHNDRKRB2016', '2016-02-25', 500, '', 'ebook', 'NOVEL', '9781409144564', 'https://m.media-amazon.com/images/I/51X4VuVn6RL.jpg', '\xc2\xa36.99', 577975, None, None, None), (559373, 'Cruel Crown', 'CRLCRWNMTT2016', '2016-04-21', 500, '208', 'pb', 'COLLECTION', '9781409165330', 'https://m.media-amazon.com/images/I/51Wx0n%2BLxbL.jpg', '\xc2\xa35.99', 521614, None, None, None), (570106, "The Hummingbird's Cage", 'THHMMNGBRD2016', '2016-04-21', 500, '', 'ebook', 'NOVEL', '9781409166498', 'https://m.media-amazon.com/images/I/51BfuO749hL.jpg', '\xc2\xa34.99', 539609, None, None, None), (571988, 'The City of Mirrors', 'THCTFMRRRD2016', '2016-05-24', 500, '624', 'tp', 'NOVEL', '9780752897912', 'https://m.media-amazon.com/images/I/51MmDhAVI7L.jpg', '\xc2\xa313.99', 542309, None, None, None), (572862, 'The City of Mirrors', 'THCTFMRRRG2016', '2016-05-24', 500, '', 'ebook', 'NOVEL', '9781409151005', 'https://m.media-amazon.com/images/I/51RfvsYNkbL.jpg', '\xc2\xa39.99', 543475, None, None, None), (568143, 'The City of Mirrors', 'THCTFMRRRC2016', '2016-06-16', 500, '624', 'hc', 'NOVEL', '9780752897899', 'https://m.media-amazon.com/images/I/510KMQJTbsL.jpg', '\xc2\xa320.00', 536277, None, None, None), (572057, 'Glass Sword', 'GLSSSWRDNH2016', '2016-07-21', 500, '464', 'pb', 'NOVEL', '9781409150749', 'https://m.media-amazon.com/images/I/413rDOjFNyL.jpg', '\xc2\xa37.99', 542400, None, None, None), (575665, "The Hummingbird's Cage", 'THHMMNGBRB2016', '2016-08-25', 500, '368', 'tp', 'NOVEL', '9781409166481', 'https://m.media-amazon.com/images/I/413wu6T-ZtL.jpg', '\xc2\xa37.99', 547515, None, None, None), (579407, 'The Damned', 'THDMNDSWZB2016', '2016-09-08', 500, '304', 'tp', 'NOVEL', '9781409149187', 'https://m.media-amazon.com/images/I/51H3M4tj56L.jpg', '\xc2\xa38.99', 553381, None, None, None), (585609, 'Thin Air', 'THNRRTVFCZ2016', '2016-10-06', 500, '240', 'hc', 'NOVEL', '9781409163343', 'https://m.media-amazon.com/images/I/51zxgvquB8L.jpg', '\xc2\xa312.99', 563551, None, None, None), (585610, 'Thin Air', 'THNRZSWGLS2016', '2016-10-06', 500, '240', 'tp', 'NOVEL', '9781409163350', 'https://m.media-amazon.com/images/I/51ZoC8GvRDL.jpg', '\xc2\xa312.99', 563552, None, None, None), (592303, 'Thin Air', 'THNRZKCBMV2016', '2016-10-06', 500, '', 'ebook', 'NOVEL', '9781409163374', 'https://m.media-amazon.com/images/I/51Vqg3CtWSL.jpg', '\xc2\xa36.99', 575812, 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 = (543881, 'Twilight', 'TWLGHTXMHF0000', '2016-00-00', 500, '316', 'pb', 'NOVEL', '9781407231006', 'https://m.media-amazon.com/images/I/41scwmcciLL.jpg', '\xc2\xa36.99', 497978, None, None, None), pub_authors = {543881: [(2910, 'Peter James', 'James')], 548966: [(32912, 'Matthew Reilly', 'Reilly')], 553744: [(211262, 'Victoria Aveyard', 'Aveyard')], 559373: [(211262, 'Victoria Aveyard', 'Aveyard')], 561382: [(211262, 'Victoria Aveyard', 'Aveyard')], 568143: [(136464, 'Justin Cronin', 'Cronin')], 570049: [(211262, 'Victoria Aveyard', 'Aveyard')], 570106: [(215613, 'Tamara Dietrich', 'Dietrich')], 571988: [(136464, 'Justin Cronin', 'Cronin')], 572057: [(211262, 'Victoria Aveyard', 'Aveyard')], ...}, pub_publishers = {500: 'Orion'}, 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=(543881, 'Twilight', 'TWLGHTXMHF0000', '2016-00-00', 500, '316', 'pb', 'NOVEL', '9781407231006', 'https://m.media-amazon.com/images/I/41scwmcciLL.jpg', '\xc2\xa36.99', 497978, None, None, None), pub_authors={543881: [(2910, 'Peter James', 'James')], 548966: [(32912, 'Matthew Reilly', 'Reilly')], 553744: [(211262, 'Victoria Aveyard', 'Aveyard')], 559373: [(211262, 'Victoria Aveyard', 'Aveyard')], 561382: [(211262, 'Victoria Aveyard', 'Aveyard')], 568143: [(136464, 'Justin Cronin', 'Cronin')], 570049: [(211262, 'Victoria Aveyard', 'Aveyard')], 570106: [(215613, 'Tamara Dietrich', 'Dietrich')], 571988: [(136464, 'Justin Cronin', 'Cronin')], 572057: [(211262, 'Victoria Aveyard', 'Aveyard')], ...}, pub_publishers={500: 'Orion'}, 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 = (543881, 'Twilight', 'TWLGHTXMHF0000', '2016-00-00', 500, '316', 'pb', 'NOVEL', '9781407231006', 'https://m.media-amazon.com/images/I/41scwmcciLL.jpg', '\xc2\xa36.99', 497978, 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=543881, displayed_value='Twilight', 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 = 543881 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=543881) |
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=543881' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=543881') |
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=543881' |
/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=543881') |
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=543881' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''