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 23:41:14 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 = [(939712, 'Lost in the Moment and Found', 'LSTNTHMMNC2023', '2023-01-10', 6854, None, 'digital audio download', 'CHAPBOOK', '9781250883162', 'https://m.media-amazon.com/images/I/51bc8TJmzzL.jpg', '$10.99', 1098108, None, None, None), (1001578, 'Hell Bent', 'HLLBNTCVFQ2023', '2023-01-10', 6854, None, 'digital audio download', 'NOVEL', '9781250859365', 'https://isfdb.org/wiki/images/5/52/HLLBNTCVFQ2023.jpg', '$32.99', 1179385, None, None, None), (1001579, 'Hell Bent', 'HLLBNTBCMS2023', '2023-01-10', 6854, None, 'audio CD', 'NOVEL', '9781250866684', 'https://m.media-amazon.com/images/I/71Jcq4lz8wL.jpg', '$44.99', 1179386, None, None, None), (1002146, 'Son of the Poison Rose', 'SNFTHPSNRC2023', '2023-01-10', 6854, None, 'digital audio download', 'NOVEL', '9781250881908', 'https://m.media-amazon.com/images/I/61z4H6MxAVL.jpg', '$44.99', 1180091, None, None, None), (1002437, 'Please Report Your Bug Here', 'PLSRPRTRBC2023', '2023-01-17', 6854, None, 'digital audio download', 'NOVEL', '9781250887276', 'https://m.media-amazon.com/images/I/41rcAL6yaFL.jpg', '$26.99', 1180467, None, None, None), (1002356, 'The Terraformers', 'THTRRFRMRH2023', '2023-01-31', 6854, None, 'digital audio download', 'NOVEL', '9781250883001', 'https://isfdb.org/wiki/images/a/af/THTRRFRMRH2023.jpg', '$26.99', 1180348, None, None, None), (1003044, 'The Spite House', 'THSPTHSBMN2023', '2023-02-07', 6854, None, 'digital audio download', 'NOVEL', '9781250884190', 'https://m.media-amazon.com/images/I/61Aj6UJdCNL.jpg', '$26.99', 1181346, None, None, None), (1003617, 'Encore in Death', 'NCRNDTHHVJ2023', '2023-02-07', 6854, None, 'digital audio download', 'NOVEL', '9781250878267', 'https://isfdb.org/wiki/images/0/0d/NCRNDTHHVJ2023.jpg', '$26.99', 1182246, None, None, None), (1003618, 'Encore in Death', 'NCRNDTHZBZ2023', '2023-02-07', 6854, None, 'audio CD', 'NOVEL', '9781250878274', 'https://m.media-amazon.com/images/I/A1aC8jbCWoL.jpg', '$39.99', 1182247, None, None, None), (1003629, 'The Cradle of Ice', 'THCRDLFCFF2023', '2023-02-07', 6854, None, 'digital audio download', 'NOVEL', '9781250879226', 'https://m.media-amazon.com/images/I/61OOpu43gTL.jpg', '$32.99', 1182258, None, None, None), (1003435, 'The Cage of Dark Hours', 'THCGFDRKHC2023', '2023-02-14', 6854, None, 'digital audio download', 'NOVEL', '9781250841209', 'https://isfdb.org/wiki/images/c/cb/THCGFDRKHC2023.jpg', '$44.99', 1181996, None, None, None), (1003630, 'Arch-Conspirator', 'RCHCNSPRTF2023', '2023-02-21', 6854, None, 'digital audio download', 'CHAPBOOK', '9781250882981', 'https://isfdb.org/wiki/images/f/fe/RCHCNSPRTF2023.jpg', '$10.99', 1182259, None, None, None), (974471, 'The God of Endings', 'THGDFNDNGB2023', '2023-03-07', 6854, None, 'digital audio player', 'NOVEL', '9781250321015', None, '$89.99', 1142078, None, None, '44426'), (946074, 'Promises Stronger Than Darkness', 'PRMSSSTRNC2023', '2023-04-11', 6854, None, 'digital audio download', 'NOVEL', '9781250883193', 'https://m.media-amazon.com/images/I/51i5wrggS2L.jpg', '$26.99', 1105639, None, None, None), (981015, 'Furious Heaven', 'FRSHVNCFDN2023', '2023-04-18', 6854, None, 'digital audio download', 'NOVEL', '9781250840301', 'https://m.media-amazon.com/images/I/51gDKtO+bNL.jpg', '$37.49', 1150920, None, None, None), (957510, 'The Dragon Reborn', 'THDRGNRBRN2023', '2023-06-06', 6854, None, 'digital audio download', 'NOVEL', '9781250880765', 'https://m.media-amazon.com/images/I/51hohjtRx0L.jpg', '$44.99', 1120424, None, None, None), (957391, 'Maddalena and the Dark', 'MDDLNNDTHB2023', '2023-06-13', 6854, None, 'digital audio download', 'NOVEL', '9781250902764', 'https://m.media-amazon.com/images/I/518ZbuDeosL.jpg', '$26.99', 1120287, None, None, None), (957434, 'Riders', 'RDRSBLTMWG2023', '2023-06-13', 6854, None, 'audio CD', 'NOVEL', '9781427294630', 'https://m.media-amazon.com/images/I/61jy17oM3BL.jpg', '$44.50', 1120332, None, None, None), (957514, 'The First Bright Thing', 'THFRSTBRGG2023', '2023-06-13', 6854, None, 'digital audio download', 'NOVEL', '9781250901132', 'https://m.media-amazon.com/images/I/51EEh7hAyOL.jpg', '$26.99', 1120429, None, None, None), (986359, 'Five Years After', 'FVRSFTRHGB2023', '2023-08-22', 6854, None, 'digital audio download', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51cHdvl4raL.jpg', '$14.99', 1158493, None, None, None), ...] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(939712, 'Lost in the Moment and Found', 'LSTNTHMMNC2023', '2023-01-10', 6854, None, 'digital audio download', 'CHAPBOOK', '9781250883162', 'https://m.media-amazon.com/images/I/51bc8TJmzzL.jpg', '$10.99', 1098108, None, None, None), (1001578, 'Hell Bent', 'HLLBNTCVFQ2023', '2023-01-10', 6854, None, 'digital audio download', 'NOVEL', '9781250859365', 'https://isfdb.org/wiki/images/5/52/HLLBNTCVFQ2023.jpg', '$32.99', 1179385, None, None, None), (1001579, 'Hell Bent', 'HLLBNTBCMS2023', '2023-01-10', 6854, None, 'audio CD', 'NOVEL', '9781250866684', 'https://m.media-amazon.com/images/I/71Jcq4lz8wL.jpg', '$44.99', 1179386, None, None, None), (1002146, 'Son of the Poison Rose', 'SNFTHPSNRC2023', '2023-01-10', 6854, None, 'digital audio download', 'NOVEL', '9781250881908', 'https://m.media-amazon.com/images/I/61z4H6MxAVL.jpg', '$44.99', 1180091, None, None, None), (1002437, 'Please Report Your Bug Here', 'PLSRPRTRBC2023', '2023-01-17', 6854, None, 'digital audio download', 'NOVEL', '9781250887276', 'https://m.media-amazon.com/images/I/41rcAL6yaFL.jpg', '$26.99', 1180467, None, None, None), (1002356, 'The Terraformers', 'THTRRFRMRH2023', '2023-01-31', 6854, None, 'digital audio download', 'NOVEL', '9781250883001', 'https://isfdb.org/wiki/images/a/af/THTRRFRMRH2023.jpg', '$26.99', 1180348, None, None, None), (1003044, 'The Spite House', 'THSPTHSBMN2023', '2023-02-07', 6854, None, 'digital audio download', 'NOVEL', '9781250884190', 'https://m.media-amazon.com/images/I/61Aj6UJdCNL.jpg', '$26.99', 1181346, None, None, None), (1003617, 'Encore in Death', 'NCRNDTHHVJ2023', '2023-02-07', 6854, None, 'digital audio download', 'NOVEL', '9781250878267', 'https://isfdb.org/wiki/images/0/0d/NCRNDTHHVJ2023.jpg', '$26.99', 1182246, None, None, None), (1003618, 'Encore in Death', 'NCRNDTHZBZ2023', '2023-02-07', 6854, None, 'audio CD', 'NOVEL', '9781250878274', 'https://m.media-amazon.com/images/I/A1aC8jbCWoL.jpg', '$39.99', 1182247, None, None, None), (1003629, 'The Cradle of Ice', 'THCRDLFCFF2023', '2023-02-07', 6854, None, 'digital audio download', 'NOVEL', '9781250879226', 'https://m.media-amazon.com/images/I/61OOpu43gTL.jpg', '$32.99', 1182258, None, None, None), (1003435, 'The Cage of Dark Hours', 'THCGFDRKHC2023', '2023-02-14', 6854, None, 'digital audio download', 'NOVEL', '9781250841209', 'https://isfdb.org/wiki/images/c/cb/THCGFDRKHC2023.jpg', '$44.99', 1181996, None, None, None), (1003630, 'Arch-Conspirator', 'RCHCNSPRTF2023', '2023-02-21', 6854, None, 'digital audio download', 'CHAPBOOK', '9781250882981', 'https://isfdb.org/wiki/images/f/fe/RCHCNSPRTF2023.jpg', '$10.99', 1182259, None, None, None), (974471, 'The God of Endings', 'THGDFNDNGB2023', '2023-03-07', 6854, None, 'digital audio player', 'NOVEL', '9781250321015', None, '$89.99', 1142078, None, None, '44426'), (946074, 'Promises Stronger Than Darkness', 'PRMSSSTRNC2023', '2023-04-11', 6854, None, 'digital audio download', 'NOVEL', '9781250883193', 'https://m.media-amazon.com/images/I/51i5wrggS2L.jpg', '$26.99', 1105639, None, None, None), (981015, 'Furious Heaven', 'FRSHVNCFDN2023', '2023-04-18', 6854, None, 'digital audio download', 'NOVEL', '9781250840301', 'https://m.media-amazon.com/images/I/51gDKtO+bNL.jpg', '$37.49', 1150920, None, None, None), (957510, 'The Dragon Reborn', 'THDRGNRBRN2023', '2023-06-06', 6854, None, 'digital audio download', 'NOVEL', '9781250880765', 'https://m.media-amazon.com/images/I/51hohjtRx0L.jpg', '$44.99', 1120424, None, None, None), (957391, 'Maddalena and the Dark', 'MDDLNNDTHB2023', '2023-06-13', 6854, None, 'digital audio download', 'NOVEL', '9781250902764', 'https://m.media-amazon.com/images/I/518ZbuDeosL.jpg', '$26.99', 1120287, None, None, None), (957434, 'Riders', 'RDRSBLTMWG2023', '2023-06-13', 6854, None, 'audio CD', 'NOVEL', '9781427294630', 'https://m.media-amazon.com/images/I/61jy17oM3BL.jpg', '$44.50', 1120332, None, None, None), (957514, 'The First Bright Thing', 'THFRSTBRGG2023', '2023-06-13', 6854, None, 'digital audio download', 'NOVEL', '9781250901132', 'https://m.media-amazon.com/images/I/51EEh7hAyOL.jpg', '$26.99', 1120429, None, None, None), (986359, 'Five Years After', 'FVRSFTRHGB2023', '2023-08-22', 6854, None, 'digital audio download', 'NOVEL', None, 'https://m.media-amazon.com/images/I/51cHdvl4raL.jpg', '$14.99', 1158493, 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 = (939712, 'Lost in the Moment and Found', 'LSTNTHMMNC2023', '2023-01-10', 6854, None, 'digital audio download', 'CHAPBOOK', '9781250883162', 'https://m.media-amazon.com/images/I/51bc8TJmzzL.jpg', '$10.99', 1098108, None, None, None), pub_authors = {939712: [(129348, 'Seanan McGuire', 'McGuire')], 946074: [(146327, 'Charlie Jane Anders', 'Anders')], 957391: [(269829, 'Julia Fine', 'Fine')], 957434: [(163917, 'Veronica Rossi', 'Rossi')], 957510: [(845, 'Robert Jordan', 'Jordan')], 957514: [(248661, 'J. R. Dawson', 'Dawson')], 974471: [(358093, 'Jacqueline Holland', 'Holland')], 981015: [(469, 'Kate Elliott', 'Elliott')], 986359: [(652, 'William R. Forstchen', 'Forstchen')], 1000254: [(308929, 'Isabel Iba\xc3\xb1ez', 'Ibanez')], ...}, pub_publishers = {6854: 'Macmillan Audio'}, 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=(939712, 'Lost in the Moment and Found', 'LSTNTHMMNC2023', '2023-01-10', 6854, None, 'digital audio download', 'CHAPBOOK', '9781250883162', 'https://m.media-amazon.com/images/I/51bc8TJmzzL.jpg', '$10.99', 1098108, None, None, None), pub_authors={939712: [(129348, 'Seanan McGuire', 'McGuire')], 946074: [(146327, 'Charlie Jane Anders', 'Anders')], 957391: [(269829, 'Julia Fine', 'Fine')], 957434: [(163917, 'Veronica Rossi', 'Rossi')], 957510: [(845, 'Robert Jordan', 'Jordan')], 957514: [(248661, 'J. R. Dawson', 'Dawson')], 974471: [(358093, 'Jacqueline Holland', 'Holland')], 981015: [(469, 'Kate Elliott', 'Elliott')], 986359: [(652, 'William R. Forstchen', 'Forstchen')], 1000254: [(308929, 'Isabel Iba\xc3\xb1ez', 'Ibanez')], ...}, pub_publishers={6854: 'Macmillan Audio'}, 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 = (939712, 'Lost in the Moment and Found', 'LSTNTHMMNC2023', '2023-01-10', 6854, None, 'digital audio download', 'CHAPBOOK', '9781250883162', 'https://m.media-amazon.com/images/I/51bc8TJmzzL.jpg', '$10.99', 1098108, 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=939712, displayed_value='Lost in the Moment and Found', 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 = 939712 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=939712) |
| 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=939712' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=939712') |
| 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=939712' |
| /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=939712') |
| 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=939712' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''