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 Tue Apr 30 08:55:50 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 = [(13281, 'Faster Than Light', 'FSTRLGHT2C1976', '1976-00-00', 145, 'xix+321', 'hc', 'ANTHOLOGY', '0060109521', 'http://www.isfdb.org/wiki/images/9/92/FSTRLGHT2C1976.jpg', '$8.95', 191760, None, None, None), (16774, "Hell's Cartographers: Some Personal Histories of Science Fiction Writers", 'HLLSCRTGR1976', '1976-00-00', 145, '246', 'hc', 'NONFICTION', '0060100524', 'http://www.isfdb.org/wiki/images/4/44/HLLSCRTGR1976.jpg', '$7.95', 177673, None, None, None), (264003, 'The Space-Gods Revealed', 'TNSPCGDSRV1976', '1976-00-00', 145, 'xviii+139', 'hc', 'NONFICTION', '0060141417', 'https://images-na.ssl-images-amazon.com/images/I/91dY8YE3grL.jpg', '$7.95', None, None, None, None), (531419, 'Dr. Jekyll and Mr. Hyde', 'DRJKLLNDMB1976', '1976-00-00', 145, '96', 'pb', 'CHAPBOOK', '0064650537', 'http://www.isfdb.org/wiki/images/8/84/DRJKLLNDMB1976.jpg', '$0.95', 483115, None, None, None), (856402, 'It Looks Alive to Me!', 'TLKSLVTMCP1976', '1976-00-00', 145, '168', 'hc', 'NOVEL', '0060204044', 'http://www.isfdb.org/wiki/images/c/c2/TLKSLVTMCP1976.jpg', None, None, None, None, None), (903865, 'Family', 'FMLTHRKRJW1976', '1976-00-00', 145, '116', 'hc', 'NOVEL', '0060217219', None, '$5.79', 1042144, 10795, None, None), (20145, 'Legends from the End of Time', 'LGNDSEOT1976', '1976-01-00', 145, '182', 'hc', 'COLLECTION', '0060130016', 'http://www.isfdb.org/wiki/images/1/1e/LGNDSEOT1976.jpg', '$7.95', 173496, None, None, None), (54421, 'Where Late the Sweet Birds Sang', 'WLTSBS1976', '1976-01-00', 145, '251', 'hc', 'NOVEL', '0060146540', 'http://www.isfdb.org/wiki/images/1/13/WHRLTTHSWT1976.jpg', '$7.95', 160816, None, None, None), (441089, 'Comet', 'CMTXWGLSBW1976', '1976-03-00', 145, '222', 'hc', 'NOVEL', '0060146087', 'https://m.media-amazon.com/images/G/01/ciu/69/ae/cfe092c008a093a36a896010.L.jpg', '$7.95', 376186, None, None, None), (118821, 'Doorways in the Sand', 'DRWSNTHSND1976', '1976-03-00', 145, '185', 'hc', 'NOVEL', '006014789X', 'http://www.isfdb.org/wiki/images/f/fe/DRWSNTHSND1976.jpg', '$8.95', 197047, None, None, None), (130841, 'And Strange at Ecbatan the Trees', 'NDSTRNGTCG1976', '1976-03-00', 145, '154', 'hc', 'NOVEL', '0060103523', 'http://www.isfdb.org/wiki/images/d/d2/NDSTRNGTCG1976.jpg', '$7.95', 35511, None, None, None), (656930, "The Kelpie's Pearls", 'THKLPSPRLS1976', '1976-03-00', 145, '134', 'hc', 'NOVEL', '0060226560', 'https://images-na.ssl-images-amazon.com/images/I/41KP9SSGZYL.jpg', None, 681509, None, None, None), (23723, 'New Dimensions Science Fiction Number 6', 'NWDMNSNS61976', '1976-05-00', 145, '247', 'hc', 'ANTHOLOGY', '0060138645', 'http://www.isfdb.org/wiki/images/f/f1/NWDMNSNS61976.jpg', '$8.95', 180788, None, None, None), (43054, 'The Lifeship', 'THLFSHP1976', '1976-05-00', 145, '181', 'hc', 'NOVEL', '0060117648', 'http://www.isfdb.org/wiki/images/2/2c/THLFSHP1976.jpg', '$7.95', 164821, None, None, None), (253513, 'Japan Sinks', 'JPNSNKSZTC1976', '1976-05-00', 145, '184', 'hc', 'NOVEL', '0060124490', 'http://www.isfdb.org/wiki/images/2/25/JPNSNKSZTC1976.jpg', '$7.95', 890087, None, None, None), (25112, 'Orbit 18', 'ORBIT181976', '1976-06-00', 145, 'vi+256', 'hc', 'ANTHOLOGY', '0060124334', 'http://www.isfdb.org/wiki/images/5/59/ORBIT181976.jpg', '$8.95', 167965, None, None, None), (47600, 'The Space Machine', 'THSPCMCHNS1976', '1976-06-00', 145, '363', 'hc', 'NOVEL', '0060134291', 'http://www.isfdb.org/wiki/images/3/38/THSPCMCHNS1976.jpg', '$8.95', 298406, None, None, None), (39199, 'The End of All Songs', 'THNDFLLSNG1976', '1976-07-00', 145, '271', 'hc', 'NOVEL', '0060129999', 'http://www.isfdb.org/wiki/images/6/68/THNDFLLSNG1976.jpg', '$8.95', 153688, None, None, None), (87298, 'The Craft of Science Fiction: A Symposium on Writing Science Fiction and Science Fantasy', 'THCRFTFSCN1976', '1976-08-00', 145, '321', 'hc', 'NONFICTION', '0060104619', 'http://www.isfdb.org/wiki/images/a/a2/THCRFTFSCN1976.jpg', '$9.95', 256412, None, None, None), (25214, 'Orsinian Tales', 'RSNNTLS571976', '1976-09-00', 145, '179', 'hc', 'COLLECTION', '0060125616', 'http://www.isfdb.org/wiki/images/b/b1/RSNNTLS571976.jpg', '$7.95', 108045, None, None, None), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(13281, 'Faster Than Light', 'FSTRLGHT2C1976', '1976-00-00', 145, 'xix+321', 'hc', 'ANTHOLOGY', '0060109521', 'http://www.isfdb.org/wiki/images/9/92/FSTRLGHT2C1976.jpg', '$8.95', 191760, None, None, None), (16774, "Hell's Cartographers: Some Personal Histories of Science Fiction Writers", 'HLLSCRTGR1976', '1976-00-00', 145, '246', 'hc', 'NONFICTION', '0060100524', 'http://www.isfdb.org/wiki/images/4/44/HLLSCRTGR1976.jpg', '$7.95', 177673, None, None, None), (264003, 'The Space-Gods Revealed', 'TNSPCGDSRV1976', '1976-00-00', 145, 'xviii+139', 'hc', 'NONFICTION', '0060141417', 'https://images-na.ssl-images-amazon.com/images/I/91dY8YE3grL.jpg', '$7.95', None, None, None, None), (531419, 'Dr. Jekyll and Mr. Hyde', 'DRJKLLNDMB1976', '1976-00-00', 145, '96', 'pb', 'CHAPBOOK', '0064650537', 'http://www.isfdb.org/wiki/images/8/84/DRJKLLNDMB1976.jpg', '$0.95', 483115, None, None, None), (856402, 'It Looks Alive to Me!', 'TLKSLVTMCP1976', '1976-00-00', 145, '168', 'hc', 'NOVEL', '0060204044', 'http://www.isfdb.org/wiki/images/c/c2/TLKSLVTMCP1976.jpg', None, None, None, None, None), (903865, 'Family', 'FMLTHRKRJW1976', '1976-00-00', 145, '116', 'hc', 'NOVEL', '0060217219', None, '$5.79', 1042144, 10795, None, None), (20145, 'Legends from the End of Time', 'LGNDSEOT1976', '1976-01-00', 145, '182', 'hc', 'COLLECTION', '0060130016', 'http://www.isfdb.org/wiki/images/1/1e/LGNDSEOT1976.jpg', '$7.95', 173496, None, None, None), (54421, 'Where Late the Sweet Birds Sang', 'WLTSBS1976', '1976-01-00', 145, '251', 'hc', 'NOVEL', '0060146540', 'http://www.isfdb.org/wiki/images/1/13/WHRLTTHSWT1976.jpg', '$7.95', 160816, None, None, None), (441089, 'Comet', 'CMTXWGLSBW1976', '1976-03-00', 145, '222', 'hc', 'NOVEL', '0060146087', 'https://m.media-amazon.com/images/G/01/ciu/69/ae/cfe092c008a093a36a896010.L.jpg', '$7.95', 376186, None, None, None), (118821, 'Doorways in the Sand', 'DRWSNTHSND1976', '1976-03-00', 145, '185', 'hc', 'NOVEL', '006014789X', 'http://www.isfdb.org/wiki/images/f/fe/DRWSNTHSND1976.jpg', '$8.95', 197047, None, None, None), (130841, 'And Strange at Ecbatan the Trees', 'NDSTRNGTCG1976', '1976-03-00', 145, '154', 'hc', 'NOVEL', '0060103523', 'http://www.isfdb.org/wiki/images/d/d2/NDSTRNGTCG1976.jpg', '$7.95', 35511, None, None, None), (656930, "The Kelpie's Pearls", 'THKLPSPRLS1976', '1976-03-00', 145, '134', 'hc', 'NOVEL', '0060226560', 'https://images-na.ssl-images-amazon.com/images/I/41KP9SSGZYL.jpg', None, 681509, None, None, None), (23723, 'New Dimensions Science Fiction Number 6', 'NWDMNSNS61976', '1976-05-00', 145, '247', 'hc', 'ANTHOLOGY', '0060138645', 'http://www.isfdb.org/wiki/images/f/f1/NWDMNSNS61976.jpg', '$8.95', 180788, None, None, None), (43054, 'The Lifeship', 'THLFSHP1976', '1976-05-00', 145, '181', 'hc', 'NOVEL', '0060117648', 'http://www.isfdb.org/wiki/images/2/2c/THLFSHP1976.jpg', '$7.95', 164821, None, None, None), (253513, 'Japan Sinks', 'JPNSNKSZTC1976', '1976-05-00', 145, '184', 'hc', 'NOVEL', '0060124490', 'http://www.isfdb.org/wiki/images/2/25/JPNSNKSZTC1976.jpg', '$7.95', 890087, None, None, None), (25112, 'Orbit 18', 'ORBIT181976', '1976-06-00', 145, 'vi+256', 'hc', 'ANTHOLOGY', '0060124334', 'http://www.isfdb.org/wiki/images/5/59/ORBIT181976.jpg', '$8.95', 167965, None, None, None), (47600, 'The Space Machine', 'THSPCMCHNS1976', '1976-06-00', 145, '363', 'hc', 'NOVEL', '0060134291', 'http://www.isfdb.org/wiki/images/3/38/THSPCMCHNS1976.jpg', '$8.95', 298406, None, None, None), (39199, 'The End of All Songs', 'THNDFLLSNG1976', '1976-07-00', 145, '271', 'hc', 'NOVEL', '0060129999', 'http://www.isfdb.org/wiki/images/6/68/THNDFLLSNG1976.jpg', '$8.95', 153688, None, None, None), (87298, 'The Craft of Science Fiction: A Symposium on Writing Science Fiction and Science Fantasy', 'THCRFTFSCN1976', '1976-08-00', 145, '321', 'hc', 'NONFICTION', '0060104619', 'http://www.isfdb.org/wiki/images/a/a2/THCRFTFSCN1976.jpg', '$9.95', 256412, None, None, None), (25214, 'Orsinian Tales', 'RSNNTLS571976', '1976-09-00', 145, '179', 'hc', 'COLLECTION', '0060125616', 'http://www.isfdb.org/wiki/images/b/b1/RSNNTLS571976.jpg', '$7.95', 108045, 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 = (13281, 'Faster Than Light', 'FSTRLGHT2C1976', '1976-00-00', 145, 'xix+321', 'hc', 'ANTHOLOGY', '0060109521', 'http://www.isfdb.org/wiki/images/9/92/FSTRLGHT2C1976.jpg', '$8.95', 191760, None, None, None), pub_authors = {13281: [(274, 'Jack Dann', 'Dann'), (357, 'George Zebrowski', 'Zebrowski')], 16774: [(131, 'Brian W. Aldiss', 'Aldiss'), (28, 'Harry Harrison', 'Harrison')], 20145: [(140, 'Michael Moorcock', 'Moorcock')], 23704: [(821, 'Thomas M. Disch', 'Disch'), (6073, 'Charles Naylor', 'Naylor')], 23723: [(54, 'Robert Silverberg', 'Silverberg')], 25112: [(633, 'Damon Knight', 'Knight')], 25214: [(37, 'Ursula K. Le Guin', 'Le Guin')], 39199: [(140, 'Michael Moorcock', 'Moorcock')], 43054: [(24, 'Gordon R. Dickson', 'Dickson'), (28, 'Harry Harrison', 'Harrison')], 47600: [(336, 'Christopher Priest', 'Priest')], ...}, pub_publishers = {145: 'Harper & Row'}, pub_series = {10795: 'An Ursula Nordstrom Book'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(13281, 'Faster Than Light', 'FSTRLGHT2C1976', '1976-00-00', 145, 'xix+321', 'hc', 'ANTHOLOGY', '0060109521', 'http://www.isfdb.org/wiki/images/9/92/FSTRLGHT2C1976.jpg', '$8.95', 191760, None, None, None), pub_authors={13281: [(274, 'Jack Dann', 'Dann'), (357, 'George Zebrowski', 'Zebrowski')], 16774: [(131, 'Brian W. Aldiss', 'Aldiss'), (28, 'Harry Harrison', 'Harrison')], 20145: [(140, 'Michael Moorcock', 'Moorcock')], 23704: [(821, 'Thomas M. Disch', 'Disch'), (6073, 'Charles Naylor', 'Naylor')], 23723: [(54, 'Robert Silverberg', 'Silverberg')], 25112: [(633, 'Damon Knight', 'Knight')], 25214: [(37, 'Ursula K. Le Guin', 'Le Guin')], 39199: [(140, 'Michael Moorcock', 'Moorcock')], 43054: [(24, 'Gordon R. Dickson', 'Dickson'), (28, 'Harry Harrison', 'Harrison')], 47600: [(336, 'Christopher Priest', 'Priest')], ...}, pub_publishers={145: 'Harper & Row'}, pub_series={10795: 'An Ursula Nordstrom Book'}, 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 = (13281, 'Faster Than Light', 'FSTRLGHT2C1976', '1976-00-00', 145, 'xix+321', 'hc', 'ANTHOLOGY', '0060109521', 'http://www.isfdb.org/wiki/images/9/92/FSTRLGHT2C1976.jpg', '$8.95', 191760, 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=13281, displayed_value='Faster Than Light', 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 = 13281 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=13281) |
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=13281' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=13281') |
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=13281' |
/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=13281') |
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=13281' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''