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 11:34:01 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 = [(563445, 'Zerfleischt', 'ZRFLSCHTKV2012', '2012-02-00', 29616, '411', 'pb', 'NOVEL', '9783865521378', 'http://www.isfdb.org/wiki/images/e/e3/ZRFLSCHTKV2012.jpg', '\xe2\x82\xac13.95', 528440, 5060, '1537', None), (563446, 'Red Sky', 'RDSKHNWDNQ2012', '2012-03-00', 29616, '269', 'pb', 'NOVEL', '9783865521460', 'http://www.isfdb.org/wiki/images/d/d6/RDSKHNWDNQ2012.jpg', '\xe2\x82\xac13.95', 528441, 5060, '1538', None), (563447, 'Verkommen', 'VRKMMNXQPV2012', '2012-03-00', 29616, '379', 'pb', 'NOVEL', '9783865521408', 'http://www.isfdb.org/wiki/images/b/b0/VRKMMNXQPV2012.jpg', '\xe2\x82\xac13.95', 528442, 5060, '1539', None), (837708, 'Zerfleischt', 'ZRFLSCHTKL2012', '2012-03-07', 29616, None, 'ebook', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/e/e3/ZRFLSCHTKV2012.jpg', '\xe2\x82\xac4.99', 952858, None, None, None), (779119, 'Red Sky', 'RDSKZKSSNN2012', '2012-03-12', 29616, '', 'ebook', 'NOVEL', '9783865521699', 'https://m.media-amazon.com/images/I/51dpuneektL.jpg', '\xe2\x82\xac4.99', 879403, None, None, None), (563613, 'Seelenfresser', 'SLNFRSSRBG2012', '2012-04-00', 29616, '345', 'pb', 'NOVEL', '9783865521415', 'http://www.isfdb.org/wiki/images/7/7f/SLNFRSSRBG2012.jpg', '\xe2\x82\xac13.95', 528701, 5060, '1541', None), (564168, 'Das Motel', 'DSMTLRGZXX2012', '2012-04-00', 29616, '379', 'pb', 'NOVEL', '9783865521477', 'http://www.isfdb.org/wiki/images/d/d5/DSMTLRGZXX2012.jpg', '\xe2\x82\xac13.95', 529546, 5152, '6', None), (563418, 'Licht aus!', 'LCHTSCQWJW2012', '2012-05-00', 29616, '271', 'pb', 'NOVEL', '9783865521668', 'http://www.isfdb.org/wiki/images/7/73/LCHTSCQWJW2012.jpg', '\xe2\x82\xac12.80', 528387, 5060, '1550', None), (563723, 'Der Baby-Jesus-Anal-Plug', 'DRBBJSSNLP2012', '2012-05-00', 29616, '214', 'hc', 'COLLECTION', '9783865521231', 'http://www.isfdb.org/wiki/images/c/ce/DRBBJSSNLP2012.jpg', '\xe2\x82\xac14.80', 528913, 5147, None, None), (563726, 'H. P. Lovecraft: Eine Biografie', 'HPLVCRFTNB2012', '2012-05-00', 29616, '637', 'tp', 'NONFICTION', '9783865521651', 'https://m.media-amazon.com/images/I/61EDeYVfbYL.jpg', '\xe2\x82\xac29.80', 528929, None, None, None), (564167, 'Todesgeil', 'TDSGLBMBGJ2012', '2012-05-00', 29616, '347', 'pb', 'NOVEL', '9783865521347', 'http://www.isfdb.org/wiki/images/7/7b/TDSGLBMBGJ2012.jpg', '\xe2\x82\xac13.95', 529545, 5152, '5', None), (862878, 'Maden', 'MDNJMVBCSL2012', '2012-05-10', 29616, None, 'ebook', 'CHAPBOOK', None, 'https://m.media-amazon.com/images/I/51IPD-40gdL.jpg', '$0.99', 986194, None, None, None), (563614, 'Haus der b\xc3\xb6sen Lust', 'HSDRBSNLST2012', '2012-06-00', 29616, '399', 'pb', 'NOVEL', '9783865521491', 'http://www.isfdb.org/wiki/images/e/eb/HSDRBSNLST2012.jpg', '\xe2\x82\xac13.95', 528702, 5060, '1542', None), (558850, 'Die Heimsuchung', 'DHMSCHNGVG2012', '2012-07-00', 29616, '384', 'hc', 'NOVEL', '9783865521439', 'http://www.isfdb.org/wiki/images/5/54/DHMSCHNGVG2012.jpg', '\xe2\x82\xac26.80', 520223, 4853, '2629', None), (620341, 'Verseucht', 'VRSCHTNGPJ2012', '2012-07-23', 29616, None, 'ebook', 'NOVEL', '9783865522030', 'http://www.isfdb.org/wiki/images/4/48/VRSCHTLVWL2012.jpg', '\xe2\x82\xac4.99', 623156, 6566, '1545', None), (518147, 'Bighead', 'BGHDWZKFMS2012', '2012-08-00', 29616, '351', 'pb', 'NOVEL', '9783865521613', 'http://www.isfdb.org/wiki/images/1/1e/BGHDWZKFMS2012.jpg', '\xe2\x82\xac13.95', 467925, 5060, '1544', None), (558842, 'Geschichten aus dem Cthulhu-Mythos', 'GSCHCHTNSD2012', '2012-08-00', 29616, '333+[3]', 'hc', 'COLLECTION', '9783865521217', 'http://www.isfdb.org/wiki/images/5/51/GSCHCHTNSD2012.jpg', '\xe2\x82\xac28.00', 520184, 4853, '2628', None), (563618, 'Die S\xc3\xbcnder', 'DSNDRQZJZV2012', '2012-08-00', 29616, '395', 'pb', 'COLLECTION', '9783865521484', 'http://www.isfdb.org/wiki/images/f/fc/DSNDRQZJZV2012.jpg', '\xe2\x82\xac13.95', 528706, 5060, '1543', None), (563619, 'Verseucht', 'VRSCHTLVWL2012', '2012-08-00', 29616, '447', 'pb', 'NOVEL', '9783865520999', 'http://www.isfdb.org/wiki/images/4/48/VRSCHTLVWL2012.jpg', '\xe2\x82\xac13.95', 528707, 5060, '1545', None), (557609, 'Tote erinnern sich', 'TTRNNRNSCH2012', '2012-09-00', 29616, '346+[4]', 'hc', 'COLLECTION', '9783865520906', 'http://www.isfdb.org/wiki/images/f/fc/TTRNNRNSCH2012.jpg', '\xe2\x82\xac28.00', 517349, 4853, '2627', None), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(563445, 'Zerfleischt', 'ZRFLSCHTKV2012', '2012-02-00', 29616, '411', 'pb', 'NOVEL', '9783865521378', 'http://www.isfdb.org/wiki/images/e/e3/ZRFLSCHTKV2012.jpg', '\xe2\x82\xac13.95', 528440, 5060, '1537', None), (563446, 'Red Sky', 'RDSKHNWDNQ2012', '2012-03-00', 29616, '269', 'pb', 'NOVEL', '9783865521460', 'http://www.isfdb.org/wiki/images/d/d6/RDSKHNWDNQ2012.jpg', '\xe2\x82\xac13.95', 528441, 5060, '1538', None), (563447, 'Verkommen', 'VRKMMNXQPV2012', '2012-03-00', 29616, '379', 'pb', 'NOVEL', '9783865521408', 'http://www.isfdb.org/wiki/images/b/b0/VRKMMNXQPV2012.jpg', '\xe2\x82\xac13.95', 528442, 5060, '1539', None), (837708, 'Zerfleischt', 'ZRFLSCHTKL2012', '2012-03-07', 29616, None, 'ebook', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/e/e3/ZRFLSCHTKV2012.jpg', '\xe2\x82\xac4.99', 952858, None, None, None), (779119, 'Red Sky', 'RDSKZKSSNN2012', '2012-03-12', 29616, '', 'ebook', 'NOVEL', '9783865521699', 'https://m.media-amazon.com/images/I/51dpuneektL.jpg', '\xe2\x82\xac4.99', 879403, None, None, None), (563613, 'Seelenfresser', 'SLNFRSSRBG2012', '2012-04-00', 29616, '345', 'pb', 'NOVEL', '9783865521415', 'http://www.isfdb.org/wiki/images/7/7f/SLNFRSSRBG2012.jpg', '\xe2\x82\xac13.95', 528701, 5060, '1541', None), (564168, 'Das Motel', 'DSMTLRGZXX2012', '2012-04-00', 29616, '379', 'pb', 'NOVEL', '9783865521477', 'http://www.isfdb.org/wiki/images/d/d5/DSMTLRGZXX2012.jpg', '\xe2\x82\xac13.95', 529546, 5152, '6', None), (563418, 'Licht aus!', 'LCHTSCQWJW2012', '2012-05-00', 29616, '271', 'pb', 'NOVEL', '9783865521668', 'http://www.isfdb.org/wiki/images/7/73/LCHTSCQWJW2012.jpg', '\xe2\x82\xac12.80', 528387, 5060, '1550', None), (563723, 'Der Baby-Jesus-Anal-Plug', 'DRBBJSSNLP2012', '2012-05-00', 29616, '214', 'hc', 'COLLECTION', '9783865521231', 'http://www.isfdb.org/wiki/images/c/ce/DRBBJSSNLP2012.jpg', '\xe2\x82\xac14.80', 528913, 5147, None, None), (563726, 'H. P. Lovecraft: Eine Biografie', 'HPLVCRFTNB2012', '2012-05-00', 29616, '637', 'tp', 'NONFICTION', '9783865521651', 'https://m.media-amazon.com/images/I/61EDeYVfbYL.jpg', '\xe2\x82\xac29.80', 528929, None, None, None), (564167, 'Todesgeil', 'TDSGLBMBGJ2012', '2012-05-00', 29616, '347', 'pb', 'NOVEL', '9783865521347', 'http://www.isfdb.org/wiki/images/7/7b/TDSGLBMBGJ2012.jpg', '\xe2\x82\xac13.95', 529545, 5152, '5', None), (862878, 'Maden', 'MDNJMVBCSL2012', '2012-05-10', 29616, None, 'ebook', 'CHAPBOOK', None, 'https://m.media-amazon.com/images/I/51IPD-40gdL.jpg', '$0.99', 986194, None, None, None), (563614, 'Haus der b\xc3\xb6sen Lust', 'HSDRBSNLST2012', '2012-06-00', 29616, '399', 'pb', 'NOVEL', '9783865521491', 'http://www.isfdb.org/wiki/images/e/eb/HSDRBSNLST2012.jpg', '\xe2\x82\xac13.95', 528702, 5060, '1542', None), (558850, 'Die Heimsuchung', 'DHMSCHNGVG2012', '2012-07-00', 29616, '384', 'hc', 'NOVEL', '9783865521439', 'http://www.isfdb.org/wiki/images/5/54/DHMSCHNGVG2012.jpg', '\xe2\x82\xac26.80', 520223, 4853, '2629', None), (620341, 'Verseucht', 'VRSCHTNGPJ2012', '2012-07-23', 29616, None, 'ebook', 'NOVEL', '9783865522030', 'http://www.isfdb.org/wiki/images/4/48/VRSCHTLVWL2012.jpg', '\xe2\x82\xac4.99', 623156, 6566, '1545', None), (518147, 'Bighead', 'BGHDWZKFMS2012', '2012-08-00', 29616, '351', 'pb', 'NOVEL', '9783865521613', 'http://www.isfdb.org/wiki/images/1/1e/BGHDWZKFMS2012.jpg', '\xe2\x82\xac13.95', 467925, 5060, '1544', None), (558842, 'Geschichten aus dem Cthulhu-Mythos', 'GSCHCHTNSD2012', '2012-08-00', 29616, '333+[3]', 'hc', 'COLLECTION', '9783865521217', 'http://www.isfdb.org/wiki/images/5/51/GSCHCHTNSD2012.jpg', '\xe2\x82\xac28.00', 520184, 4853, '2628', None), (563618, 'Die S\xc3\xbcnder', 'DSNDRQZJZV2012', '2012-08-00', 29616, '395', 'pb', 'COLLECTION', '9783865521484', 'http://www.isfdb.org/wiki/images/f/fc/DSNDRQZJZV2012.jpg', '\xe2\x82\xac13.95', 528706, 5060, '1543', None), (563619, 'Verseucht', 'VRSCHTLVWL2012', '2012-08-00', 29616, '447', 'pb', 'NOVEL', '9783865520999', 'http://www.isfdb.org/wiki/images/4/48/VRSCHTLVWL2012.jpg', '\xe2\x82\xac13.95', 528707, 5060, '1545', None), (557609, 'Tote erinnern sich', 'TTRNNRNSCH2012', '2012-09-00', 29616, '346+[4]', 'hc', 'COLLECTION', '9783865520906', 'http://www.isfdb.org/wiki/images/f/fc/TTRNNRNSCH2012.jpg', '\xe2\x82\xac28.00', 517349, 4853, '2627', 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 = (563445, 'Zerfleischt', 'ZRFLSCHTKV2012', '2012-02-00', 29616, '411', 'pb', 'NOVEL', '9783865521378', 'http://www.isfdb.org/wiki/images/e/e3/ZRFLSCHTKV2012.jpg', '\xe2\x82\xac13.95', 528440, 5060, '1537', None), pub_authors = {518147: [(1852, 'Edward Lee', 'Lee')], 557609: [(822, 'Robert E. Howard', 'Howard')], 557938: [(819, 'Clark Ashton Smith', 'Smith')], 558842: [(11149, 'Jeffrey Thomas', 'Thomas')], 558850: [(927, 'Whitley Strieber', 'Strieber')], 558949: [(1852, 'Edward Lee', 'Lee')], 563418: [(1446, 'Richard Laymon', 'Laymon')], 563445: [(14202, 'Tim Curran', 'Curran')], 563446: [(133996, 'Nate Southard', 'Southard')], 563447: [(31116, 'Bryan Smith', 'Smith')], ...}, pub_publishers = {29616: 'Festa'}, pub_series = {4853: 'H. P. Lovecrafts Bibliothek des Schreckens', 4990: 'H. P. Lovecrafts Bibliothek des Schreckens (Sonderausgabe)', 5060: 'Festa Horror TB', 5147: 'Festa Carlton Mellick III', 5152: 'Festa Psychothriller', 5311: 'Brian Lumleys Necroscope', 6566: 'Festa Horror', 6777: 'Festa Crime / Festa Action'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(563445, 'Zerfleischt', 'ZRFLSCHTKV2012', '2012-02-00', 29616, '411', 'pb', 'NOVEL', '9783865521378', 'http://www.isfdb.org/wiki/images/e/e3/ZRFLSCHTKV2012.jpg', '\xe2\x82\xac13.95', 528440, 5060, '1537', None), pub_authors={518147: [(1852, 'Edward Lee', 'Lee')], 557609: [(822, 'Robert E. Howard', 'Howard')], 557938: [(819, 'Clark Ashton Smith', 'Smith')], 558842: [(11149, 'Jeffrey Thomas', 'Thomas')], 558850: [(927, 'Whitley Strieber', 'Strieber')], 558949: [(1852, 'Edward Lee', 'Lee')], 563418: [(1446, 'Richard Laymon', 'Laymon')], 563445: [(14202, 'Tim Curran', 'Curran')], 563446: [(133996, 'Nate Southard', 'Southard')], 563447: [(31116, 'Bryan Smith', 'Smith')], ...}, pub_publishers={29616: 'Festa'}, pub_series={4853: 'H. P. Lovecrafts Bibliothek des Schreckens', 4990: 'H. P. Lovecrafts Bibliothek des Schreckens (Sonderausgabe)', 5060: 'Festa Horror TB', 5147: 'Festa Carlton Mellick III', 5152: 'Festa Psychothriller', 5311: 'Brian Lumleys Necroscope', 6566: 'Festa Horror', 6777: 'Festa Crime / Festa Action'}, 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 = (563445, 'Zerfleischt', 'ZRFLSCHTKV2012', '2012-02-00', 29616, '411', 'pb', 'NOVEL', '9783865521378', 'http://www.isfdb.org/wiki/images/e/e3/ZRFLSCHTKV2012.jpg', '\xe2\x82\xac13.95', 528440, 5060, '1537', 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=563445, displayed_value='Zerfleischt', 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 = 563445 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=563445) |
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=563445' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=563445') |
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=563445' |
/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=563445') |
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=563445' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''