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 09:11:17 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 = [(366090, 'The Dreaded Noodle-Doodles', 'THDRDDNDLD2012', '2012-01-05', 218, '176', 'ebook', 'NOVEL', '9780571272600', '', '', 277189, None, None, None), (367019, 'The Dreaded Noodle-doodles', 'THDRDDNDLB2012', '2012-01-05', 218, '144', 'unknown', 'NOVEL', '9780571272594', 'https://m.media-amazon.com/images/I/510UgTcoVSL.jpg', '\xc2\xa34.99', 278307, None, None, None), (528927, 'Pulse', 'PLSFQTXSKJ2012', '2012-01-31', 218, '', 'ebook', 'NOVEL', '9780571273973', 'https://m.media-amazon.com/images/I/41ZIZ8j3MQL.jpg', '\xc2\xa35.99', 480279, None, None, None), (403323, 'Pulse', 'PLSTHKZNCH2012', '2012-02-01', 218, '399', 'tp', 'NOVEL', '9780571273966', 'https://m.media-amazon.com/images/I/418ZoPTd8rL.jpg', '\xc2\xa36.99', 323435, None, None, None), (373990, 'The Possessions of Doctor Forrest', 'THPSSSSNSB2012', '2012-03-01', 218, '464', 'pb', 'NOVEL', '9780571241552', 'https://m.media-amazon.com/images/I/518qNXzCnIL.jpg', '\xc2\xa37.99', 286266, None, None, None), (464408, 'Cold Hand in Mine', 'CLDHNDNMNZ2012', '2012-03-15', 218, '', 'ebook', 'COLLECTION', '9780571294503', 'https://m.media-amazon.com/images/I/41PalZgqdsL.jpg', '\xc2\xa39.98', 403055, 1563, None, None), (464411, 'Lord of the Flies', 'LRDFTHFLSF2012', '2012-03-15', 218, '', 'ebook', 'NOVEL', '9780571267385', 'https://m.media-amazon.com/images/I/51nfN0MXjGL.jpg', '\xc2\xa37.99', 403058, None, None, None), (464414, 'The Unsettled Dust', 'THNSTTLDDS2012', '2012-03-15', 218, '', 'ebook', 'COLLECTION', '9780571294510', 'https://m.media-amazon.com/images/I/41QZJcaNooL.jpg', '\xc2\xa36.98', 403061, 1563, None, None), (464416, 'The Wine-Dark Sea', 'THWNDRKSQW2012', '2012-03-15', 218, '', 'ebook', 'COLLECTION', '9780571294527', 'https://m.media-amazon.com/images/I/41SZCxR1lRL.jpg', '\xc2\xa311.99', 403063, 1563, None, None), (528104, 'The Inheritors', 'THNHRTRSQD2012', '2012-03-15', 218, '', 'ebook', 'NOVEL', '9780571267484', 'https://m.media-amazon.com/images/I/51az%2BxL2zcL.jpg', '\xc2\xa37.99', 479300, None, None, None), (465008, 'The Fury', 'THFRVPQQTJ2012', '2012-04-03', 218, '', 'ebook', 'NOVEL', '9780571276172', 'https://m.media-amazon.com/images/I/418PGpMQK1L.jpg', '\xc2\xa35.99', 403680, None, None, None), (378710, 'The Fury', 'THFRPBLVZK2012', '2012-04-05', 218, '544', 'pb', 'NOVEL', '9780571276165', 'https://m.media-amazon.com/images/I/41Xjc1JrYKL.jpg', '\xc2\xa37.99', 291659, None, None, None), (465009, 'Galaxies Like Grains of Sand', 'GLXSLKGRNS2012', '2012-04-05', 218, '', 'ebook', 'COLLECTION', '9780571286898', 'https://m.media-amazon.com/images/I/41--8K%2BDBhL.jpg', '\xc2\xa310.99', 403681, 1563, None, None), (386879, 'The Glimpse', 'THGLMPSXKK2012', '2012-06-01', 218, '432', 'tp', 'NOVEL', '9780571280537', 'https://m.media-amazon.com/images/I/41wH8CDZclL.jpg', '\xc2\xa37.99', 300918, None, None, None), (466216, 'The Glimpse', 'THGLMPSVBJ2012', '2012-06-05', 218, '', 'ebook', 'NOVEL', '9780571280544', 'https://m.media-amazon.com/images/I/41KfHd6MYCL.jpg', '\xc2\xa36.98', 404962, None, None, None), (466219, 'The Promised One', 'THPRMSDNJL2012', '2012-06-21', 218, '', 'ebook', 'NOVEL', '9780571297146', 'https://m.media-amazon.com/images/I/51X8kEZud5L.jpg', '\xc2\xa35.18', 404965, None, None, None), (466221, 'The Valley of the Ancients', 'THVLLFTHNC2012', '2012-06-21', 218, '', 'ebook', 'NOVEL', '9780571297139', 'https://m.media-amazon.com/images/I/51rzoy8J6NL.jpg', '\xc2\xa34.99', 404967, None, None, None), (915320, 'Tarzan the Jungle Warrior', 'TRZNTHJNGL2012', '2012-08-28', 218, '240', 'pb', 'NOVEL', '9780571273539', 'https://images-na.ssl-images-amazon.com/images/I/51tJKM09J8L.jpg', None, 1057851, None, None, None), (393794, 'The Windvale Sprites', 'THWNDVLSPR2012', '2012-09-06', 218, '208', 'unknown', 'NOVEL', '9780571240722', 'https://m.media-amazon.com/images/I/51Oomx4%2BZ-L.jpg', '\xc2\xa36.99', 309304, None, None, None), (468033, 'Lord of the Flies: New Educational Edition', 'LRDFTHFLSN2012', '2012-09-20', 218, '', 'ebook', 'NOVEL', '9780571290581', 'https://m.media-amazon.com/images/I/51NjXPoPKtL.jpg', '\xc2\xa37.99', 406905, None, None, None), ...] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(366090, 'The Dreaded Noodle-Doodles', 'THDRDDNDLD2012', '2012-01-05', 218, '176', 'ebook', 'NOVEL', '9780571272600', '', '', 277189, None, None, None), (367019, 'The Dreaded Noodle-doodles', 'THDRDDNDLB2012', '2012-01-05', 218, '144', 'unknown', 'NOVEL', '9780571272594', 'https://m.media-amazon.com/images/I/510UgTcoVSL.jpg', '\xc2\xa34.99', 278307, None, None, None), (528927, 'Pulse', 'PLSFQTXSKJ2012', '2012-01-31', 218, '', 'ebook', 'NOVEL', '9780571273973', 'https://m.media-amazon.com/images/I/41ZIZ8j3MQL.jpg', '\xc2\xa35.99', 480279, None, None, None), (403323, 'Pulse', 'PLSTHKZNCH2012', '2012-02-01', 218, '399', 'tp', 'NOVEL', '9780571273966', 'https://m.media-amazon.com/images/I/418ZoPTd8rL.jpg', '\xc2\xa36.99', 323435, None, None, None), (373990, 'The Possessions of Doctor Forrest', 'THPSSSSNSB2012', '2012-03-01', 218, '464', 'pb', 'NOVEL', '9780571241552', 'https://m.media-amazon.com/images/I/518qNXzCnIL.jpg', '\xc2\xa37.99', 286266, None, None, None), (464408, 'Cold Hand in Mine', 'CLDHNDNMNZ2012', '2012-03-15', 218, '', 'ebook', 'COLLECTION', '9780571294503', 'https://m.media-amazon.com/images/I/41PalZgqdsL.jpg', '\xc2\xa39.98', 403055, 1563, None, None), (464411, 'Lord of the Flies', 'LRDFTHFLSF2012', '2012-03-15', 218, '', 'ebook', 'NOVEL', '9780571267385', 'https://m.media-amazon.com/images/I/51nfN0MXjGL.jpg', '\xc2\xa37.99', 403058, None, None, None), (464414, 'The Unsettled Dust', 'THNSTTLDDS2012', '2012-03-15', 218, '', 'ebook', 'COLLECTION', '9780571294510', 'https://m.media-amazon.com/images/I/41QZJcaNooL.jpg', '\xc2\xa36.98', 403061, 1563, None, None), (464416, 'The Wine-Dark Sea', 'THWNDRKSQW2012', '2012-03-15', 218, '', 'ebook', 'COLLECTION', '9780571294527', 'https://m.media-amazon.com/images/I/41SZCxR1lRL.jpg', '\xc2\xa311.99', 403063, 1563, None, None), (528104, 'The Inheritors', 'THNHRTRSQD2012', '2012-03-15', 218, '', 'ebook', 'NOVEL', '9780571267484', 'https://m.media-amazon.com/images/I/51az%2BxL2zcL.jpg', '\xc2\xa37.99', 479300, None, None, None), (465008, 'The Fury', 'THFRVPQQTJ2012', '2012-04-03', 218, '', 'ebook', 'NOVEL', '9780571276172', 'https://m.media-amazon.com/images/I/418PGpMQK1L.jpg', '\xc2\xa35.99', 403680, None, None, None), (378710, 'The Fury', 'THFRPBLVZK2012', '2012-04-05', 218, '544', 'pb', 'NOVEL', '9780571276165', 'https://m.media-amazon.com/images/I/41Xjc1JrYKL.jpg', '\xc2\xa37.99', 291659, None, None, None), (465009, 'Galaxies Like Grains of Sand', 'GLXSLKGRNS2012', '2012-04-05', 218, '', 'ebook', 'COLLECTION', '9780571286898', 'https://m.media-amazon.com/images/I/41--8K%2BDBhL.jpg', '\xc2\xa310.99', 403681, 1563, None, None), (386879, 'The Glimpse', 'THGLMPSXKK2012', '2012-06-01', 218, '432', 'tp', 'NOVEL', '9780571280537', 'https://m.media-amazon.com/images/I/41wH8CDZclL.jpg', '\xc2\xa37.99', 300918, None, None, None), (466216, 'The Glimpse', 'THGLMPSVBJ2012', '2012-06-05', 218, '', 'ebook', 'NOVEL', '9780571280544', 'https://m.media-amazon.com/images/I/41KfHd6MYCL.jpg', '\xc2\xa36.98', 404962, None, None, None), (466219, 'The Promised One', 'THPRMSDNJL2012', '2012-06-21', 218, '', 'ebook', 'NOVEL', '9780571297146', 'https://m.media-amazon.com/images/I/51X8kEZud5L.jpg', '\xc2\xa35.18', 404965, None, None, None), (466221, 'The Valley of the Ancients', 'THVLLFTHNC2012', '2012-06-21', 218, '', 'ebook', 'NOVEL', '9780571297139', 'https://m.media-amazon.com/images/I/51rzoy8J6NL.jpg', '\xc2\xa34.99', 404967, None, None, None), (915320, 'Tarzan the Jungle Warrior', 'TRZNTHJNGL2012', '2012-08-28', 218, '240', 'pb', 'NOVEL', '9780571273539', 'https://images-na.ssl-images-amazon.com/images/I/51tJKM09J8L.jpg', None, 1057851, None, None, None), (393794, 'The Windvale Sprites', 'THWNDVLSPR2012', '2012-09-06', 218, '208', 'unknown', 'NOVEL', '9780571240722', 'https://m.media-amazon.com/images/I/51Oomx4%2BZ-L.jpg', '\xc2\xa36.99', 309304, None, None, None), (468033, 'Lord of the Flies: New Educational Edition', 'LRDFTHFLSN2012', '2012-09-20', 218, '', 'ebook', 'NOVEL', '9780571290581', 'https://m.media-amazon.com/images/I/51NjXPoPKtL.jpg', '\xc2\xa37.99', 406905, 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 = (366090, 'The Dreaded Noodle-Doodles', 'THDRDDNDLD2012', '2012-01-05', 218, '176', 'ebook', 'NOVEL', '9780571272600', '', '', 277189, None, None, None), pub_authors = {366090: [(160528, 'Karen McCombie', 'McCombie')], 367019: [(160528, 'Karen McCombie', 'McCombie')], 373990: [(167605, 'Richard T. Kelly', 'Kelly')], 378710: [(136535, 'Alexander Gordon Smith', 'Smith')], 386879: [(174433, 'Claire Merle', 'Merle')], 393794: [(162088, 'Mackenzie Crook', 'Crook')], 397230: [(179082, 'Gennifer Albin', 'Albin')], 403323: [(137894, 'Tricia Rayburn', 'Rayburn')], 464408: [(1470, 'Robert Aickman', 'Aickman')], 464411: [(785, 'William Golding', 'Golding')], ...}, pub_publishers = {218: 'Faber and Faber'}, pub_series = {1563: 'Faber Finds'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(366090, 'The Dreaded Noodle-Doodles', 'THDRDDNDLD2012', '2012-01-05', 218, '176', 'ebook', 'NOVEL', '9780571272600', '', '', 277189, None, None, None), pub_authors={366090: [(160528, 'Karen McCombie', 'McCombie')], 367019: [(160528, 'Karen McCombie', 'McCombie')], 373990: [(167605, 'Richard T. Kelly', 'Kelly')], 378710: [(136535, 'Alexander Gordon Smith', 'Smith')], 386879: [(174433, 'Claire Merle', 'Merle')], 393794: [(162088, 'Mackenzie Crook', 'Crook')], 397230: [(179082, 'Gennifer Albin', 'Albin')], 403323: [(137894, 'Tricia Rayburn', 'Rayburn')], 464408: [(1470, 'Robert Aickman', 'Aickman')], 464411: [(785, 'William Golding', 'Golding')], ...}, pub_publishers={218: 'Faber and Faber'}, pub_series={1563: 'Faber Finds'}, 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 = (366090, 'The Dreaded Noodle-Doodles', 'THDRDDNDLD2012', '2012-01-05', 218, '176', 'ebook', 'NOVEL', '9780571272600', '', '', 277189, 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=366090, displayed_value='The Dreaded Noodle-Doodles', 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 = 366090 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=366090) |
| 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=366090' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=366090') |
| 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=366090' |
| /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=366090') |
| 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=366090' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''