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 09:58:42 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 = [(365866, "L'imaginaire m\xc3\xa9dical dans le Fantastique et la Science-Fiction", 'LMGNRMDCLD2011', '2011-01-00', 5752, '376', 'tp', 'NONFICTION', '9782352944423', 'http://www.isfdb.org/wiki/images/6/6c/LMGNRMDCLD2011.jpg', '\xe2\x82\xac40.00', 276891, 635, None, None), (870685, 'La l\xc3\xa9gion de la terreur', 'LLGNDLTRRB2011', '2011-01-00', 5752, '379', 'tp', 'NOVEL', '9782352944515', 'http://www.isfdb.org/wiki/images/5/51/LLGNDLTRRB2011.jpg', '\xe2\x82\xac20.00', 997089, None, None, None), (862095, "La mission de l'ambassadeur", 'LMSSNDLMBB2011', '2011-01-00', 5752, '452', 'hc', 'NOVEL', '9782352944522', 'http://www.isfdb.org/wiki/images/f/f5/LMSSNDLMBB2011.jpg', '\xe2\x82\xac28.00', 985010, None, None, None), (777409, "L'\xc3\xa9treinte de la nuit", 'CSSNDRPLMR0000', '2011-01-11', 5752, '512', 'pb', 'NOVEL', '9782811204549', 'https://m.media-amazon.com/images/I/51p0NJj0OwL.jpg', '\xe2\x82\xac', 877384, None, None, None), (565553, "La ma\xc3\xaetresse de l'hiver", 'LMTRSSDLHV2011', '2011-01-21', 5752, '576', 'tp', 'NOVEL', '9782352944485', 'https://m.media-amazon.com/images/I/51Ydvu1l6YL.jpg', None, 532167, None, None, None), (565554, 'Tanequil', 'TNQLNZFKKC2011', '2011-01-21', 5752, '384', 'tp', 'NOVEL', '9782352944508', 'https://m.media-amazon.com/images/I/41HcXB4FCsL.jpg', None, 532176, None, None, None), (565556, 'Les traqueurs de la nuit', 'LSTRQRSDLN2011', '2011-01-21', 5752, '544', 'tp', 'NOVEL', '9782352944492', 'https://m.media-amazon.com/images/I/51-aIXA9tBL.jpg', None, 532178, None, None, None), (565602, 'Frey', 'FRSDVVSCZQ2011', '2011-01-21', 5752, '432', 'tp', 'NOVEL', '9782352944461', 'https://m.media-amazon.com/images/I/51Er0BSfVEL.jpg', None, 532234, None, None, None), (565804, "L'ombre d'une inquisitrice", 'LBRDNNQSTR2011', '2011-02-00', 5752, '571', 'tp', 'NOVEL', '9782352944614', 'http://www.isfdb.org/wiki/images/5/5d/LBRDNNQSTR2011.jpg', '\xe2\x82\xac25.00', 532535, None, None, None), (784218, "Dette d'os", 'DTTDSPSVFS2011', '2011-02-00', 5752, '117', 'hc', 'CHAPBOOK', '9782352942429', 'http://www.isfdb.org/wiki/images/1/19/DTTDSPSVFS2011.jpg', '\xe2\x82\xac15.00', 886574, None, None, None), (562532, 'Temp\xc3\xaate solaire', 'TMPTSLRNLR2011', '2011-02-18', 5752, '630', 'tp', 'NOVEL', '9782352944546', 'https://m.media-amazon.com/images/I/51n4cRtO4rL.jpg', '\xe2\x82\xac20.30', 526861, None, None, None), (562900, "Fille de l'empire", 'FLLDLMPRTF2011', '2011-02-18', 5752, '408', 'tp', 'NOVEL', '9782352944560', 'https://m.media-amazon.com/images/I/51C5RSfaZ7L.jpg', '\xe2\x82\xac22.40', 527392, None, None, None), (562962, "Ma\xc3\xaetresse de l'empire", 'MTRSSDLMPR2011', '2011-02-18', 5752, '624', 'tp', 'NOVEL', '9782352944584', 'https://m.media-amazon.com/images/I/513UDwmCFOL.jpg', '\xe2\x82\xac25.00', 527465, None, None, None), (562973, "Pair de l'empire", 'PRDLMPRMNL2011', '2011-02-18', 5752, '600', 'tp', 'NOVEL', '9782352944577', 'https://m.media-amazon.com/images/I/51QKTr8x7eL.jpg', '\xe2\x82\xac25.00', 527482, None, None, None), (565687, "La mission de l'ambassadeur", 'LMSSNDLMBS2011', '2011-02-18', 5752, '456', 'hc', 'NOVEL', '9782352944522', 'https://m.media-amazon.com/images/I/51SpUDHqGHL.jpg', None, 532411, None, None, None), (565803, 'Dragon master', 'DRGNMSTRLR2011', '2011-02-18', 5752, '792', 'tp', 'OMNIBUS', '9782352944539', 'https://m.media-amazon.com/images/I/61ivmMzRF0L.jpg', None, 532534, 4615, None, None), (566370, 'La voix des dieux', 'LVXDSDXGDT2011', '2011-02-18', 5752, '528', 'tp', 'NOVEL', '9782352944553', 'https://m.media-amazon.com/images/I/51Jtn7RNQdL.jpg', None, 533405, None, None, None), (562358, "L'alliance des h\xc3\xa9r\xc3\xa9tiques", 'LLLNCDSHRT2011', '2011-03-00', 5752, '639', 'tp', 'NOVEL', '9782352944737', 'http://www.isfdb.org/wiki/images/8/87/LLLNCDSHRT2011.jpg', '\xe2\x82\xac25.00', 526544, None, None, None), (859491, 'Le gouffre noir', 'LGFFRNRLLF2011', '2011-03-00', 5752, '333', 'tp', 'NOVEL', '9782352944706', 'http://www.isfdb.org/wiki/images/5/56/LGFFRNRLLF2011.jpg', '\xe2\x82\xac20.00', 980852, None, None, None), (562449, 'La cit\xc3\xa9 \xc3\xa1 la fin des temps', 'LCTLFNDSTM2011', '2011-03-18', 5752, '480', 'tp', 'NOVEL', '9782352944591', 'https://m.media-amazon.com/images/I/51dDwDPZOoL.jpg', '\xe2\x82\xac22.40', 526669, None, None, None), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(365866, "L'imaginaire m\xc3\xa9dical dans le Fantastique et la Science-Fiction", 'LMGNRMDCLD2011', '2011-01-00', 5752, '376', 'tp', 'NONFICTION', '9782352944423', 'http://www.isfdb.org/wiki/images/6/6c/LMGNRMDCLD2011.jpg', '\xe2\x82\xac40.00', 276891, 635, None, None), (870685, 'La l\xc3\xa9gion de la terreur', 'LLGNDLTRRB2011', '2011-01-00', 5752, '379', 'tp', 'NOVEL', '9782352944515', 'http://www.isfdb.org/wiki/images/5/51/LLGNDLTRRB2011.jpg', '\xe2\x82\xac20.00', 997089, None, None, None), (862095, "La mission de l'ambassadeur", 'LMSSNDLMBB2011', '2011-01-00', 5752, '452', 'hc', 'NOVEL', '9782352944522', 'http://www.isfdb.org/wiki/images/f/f5/LMSSNDLMBB2011.jpg', '\xe2\x82\xac28.00', 985010, None, None, None), (777409, "L'\xc3\xa9treinte de la nuit", 'CSSNDRPLMR0000', '2011-01-11', 5752, '512', 'pb', 'NOVEL', '9782811204549', 'https://m.media-amazon.com/images/I/51p0NJj0OwL.jpg', '\xe2\x82\xac', 877384, None, None, None), (565553, "La ma\xc3\xaetresse de l'hiver", 'LMTRSSDLHV2011', '2011-01-21', 5752, '576', 'tp', 'NOVEL', '9782352944485', 'https://m.media-amazon.com/images/I/51Ydvu1l6YL.jpg', None, 532167, None, None, None), (565554, 'Tanequil', 'TNQLNZFKKC2011', '2011-01-21', 5752, '384', 'tp', 'NOVEL', '9782352944508', 'https://m.media-amazon.com/images/I/41HcXB4FCsL.jpg', None, 532176, None, None, None), (565556, 'Les traqueurs de la nuit', 'LSTRQRSDLN2011', '2011-01-21', 5752, '544', 'tp', 'NOVEL', '9782352944492', 'https://m.media-amazon.com/images/I/51-aIXA9tBL.jpg', None, 532178, None, None, None), (565602, 'Frey', 'FRSDVVSCZQ2011', '2011-01-21', 5752, '432', 'tp', 'NOVEL', '9782352944461', 'https://m.media-amazon.com/images/I/51Er0BSfVEL.jpg', None, 532234, None, None, None), (565804, "L'ombre d'une inquisitrice", 'LBRDNNQSTR2011', '2011-02-00', 5752, '571', 'tp', 'NOVEL', '9782352944614', 'http://www.isfdb.org/wiki/images/5/5d/LBRDNNQSTR2011.jpg', '\xe2\x82\xac25.00', 532535, None, None, None), (784218, "Dette d'os", 'DTTDSPSVFS2011', '2011-02-00', 5752, '117', 'hc', 'CHAPBOOK', '9782352942429', 'http://www.isfdb.org/wiki/images/1/19/DTTDSPSVFS2011.jpg', '\xe2\x82\xac15.00', 886574, None, None, None), (562532, 'Temp\xc3\xaate solaire', 'TMPTSLRNLR2011', '2011-02-18', 5752, '630', 'tp', 'NOVEL', '9782352944546', 'https://m.media-amazon.com/images/I/51n4cRtO4rL.jpg', '\xe2\x82\xac20.30', 526861, None, None, None), (562900, "Fille de l'empire", 'FLLDLMPRTF2011', '2011-02-18', 5752, '408', 'tp', 'NOVEL', '9782352944560', 'https://m.media-amazon.com/images/I/51C5RSfaZ7L.jpg', '\xe2\x82\xac22.40', 527392, None, None, None), (562962, "Ma\xc3\xaetresse de l'empire", 'MTRSSDLMPR2011', '2011-02-18', 5752, '624', 'tp', 'NOVEL', '9782352944584', 'https://m.media-amazon.com/images/I/513UDwmCFOL.jpg', '\xe2\x82\xac25.00', 527465, None, None, None), (562973, "Pair de l'empire", 'PRDLMPRMNL2011', '2011-02-18', 5752, '600', 'tp', 'NOVEL', '9782352944577', 'https://m.media-amazon.com/images/I/51QKTr8x7eL.jpg', '\xe2\x82\xac25.00', 527482, None, None, None), (565687, "La mission de l'ambassadeur", 'LMSSNDLMBS2011', '2011-02-18', 5752, '456', 'hc', 'NOVEL', '9782352944522', 'https://m.media-amazon.com/images/I/51SpUDHqGHL.jpg', None, 532411, None, None, None), (565803, 'Dragon master', 'DRGNMSTRLR2011', '2011-02-18', 5752, '792', 'tp', 'OMNIBUS', '9782352944539', 'https://m.media-amazon.com/images/I/61ivmMzRF0L.jpg', None, 532534, 4615, None, None), (566370, 'La voix des dieux', 'LVXDSDXGDT2011', '2011-02-18', 5752, '528', 'tp', 'NOVEL', '9782352944553', 'https://m.media-amazon.com/images/I/51Jtn7RNQdL.jpg', None, 533405, None, None, None), (562358, "L'alliance des h\xc3\xa9r\xc3\xa9tiques", 'LLLNCDSHRT2011', '2011-03-00', 5752, '639', 'tp', 'NOVEL', '9782352944737', 'http://www.isfdb.org/wiki/images/8/87/LLLNCDSHRT2011.jpg', '\xe2\x82\xac25.00', 526544, None, None, None), (859491, 'Le gouffre noir', 'LGFFRNRLLF2011', '2011-03-00', 5752, '333', 'tp', 'NOVEL', '9782352944706', 'http://www.isfdb.org/wiki/images/5/56/LGFFRNRLLF2011.jpg', '\xe2\x82\xac20.00', 980852, None, None, None), (562449, 'La cit\xc3\xa9 \xc3\xa1 la fin des temps', 'LCTLFNDSTM2011', '2011-03-18', 5752, '480', 'tp', 'NOVEL', '9782352944591', 'https://m.media-amazon.com/images/I/51dDwDPZOoL.jpg', '\xe2\x82\xac22.40', 526669, 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 = (365866, "L'imaginaire m\xc3\xa9dical dans le Fantastique et la Science-Fiction", 'LMGNRMDCLD2011', '2011-01-00', 5752, '376', 'tp', 'NONFICTION', '9782352944423', 'http://www.isfdb.org/wiki/images/6/6c/LMGNRMDCLD2011.jpg', '\xe2\x82\xac40.00', 276891, 635, None, None), pub_authors = {365866: [(164369, 'J\xc3\xa9r\xc3\xb4me Goffette', 'Goffette'), (97589, 'Lauric Guillaud', 'Guillaud')], 562273: [(897, 'Jon Courtenay Grimwood', 'Grimwood')], 562276: [(47571, 'Ken Scholes', 'Scholes')], 562358: [(2243, 'David Weber', 'Weber')], 562449: [(9, 'Greg Bear', 'Bear')], 562467: [(3375, 'Kay Kenyon', 'Kenyon')], 562518: [(82, 'Kevin J. Anderson', 'Anderson')], 562520: [(82, 'Kevin J. Anderson', 'Anderson')], 562522: [(7094, 'Michael Cobley', 'Cobley')], 562532: [(102, 'Stephen Baxter', 'Baxter'), (17, 'Arthur C. Clarke', 'Clarke')], ...}, pub_publishers = {5752: 'Bragelonne'}, pub_series = {635: 'Bragelonne - Essais', 4592: "L'ombre", 4615: 'Les int\xc3\xa9grales', 8984: '10 ans, 10 romans'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(365866, "L'imaginaire m\xc3\xa9dical dans le Fantastique et la Science-Fiction", 'LMGNRMDCLD2011', '2011-01-00', 5752, '376', 'tp', 'NONFICTION', '9782352944423', 'http://www.isfdb.org/wiki/images/6/6c/LMGNRMDCLD2011.jpg', '\xe2\x82\xac40.00', 276891, 635, None, None), pub_authors={365866: [(164369, 'J\xc3\xa9r\xc3\xb4me Goffette', 'Goffette'), (97589, 'Lauric Guillaud', 'Guillaud')], 562273: [(897, 'Jon Courtenay Grimwood', 'Grimwood')], 562276: [(47571, 'Ken Scholes', 'Scholes')], 562358: [(2243, 'David Weber', 'Weber')], 562449: [(9, 'Greg Bear', 'Bear')], 562467: [(3375, 'Kay Kenyon', 'Kenyon')], 562518: [(82, 'Kevin J. Anderson', 'Anderson')], 562520: [(82, 'Kevin J. Anderson', 'Anderson')], 562522: [(7094, 'Michael Cobley', 'Cobley')], 562532: [(102, 'Stephen Baxter', 'Baxter'), (17, 'Arthur C. Clarke', 'Clarke')], ...}, pub_publishers={5752: 'Bragelonne'}, pub_series={635: 'Bragelonne - Essais', 4592: "L'ombre", 4615: 'Les int\xc3\xa9grales', 8984: '10 ans, 10 romans'}, 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 = (365866, "L'imaginaire m\xc3\xa9dical dans le Fantastique et la Science-Fiction", 'LMGNRMDCLD2011', '2011-01-00', 5752, '376', 'tp', 'NONFICTION', '9782352944423', 'http://www.isfdb.org/wiki/images/6/6c/LMGNRMDCLD2011.jpg', '\xe2\x82\xac40.00', 276891, 635, 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=365866, displayed_value="L'imaginaire m\xc3\xa9dical dans le Fantastique et la Science-Fiction", 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 = 365866 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=365866) |
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=365866' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=365866') |
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=365866' |
/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=365866') |
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=365866' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''