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 17:28:24 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 = [(157471, 'The Beetle', 'THBTLGMVRJ1976', '1976-00-00', 570, '338', 'hc', 'NOVEL', '0405081510', None, '$19.00', 52881, 381, None, None), (155481, 'The Fox Woman and The Blue Pagoda and The Black Wheel', 'THFXWMNNDT1976', '1976-00-00', 570, '109+115', 'hc', 'OMNIBUS', '0405081537', 'https://images-na.ssl-images-amazon.com/images/I/51f3sXlo+VL.jpg', '$15.00', 50991, 381, None, None), (264014, 'The Devil and the Doctor', 'THDVLNDTHD1976', '1976-00-00', 570, 'v+308', 'hc', 'NOVEL', '0405081456', 'https://covers.openlibrary.org/b/id/4488764-L.jpg', '$17.00', 137523, 381, None, None), (264017, 'Fantastics and Other Fancies', 'FNTSTCSNDT1976', '1976-00-00', 570, 'ix+241', 'hc', 'COLLECTION', '0405081340', None, '$14.00', 137526, 381, None, None), (300425, 'Midnight House and Other Tales', 'MDNGHTHSND1976', '1976-00-00', 570, '243', 'hc', 'COLLECTION', '0405081332', None, '$14.00', 189014, 381, None, None), (270296, 'The Return (1910 version)', 'THRTRNCDMD1976', '1976-00-00', 570, '312', 'hc', 'NOVEL', '0405081243', None, '$17.00', 144917, 381, None, None), (278073, 'A Journey from This World to the Next', 'JRNFRMTHSW1976', '1976-00-00', 570, '175', 'hc', 'NOVEL', '0405081278', 'https://covers.openlibrary.org/b/id/4488689-L.jpg', '$11.00', 155337, 381, None, None), (282420, 'Argal or, The Silver Devil, Being the Adventures of an Evil Spirit, Related by Himself', 'RGLRTHSLVR1976', '1976-00-00', 570, '216+205', 'hc', 'NOVEL', '040508420X', 'https://covers.openlibrary.org/b/id/4620260-L.jpg', '$24.00', 160889, 381, None, None), (302111, 'The Street of Queer Houses and Other Tales', 'THSTRTFQRH1976', '1976-00-00', 570, 'vii+225', 'hc', 'COLLECTION', '0405081464', 'https://covers.openlibrary.org/b/id/4488770-L.jpg', '$13.00', 192248, 381, None, None), (309123, 'Elsie Venner: A Romance of Destiny', 'LSVNNRRMNC1976', '1976-00-00', 570, 'xvi+487', 'hc', 'NOVEL', '0405081375', None, '$29.00', 201601, 381, None, None), (339724, 'Grey Face', 'GRFCMKZQSN1976', '1976-00-00', 570, 'vi+331', 'hc', 'NOVEL', '0405081758', None, '$19.00', 244939, 381, None, None), (518035, 'Scientific Romances: First and Second Series', 'SCNTFCRMNC1976', '1976-00-00', 570, '229+177', 'hc', 'OMNIBUS', '0405079540', None, None, 467802, None, None, None), (922157, 'The Blotting Book', 'THBLTTNGBK1976', '1976-00-00', 570, '255', 'hc', 'NOVEL', '0405078641', 'https://covers.openlibrary.org/b/id/4486198-L.jpg', None, 1068837, 11340, None, None), (158241, 'The Collected Tales of A. E. Coppard', 'THCLLCTDST1976', '1976-12-00', 570, 'viii+532', 'hc', 'COLLECTION', '0405081197', None, '$30.00', 244569, 381, None, None), (37045, 'The Children of the Pool and Other Stories', 'CPOS1976', '1976-12-00', 570, '255', 'hc', 'COLLECTION', '0405084242', None, '$14.00', 155334, 381, None, None), (339716, 'Spirite: A Fantasy', 'SPRTFNTSJD1976', '1976-12-00', 570, '293', 'hc', 'NOVEL', '0405084196', None, '$18.00', 244931, 381, None, None), (247869, 'Strange Stories', 'STRNGSTRSW1976', '1976-12-00', 570, '745', 'hc', 'COLLECTION', '0405081146', None, '$42.00', 121969, 381, None, None), (247953, 'The Centaur', 'THCNTRGMJD1976', '1976-12-00', 570, '347', 'hc', 'NOVEL', '0405081138', None, '$20.00', 122053, 381, None, None), (278053, 'Ancient Hauntings', 'NCNTHNTNGS1976', '1976-12-00', 570, '[379]', 'hc', 'ANTHOLOGY', '0405081634', 'https://fantlab.ru/images/editions/orig/343880', '$26.00', 243419, 381, None, None), (278054, 'Phantasmagoria', 'PHNTSMGRRK1976', '1976-12-00', 570, '[357]', 'hc', 'ANTHOLOGY', '0405081529', 'https://fantlab.ru/images/editions/orig/369419', '$23.00', 155318, 381, None, None), ...] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(157471, 'The Beetle', 'THBTLGMVRJ1976', '1976-00-00', 570, '338', 'hc', 'NOVEL', '0405081510', None, '$19.00', 52881, 381, None, None), (155481, 'The Fox Woman and The Blue Pagoda and The Black Wheel', 'THFXWMNNDT1976', '1976-00-00', 570, '109+115', 'hc', 'OMNIBUS', '0405081537', 'https://images-na.ssl-images-amazon.com/images/I/51f3sXlo+VL.jpg', '$15.00', 50991, 381, None, None), (264014, 'The Devil and the Doctor', 'THDVLNDTHD1976', '1976-00-00', 570, 'v+308', 'hc', 'NOVEL', '0405081456', 'https://covers.openlibrary.org/b/id/4488764-L.jpg', '$17.00', 137523, 381, None, None), (264017, 'Fantastics and Other Fancies', 'FNTSTCSNDT1976', '1976-00-00', 570, 'ix+241', 'hc', 'COLLECTION', '0405081340', None, '$14.00', 137526, 381, None, None), (300425, 'Midnight House and Other Tales', 'MDNGHTHSND1976', '1976-00-00', 570, '243', 'hc', 'COLLECTION', '0405081332', None, '$14.00', 189014, 381, None, None), (270296, 'The Return (1910 version)', 'THRTRNCDMD1976', '1976-00-00', 570, '312', 'hc', 'NOVEL', '0405081243', None, '$17.00', 144917, 381, None, None), (278073, 'A Journey from This World to the Next', 'JRNFRMTHSW1976', '1976-00-00', 570, '175', 'hc', 'NOVEL', '0405081278', 'https://covers.openlibrary.org/b/id/4488689-L.jpg', '$11.00', 155337, 381, None, None), (282420, 'Argal or, The Silver Devil, Being the Adventures of an Evil Spirit, Related by Himself', 'RGLRTHSLVR1976', '1976-00-00', 570, '216+205', 'hc', 'NOVEL', '040508420X', 'https://covers.openlibrary.org/b/id/4620260-L.jpg', '$24.00', 160889, 381, None, None), (302111, 'The Street of Queer Houses and Other Tales', 'THSTRTFQRH1976', '1976-00-00', 570, 'vii+225', 'hc', 'COLLECTION', '0405081464', 'https://covers.openlibrary.org/b/id/4488770-L.jpg', '$13.00', 192248, 381, None, None), (309123, 'Elsie Venner: A Romance of Destiny', 'LSVNNRRMNC1976', '1976-00-00', 570, 'xvi+487', 'hc', 'NOVEL', '0405081375', None, '$29.00', 201601, 381, None, None), (339724, 'Grey Face', 'GRFCMKZQSN1976', '1976-00-00', 570, 'vi+331', 'hc', 'NOVEL', '0405081758', None, '$19.00', 244939, 381, None, None), (518035, 'Scientific Romances: First and Second Series', 'SCNTFCRMNC1976', '1976-00-00', 570, '229+177', 'hc', 'OMNIBUS', '0405079540', None, None, 467802, None, None, None), (922157, 'The Blotting Book', 'THBLTTNGBK1976', '1976-00-00', 570, '255', 'hc', 'NOVEL', '0405078641', 'https://covers.openlibrary.org/b/id/4486198-L.jpg', None, 1068837, 11340, None, None), (158241, 'The Collected Tales of A. E. Coppard', 'THCLLCTDST1976', '1976-12-00', 570, 'viii+532', 'hc', 'COLLECTION', '0405081197', None, '$30.00', 244569, 381, None, None), (37045, 'The Children of the Pool and Other Stories', 'CPOS1976', '1976-12-00', 570, '255', 'hc', 'COLLECTION', '0405084242', None, '$14.00', 155334, 381, None, None), (339716, 'Spirite: A Fantasy', 'SPRTFNTSJD1976', '1976-12-00', 570, '293', 'hc', 'NOVEL', '0405084196', None, '$18.00', 244931, 381, None, None), (247869, 'Strange Stories', 'STRNGSTRSW1976', '1976-12-00', 570, '745', 'hc', 'COLLECTION', '0405081146', None, '$42.00', 121969, 381, None, None), (247953, 'The Centaur', 'THCNTRGMJD1976', '1976-12-00', 570, '347', 'hc', 'NOVEL', '0405081138', None, '$20.00', 122053, 381, None, None), (278053, 'Ancient Hauntings', 'NCNTHNTNGS1976', '1976-12-00', 570, '[379]', 'hc', 'ANTHOLOGY', '0405081634', 'https://fantlab.ru/images/editions/orig/343880', '$26.00', 243419, 381, None, None), (278054, 'Phantasmagoria', 'PHNTSMGRRK1976', '1976-12-00', 570, '[357]', 'hc', 'ANTHOLOGY', '0405081529', 'https://fantlab.ru/images/editions/orig/369419', '$23.00', 155318, 381, 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 = (157471, 'The Beetle', 'THBTLGMVRJ1976', '1976-00-00', 570, '338', 'hc', 'NOVEL', '0405081510', None, '$19.00', 52881, 381, None, None), pub_authors = {37045: [(135, 'Arthur Machen', 'Machen')], 155481: [(609, 'Hannes Bok', 'Bok'), (613, 'A. Merritt', 'Merritt')], 157471: [(2040, 'Richard Marsh', 'Marsh')], 158241: [(1201, 'A. E. Coppard', 'Coppard')], 247869: [(1126, 'Algernon Blackwood', 'Blackwood')], 247953: [(1126, 'Algernon Blackwood', 'Blackwood')], 264014: [(71511, 'David H. Keller', 'Keller')], 264017: [(19738, 'Lafcadio Hearn', 'Hearn')], 270296: [(11634, 'Walter de la Mare', 'de la Mare')], 278053: [(10968, 'Douglas Menville', 'Menville'), (10969, 'R. Reginald', 'Reginald')], ...}, pub_publishers = {570: 'Arno Press'}, pub_series = {381: 'Supernatural and Occult Fiction', 11340: 'Literature of Mystery and Detection'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(157471, 'The Beetle', 'THBTLGMVRJ1976', '1976-00-00', 570, '338', 'hc', 'NOVEL', '0405081510', None, '$19.00', 52881, 381, None, None), pub_authors={37045: [(135, 'Arthur Machen', 'Machen')], 155481: [(609, 'Hannes Bok', 'Bok'), (613, 'A. Merritt', 'Merritt')], 157471: [(2040, 'Richard Marsh', 'Marsh')], 158241: [(1201, 'A. E. Coppard', 'Coppard')], 247869: [(1126, 'Algernon Blackwood', 'Blackwood')], 247953: [(1126, 'Algernon Blackwood', 'Blackwood')], 264014: [(71511, 'David H. Keller', 'Keller')], 264017: [(19738, 'Lafcadio Hearn', 'Hearn')], 270296: [(11634, 'Walter de la Mare', 'de la Mare')], 278053: [(10968, 'Douglas Menville', 'Menville'), (10969, 'R. Reginald', 'Reginald')], ...}, pub_publishers={570: 'Arno Press'}, pub_series={381: 'Supernatural and Occult Fiction', 11340: 'Literature of Mystery and Detection'}, 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 = (157471, 'The Beetle', 'THBTLGMVRJ1976', '1976-00-00', 570, '338', 'hc', 'NOVEL', '0405081510', None, '$19.00', 52881, 381, 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=157471, displayed_value='The Beetle', 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 = 157471 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=157471) |
| 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=157471' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=157471') |
| 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=157471' |
| /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=157471') |
| 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=157471' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''