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 17:05:41 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 = [(328378, 'The Jewel in the Skull', 'THJWLNTHSC1977', '1977-01-00', 45302, '176', 'pb', 'NOVEL', '0879972769', 'http://www.isfdb.org/wiki/images/b/b1/THJWLNTHSC1977.jpg', 'C$1.25', 232551, None, '', 'UY1276'), (422386, 'Supermind', 'SPRMNDQSXK1977', '1977-01-00', 45302, '176', 'pb', 'NOVEL', '0879972750', 'http://www.isfdb.org/wiki/images/6/6b/SPRMND661977.jpg', 'C$1.25', 349466, None, None, 'UY1275'), (424180, 'Naked to the Stars', 'NKDTTHSTRS1977', '1977-01-00', 45302, '159', 'pb', 'NOVEL', '0879972785', 'http://www.isfdb.org/wiki/images/1/18/NKDTTHSTRS471977.jpg', 'C$1.50', 351775, None, None, 'UW1278'), (809195, 'Drinking Sapphire Wine', 'DRNKNGSPPH1977', '1977-01-00', 45302, '175', 'pb', 'NOVEL', '0879972777', 'https://m.media-amazon.com/images/G/01/ciu/d8/60/a573124128a0167961426010.L.jpg', 'C$1.25', 918057, 1544, '226', 'UY1277'), (421717, 'Legends from the End of Time', 'LGNDSFRMTB1977', '1977-02-00', 45302, '175', 'pb', 'COLLECTION', '0879972815', 'http://www.isfdb.org/wiki/images/a/a6/LGNDSFRMTH1977.jpg', 'C$1.25', 348619, None, None, 'UY1281'), (331807, 'The Panchronicon Plot', 'THPNCHRNCN1977', '1977-02-00', 45302, '156', 'pb', 'NOVEL', '0879972831', 'http://www.isfdb.org/wiki/images/4/42/THPNNPLT4A1977.jpg', 'C$1.25', 236998, None, '', 'UY1283'), (355152, 'The Spell Sword', 'THSPLLSWRD1977', '1977-02-00', 45302, '158', 'pb', 'NOVEL', '087997284X', 'http://www.isfdb.org/wiki/images/5/50/THSPLLSWRD1977.jpg', 'C$1.25', 263894, None, None, 'UY1284'), (420157, 'One Against a Wilderness', 'NGNSTWLDRN1977', '1977-02-00', 45302, '172', 'pb', 'NOVEL', '0879972807', 'http://www.isfdb.org/wiki/images/e/eb/NGNSRNSS481977.jpg', 'C$1.50', 346712, None, None, 'UW1280'), (422132, 'Critical Threshold', 'CRTCLTHRSH1977', '1977-02-00', 45302, '160', 'pb', 'NOVEL', '0879972823', 'http://www.isfdb.org/wiki/images/d/d9/CRTCSHLD491977.jpg', 'C$1.25', 349143, None, None, 'UY1282'), (417799, 'Star Courier', 'STRCRRKWQM1977', '1977-03-00', 45302, '142', 'pb', 'NOVEL', '0879972920', 'http://www.isfdb.org/wiki/images/d/d8/STRCRRKWQM1977.jpg', 'C$1.25', 343789, None, None, 'UY1292'), (421727, 'The Weird of the White Wolf', 'THWRDFTHWH1977', '1977-03-00', 45302, '159', 'pb', 'COLLECTION', '0879972866', 'http://www.isfdb.org/wiki/images/4/45/THWRTWLFBA1977.jpg', 'C$1.25', 348632, None, None, 'UY1286'), (808192, 'Diadem from the Stars', 'DDMFRMTHSB1977', '1977-03-00', 45302, '235', 'pb', 'NOVEL', '0879972939', 'http://www.isfdb.org/wiki/images/1/10/DDMFSTRS4C1977.jpg', 'C$1.50', 916640, 1544, '235', 'UW1293'), (809550, 'Slave Girl of Gor', 'SLVGRLFGRR1977', '1977-03-00', 45302, '446', 'pb', 'NOVEL', '0879972858', 'https://m.media-amazon.com/images/I/51y81nna66L.jpg', 'C$1.95', 918543, 1544, '232', 'UJ1285'), (420869, 'The Gameplayers of Zan', 'THGMPLRSFZ1977', '1977-04-00', 45302, '445', 'pb', 'NOVEL', '0879972874', 'http://www.isfdb.org/wiki/images/4/49/GMPLRS1977.jpg', 'C$1.95', 347545, None, None, 'UJ1287'), (421334, 'The Right Hand of Dextra', 'THRGHTHNDF1977', '1977-04-00', 45302, '176', 'pb', 'NOVEL', '0879972904', 'http://www.isfdb.org/wiki/images/a/ae/RTHNDDXT1977.jpg', 'C$1.50', 348198, 1544, '239', 'UW1290'), (421719, "The Mad God's Amulet", 'THMDGDSMLB1977', '1977-04-00', 45302, '160', 'pb', 'NOVEL', '0879972890', 'http://www.isfdb.org/wiki/images/1/1b/THMDGDSMLT1977.jpg', 'C$1.25', 348622, None, None, 'UY1289'), (563711, 'The Warriors of Dawn', 'THWRRRSFDW1977', '1977-04-00', 45302, '278', 'pb', 'NOVEL', '0879972912', 'http://www.isfdb.org/wiki/images/f/f8/WRRRSD1975.jpg', 'C$1.50', 528890, None, None, 'UW1291'), (801501, 'Krozair of Kregen', 'KRZRFKRGNV1977', '1977-04-00', 45302, '223', 'pb', 'NOVEL', '0879972882', 'http://www.isfdb.org/wiki/images/9/9f/KRZRFKRGN4E1977.jpg', 'C$1.50', 908695, 1544, '237', 'UW1288'), (365257, 'The Book of Frank Herbert', 'THBKFFRNKB1977', '1977-05-00', 45302, '189', 'pb', 'COLLECTION', '0879973013', 'http://www.isfdb.org/wiki/images/0/0e/THBKFFRNKB0000.jpg', 'C$1.50', 276157, None, None, 'UW1301'), (417619, "The Barbarian of World's End", 'THBRBRNFWR1977', '1977-05-00', 45302, '188', 'pb', 'NOVEL', '0879973005', 'http://www.isfdb.org/wiki/images/6/60/THBRDSND521977.jpg', 'C$1.50', 343505, None, None, 'UW1300'), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(328378, 'The Jewel in the Skull', 'THJWLNTHSC1977', '1977-01-00', 45302, '176', 'pb', 'NOVEL', '0879972769', 'http://www.isfdb.org/wiki/images/b/b1/THJWLNTHSC1977.jpg', 'C$1.25', 232551, None, '', 'UY1276'), (422386, 'Supermind', 'SPRMNDQSXK1977', '1977-01-00', 45302, '176', 'pb', 'NOVEL', '0879972750', 'http://www.isfdb.org/wiki/images/6/6b/SPRMND661977.jpg', 'C$1.25', 349466, None, None, 'UY1275'), (424180, 'Naked to the Stars', 'NKDTTHSTRS1977', '1977-01-00', 45302, '159', 'pb', 'NOVEL', '0879972785', 'http://www.isfdb.org/wiki/images/1/18/NKDTTHSTRS471977.jpg', 'C$1.50', 351775, None, None, 'UW1278'), (809195, 'Drinking Sapphire Wine', 'DRNKNGSPPH1977', '1977-01-00', 45302, '175', 'pb', 'NOVEL', '0879972777', 'https://m.media-amazon.com/images/G/01/ciu/d8/60/a573124128a0167961426010.L.jpg', 'C$1.25', 918057, 1544, '226', 'UY1277'), (421717, 'Legends from the End of Time', 'LGNDSFRMTB1977', '1977-02-00', 45302, '175', 'pb', 'COLLECTION', '0879972815', 'http://www.isfdb.org/wiki/images/a/a6/LGNDSFRMTH1977.jpg', 'C$1.25', 348619, None, None, 'UY1281'), (331807, 'The Panchronicon Plot', 'THPNCHRNCN1977', '1977-02-00', 45302, '156', 'pb', 'NOVEL', '0879972831', 'http://www.isfdb.org/wiki/images/4/42/THPNNPLT4A1977.jpg', 'C$1.25', 236998, None, '', 'UY1283'), (355152, 'The Spell Sword', 'THSPLLSWRD1977', '1977-02-00', 45302, '158', 'pb', 'NOVEL', '087997284X', 'http://www.isfdb.org/wiki/images/5/50/THSPLLSWRD1977.jpg', 'C$1.25', 263894, None, None, 'UY1284'), (420157, 'One Against a Wilderness', 'NGNSTWLDRN1977', '1977-02-00', 45302, '172', 'pb', 'NOVEL', '0879972807', 'http://www.isfdb.org/wiki/images/e/eb/NGNSRNSS481977.jpg', 'C$1.50', 346712, None, None, 'UW1280'), (422132, 'Critical Threshold', 'CRTCLTHRSH1977', '1977-02-00', 45302, '160', 'pb', 'NOVEL', '0879972823', 'http://www.isfdb.org/wiki/images/d/d9/CRTCSHLD491977.jpg', 'C$1.25', 349143, None, None, 'UY1282'), (417799, 'Star Courier', 'STRCRRKWQM1977', '1977-03-00', 45302, '142', 'pb', 'NOVEL', '0879972920', 'http://www.isfdb.org/wiki/images/d/d8/STRCRRKWQM1977.jpg', 'C$1.25', 343789, None, None, 'UY1292'), (421727, 'The Weird of the White Wolf', 'THWRDFTHWH1977', '1977-03-00', 45302, '159', 'pb', 'COLLECTION', '0879972866', 'http://www.isfdb.org/wiki/images/4/45/THWRTWLFBA1977.jpg', 'C$1.25', 348632, None, None, 'UY1286'), (808192, 'Diadem from the Stars', 'DDMFRMTHSB1977', '1977-03-00', 45302, '235', 'pb', 'NOVEL', '0879972939', 'http://www.isfdb.org/wiki/images/1/10/DDMFSTRS4C1977.jpg', 'C$1.50', 916640, 1544, '235', 'UW1293'), (809550, 'Slave Girl of Gor', 'SLVGRLFGRR1977', '1977-03-00', 45302, '446', 'pb', 'NOVEL', '0879972858', 'https://m.media-amazon.com/images/I/51y81nna66L.jpg', 'C$1.95', 918543, 1544, '232', 'UJ1285'), (420869, 'The Gameplayers of Zan', 'THGMPLRSFZ1977', '1977-04-00', 45302, '445', 'pb', 'NOVEL', '0879972874', 'http://www.isfdb.org/wiki/images/4/49/GMPLRS1977.jpg', 'C$1.95', 347545, None, None, 'UJ1287'), (421334, 'The Right Hand of Dextra', 'THRGHTHNDF1977', '1977-04-00', 45302, '176', 'pb', 'NOVEL', '0879972904', 'http://www.isfdb.org/wiki/images/a/ae/RTHNDDXT1977.jpg', 'C$1.50', 348198, 1544, '239', 'UW1290'), (421719, "The Mad God's Amulet", 'THMDGDSMLB1977', '1977-04-00', 45302, '160', 'pb', 'NOVEL', '0879972890', 'http://www.isfdb.org/wiki/images/1/1b/THMDGDSMLT1977.jpg', 'C$1.25', 348622, None, None, 'UY1289'), (563711, 'The Warriors of Dawn', 'THWRRRSFDW1977', '1977-04-00', 45302, '278', 'pb', 'NOVEL', '0879972912', 'http://www.isfdb.org/wiki/images/f/f8/WRRRSD1975.jpg', 'C$1.50', 528890, None, None, 'UW1291'), (801501, 'Krozair of Kregen', 'KRZRFKRGNV1977', '1977-04-00', 45302, '223', 'pb', 'NOVEL', '0879972882', 'http://www.isfdb.org/wiki/images/9/9f/KRZRFKRGN4E1977.jpg', 'C$1.50', 908695, 1544, '237', 'UW1288'), (365257, 'The Book of Frank Herbert', 'THBKFFRNKB1977', '1977-05-00', 45302, '189', 'pb', 'COLLECTION', '0879973013', 'http://www.isfdb.org/wiki/images/0/0e/THBKFFRNKB0000.jpg', 'C$1.50', 276157, None, None, 'UW1301'), (417619, "The Barbarian of World's End", 'THBRBRNFWR1977', '1977-05-00', 45302, '188', 'pb', 'NOVEL', '0879973005', 'http://www.isfdb.org/wiki/images/6/60/THBRDSND521977.jpg', 'C$1.50', 343505, None, None, 'UW1300'), ...], 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 = (328378, 'The Jewel in the Skull', 'THJWLNTHSC1977', '1977-01-00', 45302, '176', 'pb', 'NOVEL', '0879972769', 'http://www.isfdb.org/wiki/images/b/b1/THJWLNTHSC1977.jpg', 'C$1.25', 232551, None, '', 'UY1276'), pub_authors = {271787: [(185, 'Marion Zimmer Bradley', 'Bradley')], 328378: [(140, 'Michael Moorcock', 'Moorcock')], 330240: [(113, 'E. C. Tubb', 'Tubb')], 331807: [(824, 'Ron Goulart', 'Goulart')], 355152: [(185, 'Marion Zimmer Bradley', 'Bradley')], 365257: [(30, 'Frank Herbert', 'Herbert')], 369692: [(262, 'Philip Wylie', 'Wylie')], 402282: [(2598, 'Alan Burt Akers', 'Akers')], 417279: [(322, 'Neal Barrett, Jr.', 'Barrett')], 417298: [(324, 'Barrington J. Bayley', 'Bayley')], ...}, pub_publishers = {45302: 'DAW Books / New American Library of Canada'}, pub_series = {1544: 'DAW Collectors'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(328378, 'The Jewel in the Skull', 'THJWLNTHSC1977', '1977-01-00', 45302, '176', 'pb', 'NOVEL', '0879972769', 'http://www.isfdb.org/wiki/images/b/b1/THJWLNTHSC1977.jpg', 'C$1.25', 232551, None, '', 'UY1276'), pub_authors={271787: [(185, 'Marion Zimmer Bradley', 'Bradley')], 328378: [(140, 'Michael Moorcock', 'Moorcock')], 330240: [(113, 'E. C. Tubb', 'Tubb')], 331807: [(824, 'Ron Goulart', 'Goulart')], 355152: [(185, 'Marion Zimmer Bradley', 'Bradley')], 365257: [(30, 'Frank Herbert', 'Herbert')], 369692: [(262, 'Philip Wylie', 'Wylie')], 402282: [(2598, 'Alan Burt Akers', 'Akers')], 417279: [(322, 'Neal Barrett, Jr.', 'Barrett')], 417298: [(324, 'Barrington J. Bayley', 'Bayley')], ...}, pub_publishers={45302: 'DAW Books / New American Library of Canada'}, pub_series={1544: 'DAW Collectors'}, 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 = (328378, 'The Jewel in the Skull', 'THJWLNTHSC1977', '1977-01-00', 45302, '176', 'pb', 'NOVEL', '0879972769', 'http://www.isfdb.org/wiki/images/b/b1/THJWLNTHSC1977.jpg', 'C$1.25', 232551, None, '', 'UY1276'), 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=328378, displayed_value='The Jewel in the Skull', 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 = 328378 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=328378) |
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=328378' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=328378') |
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=328378' |
/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=328378') |
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=328378' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''