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 18:08:03 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 = [(55634, 'Xenocide', 'BKTG22693', '1992-01-00', 16853, 'xi+394', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/d/de/BKTG22693.jpg', '$6.98', 143513, None, None, '18852'), (194149, 'Alternate Presidents', 'LTRNTPRSDN1992', '1992-02-00', 16853, 'xi+466', 'hc', 'ANTHOLOGY', None, 'http://www.isfdb.org/wiki/images/7/79/LTRNTPRSDN1992.jpg', '$8.98', 177541, None, None, '19326'), (298728, 'Mirabile', 'MRBLHQLTVP1992', '1992-03-00', 16853, '276', 'hc', 'COLLECTION', None, 'http://www.isfdb.org/wiki/images/1/13/Mirabile0001_%28278x400%29.jpg', '$8.98', None, None, None, '19558'), (300380, 'Our Angry Earth', 'RNGRRTHCWK1992', '1992-04-00', 16853, '323', 'hc', 'NONFICTION', None, 'https://m.media-amazon.com/images/I/51pvKmhz6TL.jpg', '$9.98', 188934, None, None, '19656-8'), (574, 'A Fire Upon the Deep', 'BKTG18987', '1992-05-00', 16853, '391', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/6/6b/BKTG18987.jpg', '$10.98', 231720, None, None, '19136'), (39386, 'The Eye of the World', 'EYOWOL1992A', '1992-05-00', 16853, 'xvii+718', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/9/99/EYOWOL1992A.jpg', '$12.98', 741442, None, None, '19548'), (40954, 'The Great Hunt', 'GRTHUNT1992A', '1992-05-00', 16853, 'xxiv+620', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/9/90/GRTHUNT1992A.jpg', '$12.98', 741440, None, None, '19547'), (360632, 'The Dragon Reborn', 'THDRGNRBRB1992', '1992-05-00', 16853, 'viii+562', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/9/95/THDRGNRBRB1992.jpg', '$12.98', 270063, None, None, '19546'), (21622, 'Master of Lies', 'MSTROLS1992B', '1992-06-00', 16853, '330', 'hc', 'NOVEL', None, 'https://m.media-amazon.com/images/G/01/ciu/53/dd/8c31124128a09f6b5279b010.L.jpg', '$9.98', 448962, None, None, '19365'), (7457, 'Cold As Ice', 'BKTG15950', '1992-07-00', 16853, '309', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/4/4e/BKTG15950.jpg', '$9.98', 212333, None, None, '01549'), (11242, 'Dragons in the Stars', 'DRGNSTRS1992B', '1992-07-00', 16853, '312', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/0/0e/DRGNSTRS1992B.jpg', '$4.98', 153739, None, None, '01673-3'), (31785, 'Spiritwalk', 'BKTG01267', '1992-07-00', 16853, '365', 'hc', 'COLLECTION', None, 'http://www.isfdb.org/wiki/images/b/bc/BKTG01267.jpg', '$9.98', 150671, None, None, '00067'), (40052, 'The Forever King', 'BKTG23640', '1992-10-00', 16853, '364', 'hc', 'NOVEL', None, 'https://m.media-amazon.com/images/G/01/ciu/50/df/c1b7810ae7a0a11c0c19d110.L.jpg', '$10.98', 144731, None, None, '02273'), (301039, 'Flying in Place', 'FLNGNPLCQR1992', '1992-10-00', 16853, '179', 'hc', 'NOVEL', None, 'https://m.media-amazon.com/images/G/01/ciu/0b/12/fc8eb2c008a02070e1618010.L.jpg', '$8.98', 189858, None, None, '03397'), (11462, 'Dreamships', 'BKTG15688', '1992-11-00', 16853, 'viii+342', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/c/c0/BKTG15688.jpg', '$6.98', 247369, None, None, '02778'), (19181, 'Jumper', 'BKTG04604', '1992-11-00', 16853, '344', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/0/09/BKTG04604.jpg', '$9.98', 334749, None, None, '02780'), (3031, 'Aristoi', 'BKTG20008', '1992-12-00', 16853, '448', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/7/7c/BKTG20008.jpg', '$10.98', 339235, None, None, '03502'), (287469, 'Christmas Stars', 'CHRSTMSSTR1992', '1992-12-00', 16853, '305', 'hc', 'ANTHOLOGY', None, 'http://www.isfdb.org/wiki/images/f/f4/CHRSTMSSTR1992.jpg', '$8.98', 168732, None, None, '03340')] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(55634, 'Xenocide', 'BKTG22693', '1992-01-00', 16853, 'xi+394', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/d/de/BKTG22693.jpg', '$6.98', 143513, None, None, '18852'), (194149, 'Alternate Presidents', 'LTRNTPRSDN1992', '1992-02-00', 16853, 'xi+466', 'hc', 'ANTHOLOGY', None, 'http://www.isfdb.org/wiki/images/7/79/LTRNTPRSDN1992.jpg', '$8.98', 177541, None, None, '19326'), (298728, 'Mirabile', 'MRBLHQLTVP1992', '1992-03-00', 16853, '276', 'hc', 'COLLECTION', None, 'http://www.isfdb.org/wiki/images/1/13/Mirabile0001_%28278x400%29.jpg', '$8.98', None, None, None, '19558'), (300380, 'Our Angry Earth', 'RNGRRTHCWK1992', '1992-04-00', 16853, '323', 'hc', 'NONFICTION', None, 'https://m.media-amazon.com/images/I/51pvKmhz6TL.jpg', '$9.98', 188934, None, None, '19656-8'), (574, 'A Fire Upon the Deep', 'BKTG18987', '1992-05-00', 16853, '391', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/6/6b/BKTG18987.jpg', '$10.98', 231720, None, None, '19136'), (39386, 'The Eye of the World', 'EYOWOL1992A', '1992-05-00', 16853, 'xvii+718', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/9/99/EYOWOL1992A.jpg', '$12.98', 741442, None, None, '19548'), (40954, 'The Great Hunt', 'GRTHUNT1992A', '1992-05-00', 16853, 'xxiv+620', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/9/90/GRTHUNT1992A.jpg', '$12.98', 741440, None, None, '19547'), (360632, 'The Dragon Reborn', 'THDRGNRBRB1992', '1992-05-00', 16853, 'viii+562', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/9/95/THDRGNRBRB1992.jpg', '$12.98', 270063, None, None, '19546'), (21622, 'Master of Lies', 'MSTROLS1992B', '1992-06-00', 16853, '330', 'hc', 'NOVEL', None, 'https://m.media-amazon.com/images/G/01/ciu/53/dd/8c31124128a09f6b5279b010.L.jpg', '$9.98', 448962, None, None, '19365'), (7457, 'Cold As Ice', 'BKTG15950', '1992-07-00', 16853, '309', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/4/4e/BKTG15950.jpg', '$9.98', 212333, None, None, '01549'), (11242, 'Dragons in the Stars', 'DRGNSTRS1992B', '1992-07-00', 16853, '312', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/0/0e/DRGNSTRS1992B.jpg', '$4.98', 153739, None, None, '01673-3'), (31785, 'Spiritwalk', 'BKTG01267', '1992-07-00', 16853, '365', 'hc', 'COLLECTION', None, 'http://www.isfdb.org/wiki/images/b/bc/BKTG01267.jpg', '$9.98', 150671, None, None, '00067'), (40052, 'The Forever King', 'BKTG23640', '1992-10-00', 16853, '364', 'hc', 'NOVEL', None, 'https://m.media-amazon.com/images/G/01/ciu/50/df/c1b7810ae7a0a11c0c19d110.L.jpg', '$10.98', 144731, None, None, '02273'), (301039, 'Flying in Place', 'FLNGNPLCQR1992', '1992-10-00', 16853, '179', 'hc', 'NOVEL', None, 'https://m.media-amazon.com/images/G/01/ciu/0b/12/fc8eb2c008a02070e1618010.L.jpg', '$8.98', 189858, None, None, '03397'), (11462, 'Dreamships', 'BKTG15688', '1992-11-00', 16853, 'viii+342', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/c/c0/BKTG15688.jpg', '$6.98', 247369, None, None, '02778'), (19181, 'Jumper', 'BKTG04604', '1992-11-00', 16853, '344', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/0/09/BKTG04604.jpg', '$9.98', 334749, None, None, '02780'), (3031, 'Aristoi', 'BKTG20008', '1992-12-00', 16853, '448', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/7/7c/BKTG20008.jpg', '$10.98', 339235, None, None, '03502'), (287469, 'Christmas Stars', 'CHRSTMSSTR1992', '1992-12-00', 16853, '305', 'hc', 'ANTHOLOGY', None, 'http://www.isfdb.org/wiki/images/f/f4/CHRSTMSSTR1992.jpg', '$8.98', 168732, None, None, '03340')], 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 = (55634, 'Xenocide', 'BKTG22693', '1992-01-00', 16853, 'xi+394', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/d/de/BKTG22693.jpg', '$6.98', 143513, None, None, '18852'), pub_authors = {574: [(61, 'Vernor Vinge', 'Vinge')], 3031: [(669, 'Walter Jon Williams', 'Williams')], 7457: [(210, 'Charles Sheffield', 'Sheffield')], 11242: [(370, 'Jeffrey A. Carver', 'Carver')], 11462: [(1030, 'Melissa Scott', 'Scott')], 19181: [(1386, 'Steven Gould', 'Gould')], 21622: [(1279, 'Graham Masterton', 'Masterton')], 31785: [(178, 'Charles de Lint', 'de Lint')], 39386: [(845, 'Robert Jordan', 'Jordan')], 40052: [(3145, 'Molly Cochran', 'Cochran'), (1414, 'Warren Murphy', 'Murphy')], ...}, pub_publishers = {16853: 'Tor / SFBC'}, 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=(55634, 'Xenocide', 'BKTG22693', '1992-01-00', 16853, 'xi+394', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/d/de/BKTG22693.jpg', '$6.98', 143513, None, None, '18852'), pub_authors={574: [(61, 'Vernor Vinge', 'Vinge')], 3031: [(669, 'Walter Jon Williams', 'Williams')], 7457: [(210, 'Charles Sheffield', 'Sheffield')], 11242: [(370, 'Jeffrey A. Carver', 'Carver')], 11462: [(1030, 'Melissa Scott', 'Scott')], 19181: [(1386, 'Steven Gould', 'Gould')], 21622: [(1279, 'Graham Masterton', 'Masterton')], 31785: [(178, 'Charles de Lint', 'de Lint')], 39386: [(845, 'Robert Jordan', 'Jordan')], 40052: [(3145, 'Molly Cochran', 'Cochran'), (1414, 'Warren Murphy', 'Murphy')], ...}, pub_publishers={16853: 'Tor / SFBC'}, 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 = (55634, 'Xenocide', 'BKTG22693', '1992-01-00', 16853, 'xi+394', 'hc', 'NOVEL', None, 'http://www.isfdb.org/wiki/images/d/de/BKTG22693.jpg', '$6.98', 143513, None, None, '18852'), 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=55634, displayed_value='Xenocide', 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 = 55634 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=55634) |
| 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=55634' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=55634') |
| 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=55634' |
| /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=55634') |
| 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=55634' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''