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 19:47:23 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 = [(825964, 'Labyrinth of Fright', 'LBRNTHFFRG2021', '2021-01-04', 72362, None, 'ebook', 'NOVEL', '9788076192263', 'https://m.media-amazon.com/images/I/51hXERMYWLL.jpg', '$6.99', 938195, None, None, None), (838816, 'Clan Dominance: The Sleepless Ones: Book #5', 'CLNDMNNCTC2021', '2021-01-29', 72362, '407', 'tp', 'NOVEL', '9788076192768', 'https://m.media-amazon.com/images/I/51Cpjx5AZJL.jpg', '$18.99', 954142, None, None, None), (816915, 'Clan Dominance: The Sleepless Ones: Book #5', 'CLNDMNNCTH2021', '2021-02-02', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51Cpjx5AZJL.jpg', '$6.99', 927444, None, None, None), (834708, 'Path of Spirit', 'PTHFSPRTKM2021', '2021-02-10', 72362, '513', 'tp', 'NOVEL', '9788076192829', 'https://m.media-amazon.com/images/I/51ndy-F9NML.jpg', '$19.99', 948846, None, None, None), (833604, 'Path of Spirit', 'PTHFSPRTRX2021', '2021-02-17', 72362, None, 'ebook', 'NOVEL', '9788076192416', 'https://m.media-amazon.com/images/I/51ULKxu7fcL.jpg', '$6.99', 947434, None, None, None), (830998, 'Cause for War', 'CSFRWRJZZN2021', '2021-03-11', 72362, '479', 'tp', 'NOVEL', '9788076192973', 'https://m.media-amazon.com/images/I/51IugBwr9XL.jpg', '$18.99', 944480, None, None, None), (822045, 'Cause for War', 'CSFRWRRLTB2021', '2021-03-19', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51zeov4v4jL.jpg', '$6.99', 933550, None, None, None), (838818, 'Clan Dominance: The Sleepless Ones: Book #6', 'CLNDMNNCTD2021', '2021-04-12', 72362, '461', 'tp', 'NOVEL', '9788076193208', 'https://m.media-amazon.com/images/I/51LrEjh32BL.jpg', '$18.99', 954144, None, None, None), (840759, 'Showdown', 'SHWDWNGZVR2021', '2021-05-06', 72362, '439', 'tp', 'NOVEL', '9788076193314', 'https://m.media-amazon.com/images/I/51y4d8wPo0S.jpg', '$19.99', 956497, None, None, None), (973491, 'Tartila Mine', 'TRTLMNGXFW2021', '2021-05-07', 72362, '435', 'tp', 'NOVEL', '9788076193321', 'https://m.media-amazon.com/images/I/41ZT7MfDxzS.jpg', '$18.24', 1140882, None, None, None), (832081, 'Showdown', 'SHWDWNNDRD2021', '2021-05-12', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51JfCdspOWL.jpg', '$6.99', 945732, None, None, None), (840760, 'The Demonic Games', 'THDMNCGMSW2021', '2021-05-13', 72362, '533', 'tp', 'NOVEL', '9788076193383', 'https://m.media-amazon.com/images/I/41omwVNkB6S.jpg', '$20.99', 956498, None, None, None), (973734, 'Restart', 'RSTRTKLXNP2021', '2021-05-17', 72362, '390', 'tp', 'NOVEL', '9798201777326', 'https://m.media-amazon.com/images/I/51gLMiVKUnS.jpg', '$21.99', 1141184, None, None, None), (831677, 'The Demonic Games', 'THDMNCGMSD2021', '2021-05-18', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/512d1Kk1SQL.jpg', '$6.99', 945263, None, None, None), (831669, 'Clan Dominance: The Sleepless Ones: Book #6', 'CLNDMNNCTB2021', '2021-05-25', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51LrEjh32BL.jpg', '$6.99', 945255, None, None, None), (838820, 'Clan Dominance: The Sleepless Ones: Book #7', 'CLNDMNNCTF2021', '2021-07-02', 72362, None, 'ebook', 'NOVEL', '9788076193239', 'https://m.media-amazon.com/images/I/517KcGGjnMS.jpg', '$6.99', 954145, None, None, None), (850429, 'Devourer', 'DVRRKWNHBF2021', '2021-07-05', 72362, '491', 'tp', 'NOVEL', '9788076193741', 'https://m.media-amazon.com/images/I/51K8cNhn7wS.jpg', '$19.99', 968412, None, None, None), (845761, 'Devourer', 'DVRRRLTBND2021', '2021-07-12', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51Zjh4UFS1S.jpg', '$6.99', 962361, None, None, None), (883031, 'Katharsis', 'KTHRSSWKNB2021', '2021-07-15', 72362, '553', 'tp', 'NOVEL', '9788076193819', 'https://m.media-amazon.com/images/I/41hZ2j7X3lS.jpg', '$19.99', 1014478, None, None, None), (865644, 'Enemy of the Inferno', 'NMFTHNFRNN2021', '2021-08-02', 72362, '465', 'tp', 'NOVEL', '9788076193918', 'https://m.media-amazon.com/images/I/5105m0ZudbL.jpg', '$19.99', 989856, None, None, None), ...] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(825964, 'Labyrinth of Fright', 'LBRNTHFFRG2021', '2021-01-04', 72362, None, 'ebook', 'NOVEL', '9788076192263', 'https://m.media-amazon.com/images/I/51hXERMYWLL.jpg', '$6.99', 938195, None, None, None), (838816, 'Clan Dominance: The Sleepless Ones: Book #5', 'CLNDMNNCTC2021', '2021-01-29', 72362, '407', 'tp', 'NOVEL', '9788076192768', 'https://m.media-amazon.com/images/I/51Cpjx5AZJL.jpg', '$18.99', 954142, None, None, None), (816915, 'Clan Dominance: The Sleepless Ones: Book #5', 'CLNDMNNCTH2021', '2021-02-02', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51Cpjx5AZJL.jpg', '$6.99', 927444, None, None, None), (834708, 'Path of Spirit', 'PTHFSPRTKM2021', '2021-02-10', 72362, '513', 'tp', 'NOVEL', '9788076192829', 'https://m.media-amazon.com/images/I/51ndy-F9NML.jpg', '$19.99', 948846, None, None, None), (833604, 'Path of Spirit', 'PTHFSPRTRX2021', '2021-02-17', 72362, None, 'ebook', 'NOVEL', '9788076192416', 'https://m.media-amazon.com/images/I/51ULKxu7fcL.jpg', '$6.99', 947434, None, None, None), (830998, 'Cause for War', 'CSFRWRJZZN2021', '2021-03-11', 72362, '479', 'tp', 'NOVEL', '9788076192973', 'https://m.media-amazon.com/images/I/51IugBwr9XL.jpg', '$18.99', 944480, None, None, None), (822045, 'Cause for War', 'CSFRWRRLTB2021', '2021-03-19', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51zeov4v4jL.jpg', '$6.99', 933550, None, None, None), (838818, 'Clan Dominance: The Sleepless Ones: Book #6', 'CLNDMNNCTD2021', '2021-04-12', 72362, '461', 'tp', 'NOVEL', '9788076193208', 'https://m.media-amazon.com/images/I/51LrEjh32BL.jpg', '$18.99', 954144, None, None, None), (840759, 'Showdown', 'SHWDWNGZVR2021', '2021-05-06', 72362, '439', 'tp', 'NOVEL', '9788076193314', 'https://m.media-amazon.com/images/I/51y4d8wPo0S.jpg', '$19.99', 956497, None, None, None), (973491, 'Tartila Mine', 'TRTLMNGXFW2021', '2021-05-07', 72362, '435', 'tp', 'NOVEL', '9788076193321', 'https://m.media-amazon.com/images/I/41ZT7MfDxzS.jpg', '$18.24', 1140882, None, None, None), (832081, 'Showdown', 'SHWDWNNDRD2021', '2021-05-12', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51JfCdspOWL.jpg', '$6.99', 945732, None, None, None), (840760, 'The Demonic Games', 'THDMNCGMSW2021', '2021-05-13', 72362, '533', 'tp', 'NOVEL', '9788076193383', 'https://m.media-amazon.com/images/I/41omwVNkB6S.jpg', '$20.99', 956498, None, None, None), (973734, 'Restart', 'RSTRTKLXNP2021', '2021-05-17', 72362, '390', 'tp', 'NOVEL', '9798201777326', 'https://m.media-amazon.com/images/I/51gLMiVKUnS.jpg', '$21.99', 1141184, None, None, None), (831677, 'The Demonic Games', 'THDMNCGMSD2021', '2021-05-18', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/512d1Kk1SQL.jpg', '$6.99', 945263, None, None, None), (831669, 'Clan Dominance: The Sleepless Ones: Book #6', 'CLNDMNNCTB2021', '2021-05-25', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51LrEjh32BL.jpg', '$6.99', 945255, None, None, None), (838820, 'Clan Dominance: The Sleepless Ones: Book #7', 'CLNDMNNCTF2021', '2021-07-02', 72362, None, 'ebook', 'NOVEL', '9788076193239', 'https://m.media-amazon.com/images/I/517KcGGjnMS.jpg', '$6.99', 954145, None, None, None), (850429, 'Devourer', 'DVRRKWNHBF2021', '2021-07-05', 72362, '491', 'tp', 'NOVEL', '9788076193741', 'https://m.media-amazon.com/images/I/51K8cNhn7wS.jpg', '$19.99', 968412, None, None, None), (845761, 'Devourer', 'DVRRRLTBND2021', '2021-07-12', 72362, None, 'ebook', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51Zjh4UFS1S.jpg', '$6.99', 962361, None, None, None), (883031, 'Katharsis', 'KTHRSSWKNB2021', '2021-07-15', 72362, '553', 'tp', 'NOVEL', '9788076193819', 'https://m.media-amazon.com/images/I/41hZ2j7X3lS.jpg', '$19.99', 1014478, None, None, None), (865644, 'Enemy of the Inferno', 'NMFTHNFRNN2021', '2021-08-02', 72362, '465', 'tp', 'NOVEL', '9788076193918', 'https://m.media-amazon.com/images/I/5105m0ZudbL.jpg', '$19.99', 989856, 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 = (825964, 'Labyrinth of Fright', 'LBRNTHFFRG2021', '2021-01-04', 72362, None, 'ebook', 'NOVEL', '9788076192263', 'https://m.media-amazon.com/images/I/51hXERMYWLL.jpg', '$6.99', 938195, None, None, None), pub_authors = {816915: [(318902, 'Dem Mikhailov', 'Mikhailov')], 822045: [(319768, 'Michael Atamanov', 'Atamanov')], 825964: [(322221, 'Alexey Osadchuk', 'Osadchuk')], 830998: [(319768, 'Michael Atamanov', 'Atamanov')], 831669: [(318902, 'Dem Mikhailov', 'Mikhailov')], 831677: [(318032, 'Dan Sugralinov', 'Sugralinov')], 832081: [(322221, 'Alexey Osadchuk', 'Osadchuk')], 833604: [(318032, 'Dan Sugralinov', 'Sugralinov')], 834708: [(318032, 'Dan Sugralinov', 'Sugralinov')], 838816: [(318902, 'Dem Mikhailov', 'Mikhailov')], ...}, pub_publishers = {72362: 'Magic Dome 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=(825964, 'Labyrinth of Fright', 'LBRNTHFFRG2021', '2021-01-04', 72362, None, 'ebook', 'NOVEL', '9788076192263', 'https://m.media-amazon.com/images/I/51hXERMYWLL.jpg', '$6.99', 938195, None, None, None), pub_authors={816915: [(318902, 'Dem Mikhailov', 'Mikhailov')], 822045: [(319768, 'Michael Atamanov', 'Atamanov')], 825964: [(322221, 'Alexey Osadchuk', 'Osadchuk')], 830998: [(319768, 'Michael Atamanov', 'Atamanov')], 831669: [(318902, 'Dem Mikhailov', 'Mikhailov')], 831677: [(318032, 'Dan Sugralinov', 'Sugralinov')], 832081: [(322221, 'Alexey Osadchuk', 'Osadchuk')], 833604: [(318032, 'Dan Sugralinov', 'Sugralinov')], 834708: [(318032, 'Dan Sugralinov', 'Sugralinov')], 838816: [(318902, 'Dem Mikhailov', 'Mikhailov')], ...}, pub_publishers={72362: 'Magic Dome 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 = (825964, 'Labyrinth of Fright', 'LBRNTHFFRG2021', '2021-01-04', 72362, None, 'ebook', 'NOVEL', '9788076192263', 'https://m.media-amazon.com/images/I/51hXERMYWLL.jpg', '$6.99', 938195, 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=825964, displayed_value='Labyrinth of Fright', 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 = 825964 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=825964) |
| 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=825964' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=825964') |
| 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=825964' |
| /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=825964') |
| 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=825964' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''