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 18:57:08 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 = [(818084, "The Executioner's Right", 'THXCTNRSRB2021', '2021-01-01', 51978, '516', 'tp', 'NOVEL', '9781946586018', 'https://m.media-amazon.com/images/I/51QuR+Td4CL.jpg', '$16.99', 928778, None, None, None), (815857, 'The Caged Dragon', 'THCGDDRGNC2021', '2021-01-04', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41dWgZpaOPL.jpg', '$2.99', 926289, None, None, None), (815872, "The Executioner's Right", 'THXCTNRSRG2021', '2021-01-05', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51p7RNnBXxL.jpg', '$4.99', 926305, None, None, None), (821193, 'The Caged Dragon', 'THCGDDRGNR2021', '2021-01-25', 51978, '336', 'tp', 'NOVEL', '9798700231930', 'https://m.media-amazon.com/images/I/41HZzuYhWrL.jpg', '$14.99', 932558, None, None, None), (821137, "The Executioner's Apprentice", 'THXCTNRSPP2021', '2021-01-26', 51978, '450', 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51Lt2NQaX-L.jpg', '$4.99', None, None, None, None), (825142, "The Executioner's Apprentice", 'THXCTNRSPB2021', '2021-02-02', 51978, '538', 'tp', 'NOVEL', '9781946586025', 'https://m.media-amazon.com/images/I/51EH9hgX4aL.jpg', '$16.99', 937281, None, None, None), (819018, 'The Betrayed Dragon', 'THBTRDDRGN2021', '2021-02-09', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41aFS6H+EoL.jpg', '$3.99', 929865, None, None, None), (834877, 'The Fates of Yoran', 'THFTSFRNBV2021', '2021-02-12', 51978, None, 'digital audio download', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51nzvAgiiLL.jpg', '$19.95', 949020, None, None, None), (819606, "The Executioner's Blade", 'THXCTNRSBL2021', '2021-02-16', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51Lqk6VZg-L.jpg', '$4.99', 930563, None, None, None), (830921, 'The Betrayed Dragon', 'THBTRDDRGB2021', '2021-02-24', 51978, '386', 'tp', 'NOVEL', '9798713225421', 'https://m.media-amazon.com/images/I/516mvkRYcrL.jpg', '$14.99', 944403, None, None, None), (830626, "The Executioner's Blade", 'THXCTNRSBB2021', '2021-03-02', 51978, '530', 'tp', 'NOVEL', '9781946586032', 'https://m.media-amazon.com/images/I/517Bqxk-uAL.jpg', '$16.99', 944100, None, None, None), (820408, 'The Stone Wolf', 'THSTNWLFTH2021', '2021-03-09', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41xbI19x4BL.jpg', '$4.99', 931628, None, None, None), (830683, 'The Stone Wolf', 'THSTNWLFNW2021', '2021-03-10', 51978, '378', 'tp', 'NOVEL', '9798720037307', 'https://m.media-amazon.com/images/I/51HgabG7knL.jpg', '$15.99', 944158, None, None, None), (841568, 'The Stone Wolf', 'THSTNWLFTQ2021', '2021-03-21', 51978, '378', 'hc', 'NOVEL', '9798725968767', 'https://m.media-amazon.com/images/I/41psispKR2L.jpg', '$21.99', 957496, None, None, None), (831372, 'The Lost Dragon', 'THLSTDRGNC2021', '2021-03-23', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41UI8eLJ7VL.jpg', '$3.99', 944882, None, None, None), (841582, 'The Fates of Yoran', 'THFTSFRNTD2021', '2021-03-28', 51978, '382', 'hc', 'NOVEL', '9798729499724', 'https://m.media-amazon.com/images/I/41NquF9mO5L.jpg', '$21.99', 957510, None, None, None), (841583, 'The Risen Shard', 'THRSNSHRDQ2021', '2021-03-28', 51978, '378', 'hc', 'NOVEL', '9798713377410', 'https://m.media-amazon.com/images/I/41V2IATw7WL.jpg', '$19.99', 957511, None, None, None), (841588, 'The Jade Egg', 'THJDGGLMSV2021', '2021-03-28', 51978, '400', 'hc', 'NOVEL', '9798729502059', 'https://m.media-amazon.com/images/I/41c-mAMyflL.jpg', '$21.99', 957516, None, None, None), (833531, 'Festival of Mourn', 'FSTVLFMRNF2021', '2021-04-06', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41FDTopFr-L.jpg', '$3.99', 947339, None, None, None), (833532, 'Festival of Mourn', 'FSTVLFMRNN2021', '2021-04-07', 51978, '386', 'tp', 'NOVEL', '9798734589168', 'https://m.media-amazon.com/images/I/41HoSNeVCGS.jpg', '$14.99', 947340, None, None, None), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(818084, "The Executioner's Right", 'THXCTNRSRB2021', '2021-01-01', 51978, '516', 'tp', 'NOVEL', '9781946586018', 'https://m.media-amazon.com/images/I/51QuR+Td4CL.jpg', '$16.99', 928778, None, None, None), (815857, 'The Caged Dragon', 'THCGDDRGNC2021', '2021-01-04', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41dWgZpaOPL.jpg', '$2.99', 926289, None, None, None), (815872, "The Executioner's Right", 'THXCTNRSRG2021', '2021-01-05', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51p7RNnBXxL.jpg', '$4.99', 926305, None, None, None), (821193, 'The Caged Dragon', 'THCGDDRGNR2021', '2021-01-25', 51978, '336', 'tp', 'NOVEL', '9798700231930', 'https://m.media-amazon.com/images/I/41HZzuYhWrL.jpg', '$14.99', 932558, None, None, None), (821137, "The Executioner's Apprentice", 'THXCTNRSPP2021', '2021-01-26', 51978, '450', 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51Lt2NQaX-L.jpg', '$4.99', None, None, None, None), (825142, "The Executioner's Apprentice", 'THXCTNRSPB2021', '2021-02-02', 51978, '538', 'tp', 'NOVEL', '9781946586025', 'https://m.media-amazon.com/images/I/51EH9hgX4aL.jpg', '$16.99', 937281, None, None, None), (819018, 'The Betrayed Dragon', 'THBTRDDRGN2021', '2021-02-09', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41aFS6H+EoL.jpg', '$3.99', 929865, None, None, None), (834877, 'The Fates of Yoran', 'THFTSFRNBV2021', '2021-02-12', 51978, None, 'digital audio download', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51nzvAgiiLL.jpg', '$19.95', 949020, None, None, None), (819606, "The Executioner's Blade", 'THXCTNRSBL2021', '2021-02-16', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51Lqk6VZg-L.jpg', '$4.99', 930563, None, None, None), (830921, 'The Betrayed Dragon', 'THBTRDDRGB2021', '2021-02-24', 51978, '386', 'tp', 'NOVEL', '9798713225421', 'https://m.media-amazon.com/images/I/516mvkRYcrL.jpg', '$14.99', 944403, None, None, None), (830626, "The Executioner's Blade", 'THXCTNRSBB2021', '2021-03-02', 51978, '530', 'tp', 'NOVEL', '9781946586032', 'https://m.media-amazon.com/images/I/517Bqxk-uAL.jpg', '$16.99', 944100, None, None, None), (820408, 'The Stone Wolf', 'THSTNWLFTH2021', '2021-03-09', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41xbI19x4BL.jpg', '$4.99', 931628, None, None, None), (830683, 'The Stone Wolf', 'THSTNWLFNW2021', '2021-03-10', 51978, '378', 'tp', 'NOVEL', '9798720037307', 'https://m.media-amazon.com/images/I/51HgabG7knL.jpg', '$15.99', 944158, None, None, None), (841568, 'The Stone Wolf', 'THSTNWLFTQ2021', '2021-03-21', 51978, '378', 'hc', 'NOVEL', '9798725968767', 'https://m.media-amazon.com/images/I/41psispKR2L.jpg', '$21.99', 957496, None, None, None), (831372, 'The Lost Dragon', 'THLSTDRGNC2021', '2021-03-23', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41UI8eLJ7VL.jpg', '$3.99', 944882, None, None, None), (841582, 'The Fates of Yoran', 'THFTSFRNTD2021', '2021-03-28', 51978, '382', 'hc', 'NOVEL', '9798729499724', 'https://m.media-amazon.com/images/I/41NquF9mO5L.jpg', '$21.99', 957510, None, None, None), (841583, 'The Risen Shard', 'THRSNSHRDQ2021', '2021-03-28', 51978, '378', 'hc', 'NOVEL', '9798713377410', 'https://m.media-amazon.com/images/I/41V2IATw7WL.jpg', '$19.99', 957511, None, None, None), (841588, 'The Jade Egg', 'THJDGGLMSV2021', '2021-03-28', 51978, '400', 'hc', 'NOVEL', '9798729502059', 'https://m.media-amazon.com/images/I/41c-mAMyflL.jpg', '$21.99', 957516, None, None, None), (833531, 'Festival of Mourn', 'FSTVLFMRNF2021', '2021-04-06', 51978, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/41FDTopFr-L.jpg', '$3.99', 947339, None, None, None), (833532, 'Festival of Mourn', 'FSTVLFMRNN2021', '2021-04-07', 51978, '386', 'tp', 'NOVEL', '9798734589168', 'https://m.media-amazon.com/images/I/41HoSNeVCGS.jpg', '$14.99', 947340, 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 = (818084, "The Executioner's Right", 'THXCTNRSRB2021', '2021-01-01', 51978, '516', 'tp', 'NOVEL', '9781946586018', 'https://m.media-amazon.com/images/I/51QuR+Td4CL.jpg', '$16.99', 928778, None, None, None), pub_authors = {815857: [(200173, 'D. K. Holmberg', 'Holmberg'), (321413, 'Dan Michaelson', 'Michaelson')], 815872: [(200173, 'D. K. Holmberg', 'Holmberg')], 818084: [(200173, 'D. K. Holmberg', 'Holmberg')], 819018: [(200173, 'D. K. Holmberg', 'Holmberg'), (321413, 'Dan Michaelson', 'Michaelson')], 819606: [(200173, 'D. K. Holmberg', 'Holmberg')], 820408: [(200173, 'D. K. Holmberg', 'Holmberg')], 821137: [(200173, 'D. K. Holmberg', 'Holmberg')], 821193: [(200173, 'D. K. Holmberg', 'Holmberg'), (321413, 'Dan Michaelson', 'Michaelson')], 825142: [(200173, 'D. K. Holmberg', 'Holmberg')], 830626: [(200173, 'D. K. Holmberg', 'Holmberg')], ...}, pub_publishers = {51978: 'ASH Publishing'}, 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=(818084, "The Executioner's Right", 'THXCTNRSRB2021', '2021-01-01', 51978, '516', 'tp', 'NOVEL', '9781946586018', 'https://m.media-amazon.com/images/I/51QuR+Td4CL.jpg', '$16.99', 928778, None, None, None), pub_authors={815857: [(200173, 'D. K. Holmberg', 'Holmberg'), (321413, 'Dan Michaelson', 'Michaelson')], 815872: [(200173, 'D. K. Holmberg', 'Holmberg')], 818084: [(200173, 'D. K. Holmberg', 'Holmberg')], 819018: [(200173, 'D. K. Holmberg', 'Holmberg'), (321413, 'Dan Michaelson', 'Michaelson')], 819606: [(200173, 'D. K. Holmberg', 'Holmberg')], 820408: [(200173, 'D. K. Holmberg', 'Holmberg')], 821137: [(200173, 'D. K. Holmberg', 'Holmberg')], 821193: [(200173, 'D. K. Holmberg', 'Holmberg'), (321413, 'Dan Michaelson', 'Michaelson')], 825142: [(200173, 'D. K. Holmberg', 'Holmberg')], 830626: [(200173, 'D. K. Holmberg', 'Holmberg')], ...}, pub_publishers={51978: 'ASH Publishing'}, 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 = (818084, "The Executioner's Right", 'THXCTNRSRB2021', '2021-01-01', 51978, '516', 'tp', 'NOVEL', '9781946586018', 'https://m.media-amazon.com/images/I/51QuR+Td4CL.jpg', '$16.99', 928778, 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=818084, displayed_value="The Executioner's Right", 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 = 818084 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=818084) |
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=818084' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=818084') |
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=818084' |
/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=818084') |
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=818084' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''