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 10:04:48 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 = [(270259, 'The Shadow in the North', 'THSHDWNTHN0000', '0000-00-00', 645, '279', 'tp', 'NOVEL', '0439977819', 'https://m.media-amazon.com/images/I/515MPR3JR0L.jpg', '\xc2\xa35.99', 144863, None, None, None), (270262, 'The Tin Princess', 'THTNPRNCSS0000', '0000-00-00', 645, '276', 'tp', 'NOVEL', '0439977797', 'https://m.media-amazon.com/images/G/01/ciu/0d/95/a69d810ae7a0f1d61c0fb110.L.jpg', '\xc2\xa35.99', 144866, None, None, None), (270265, 'The Ruby in the Smoke', 'THRBNTHSMK0000', '0000-00-00', 645, '207', 'tp', 'NOVEL', '0439010772', 'https://m.media-amazon.com/images/P/0439010772.jpg', '\xc2\xa35.99', 144869, None, None, None), (627168, 'The Tiger in the Well', 'THTGRNTHWL0000', '0000-00-00', 645, 'x+431', 'tp', 'NOVEL', '0439977800', 'http://www.isfdb.org/wiki/images/1/1f/THTGRNTHWL0000.jpg', '\xc2\xa35.99', 633018, None, None, None), (358209, 'Mortal Engines', 'MRTLNGNSGQ0000', '0000-00-00', 645, '293', 'tp', 'NOVEL', '0439979439', 'http://www.isfdb.org/wiki/images/7/7f/MRTLNGNSGQ0000.jpg', '\xc2\xa35.99', 267309, None, None, None), (497667, 'Catching Fire', 'CTCHNGFRRG0000', '0000-00-00', 645, '472', 'tp', 'NOVEL', '9781407132099', 'https://m.media-amazon.com/images/I/41zlC0LiZcL.jpg', 'A$', 441817, None, None, None), (498099, 'Bad Dog and Those Crazee Martians!', 'BDDGNDTHSC0000', '0000-00-00', 645, '173+[3]', 'tp', 'NOVEL', '0439994438', 'http://www.isfdb.org/wiki/images/1/19/BDDGNDTHSC0000.jpg', '\xc2\xa33.99', 442357, None, None, None), (531397, 'Click', 'CLCKDLXTPB0000', '0000-00-00', 645, '217', 'tp', 'NOVEL', '9781407105918', 'http://www.isfdb.org/wiki/images/8/8e/CLCKDLXTPB0000.jpg', '\xc2\xa36.99', 483085, None, None, None), (555752, 'Thirteen More Tales of Horror', 'THRTNMRTLS0000', '0000-00-00', 645, '365', 'pb', 'ANTHOLOGY', '0590556053', 'http://www.isfdb.org/wiki/images/0/08/THRTNMRTLS1994.jpg', '\xc2\xa34.99', 513539, 1647, None, None), (627171, 'The Ruby in the Smoke', 'THRBNTHSMB0000', '0000-00-00', 645, 'x+207', 'tp', 'NOVEL', '0439977789', 'http://www.isfdb.org/wiki/images/8/8f/THRBNTHSMB0000.jpg', '\xc2\xa35.99', 633021, None, None, None), (641682, 'The Amber Spyglass', 'THMBRSPGLC0000', '0000-00-00', 645, '548', 'tp', 'NOVEL', '043999358X', 'http://www.isfdb.org/wiki/images/2/21/THMBRSPGLC0000.jpg', '\xc2\xa36.99', 656303, None, None, None), (663467, 'Catching Fire', 'CTCHNGFRNJ0000', '0000-00-00', 645, '439', 'tp', 'NOVEL', '9781407109367', None, '\xc2\xa37.99', 691959, None, None, None), (663468, 'The Hunger Games', 'THHNGRGMSJ0000', '0000-00-00', 645, '436', 'tp', 'NOVEL', '9781407109084', None, '\xc2\xa37.99', 691960, None, None, None), (663475, 'Mockingjay', 'MCKNGJDPXQ0000', '0000-00-00', 645, '441', 'tp', 'NOVEL', '9781407109374', 'https://m.media-amazon.com/images/I/51NO301g1rL.jpg', '\xc2\xa37.99', 691968, None, None, None), (666038, 'Mockingjay', 'MCKNGJHXGD0000', '0000-00-00', 645, '458', 'tp', 'NOVEL', '9781407109374', 'http://www.isfdb.org/wiki/images/6/60/MCKNGJHXGD0000.jpg', '\xc2\xa37.99', 696218, None, None, None)] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(270259, 'The Shadow in the North', 'THSHDWNTHN0000', '0000-00-00', 645, '279', 'tp', 'NOVEL', '0439977819', 'https://m.media-amazon.com/images/I/515MPR3JR0L.jpg', '\xc2\xa35.99', 144863, None, None, None), (270262, 'The Tin Princess', 'THTNPRNCSS0000', '0000-00-00', 645, '276', 'tp', 'NOVEL', '0439977797', 'https://m.media-amazon.com/images/G/01/ciu/0d/95/a69d810ae7a0f1d61c0fb110.L.jpg', '\xc2\xa35.99', 144866, None, None, None), (270265, 'The Ruby in the Smoke', 'THRBNTHSMK0000', '0000-00-00', 645, '207', 'tp', 'NOVEL', '0439010772', 'https://m.media-amazon.com/images/P/0439010772.jpg', '\xc2\xa35.99', 144869, None, None, None), (627168, 'The Tiger in the Well', 'THTGRNTHWL0000', '0000-00-00', 645, 'x+431', 'tp', 'NOVEL', '0439977800', 'http://www.isfdb.org/wiki/images/1/1f/THTGRNTHWL0000.jpg', '\xc2\xa35.99', 633018, None, None, None), (358209, 'Mortal Engines', 'MRTLNGNSGQ0000', '0000-00-00', 645, '293', 'tp', 'NOVEL', '0439979439', 'http://www.isfdb.org/wiki/images/7/7f/MRTLNGNSGQ0000.jpg', '\xc2\xa35.99', 267309, None, None, None), (497667, 'Catching Fire', 'CTCHNGFRRG0000', '0000-00-00', 645, '472', 'tp', 'NOVEL', '9781407132099', 'https://m.media-amazon.com/images/I/41zlC0LiZcL.jpg', 'A$', 441817, None, None, None), (498099, 'Bad Dog and Those Crazee Martians!', 'BDDGNDTHSC0000', '0000-00-00', 645, '173+[3]', 'tp', 'NOVEL', '0439994438', 'http://www.isfdb.org/wiki/images/1/19/BDDGNDTHSC0000.jpg', '\xc2\xa33.99', 442357, None, None, None), (531397, 'Click', 'CLCKDLXTPB0000', '0000-00-00', 645, '217', 'tp', 'NOVEL', '9781407105918', 'http://www.isfdb.org/wiki/images/8/8e/CLCKDLXTPB0000.jpg', '\xc2\xa36.99', 483085, None, None, None), (555752, 'Thirteen More Tales of Horror', 'THRTNMRTLS0000', '0000-00-00', 645, '365', 'pb', 'ANTHOLOGY', '0590556053', 'http://www.isfdb.org/wiki/images/0/08/THRTNMRTLS1994.jpg', '\xc2\xa34.99', 513539, 1647, None, None), (627171, 'The Ruby in the Smoke', 'THRBNTHSMB0000', '0000-00-00', 645, 'x+207', 'tp', 'NOVEL', '0439977789', 'http://www.isfdb.org/wiki/images/8/8f/THRBNTHSMB0000.jpg', '\xc2\xa35.99', 633021, None, None, None), (641682, 'The Amber Spyglass', 'THMBRSPGLC0000', '0000-00-00', 645, '548', 'tp', 'NOVEL', '043999358X', 'http://www.isfdb.org/wiki/images/2/21/THMBRSPGLC0000.jpg', '\xc2\xa36.99', 656303, None, None, None), (663467, 'Catching Fire', 'CTCHNGFRNJ0000', '0000-00-00', 645, '439', 'tp', 'NOVEL', '9781407109367', None, '\xc2\xa37.99', 691959, None, None, None), (663468, 'The Hunger Games', 'THHNGRGMSJ0000', '0000-00-00', 645, '436', 'tp', 'NOVEL', '9781407109084', None, '\xc2\xa37.99', 691960, None, None, None), (663475, 'Mockingjay', 'MCKNGJDPXQ0000', '0000-00-00', 645, '441', 'tp', 'NOVEL', '9781407109374', 'https://m.media-amazon.com/images/I/51NO301g1rL.jpg', '\xc2\xa37.99', 691968, None, None, None), (666038, 'Mockingjay', 'MCKNGJHXGD0000', '0000-00-00', 645, '458', 'tp', 'NOVEL', '9781407109374', 'http://www.isfdb.org/wiki/images/6/60/MCKNGJHXGD0000.jpg', '\xc2\xa37.99', 696218, 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 = (270259, 'The Shadow in the North', 'THSHDWNTHN0000', '0000-00-00', 645, '279', 'tp', 'NOVEL', '0439977819', 'https://m.media-amazon.com/images/I/515MPR3JR0L.jpg', '\xc2\xa35.99', 144863, None, None, None), pub_authors = {270259: [(2692, 'Philip Pullman', 'Pullman')], 270262: [(2692, 'Philip Pullman', 'Pullman')], 270265: [(2692, 'Philip Pullman', 'Pullman')], 358209: [(9369, 'Philip Reeve', 'Reeve')], 497667: [(7476, 'Suzanne Collins', 'Collins')], 498099: [(7395, 'Martin Chatterton', 'Chatterton')], 531397: [(6792, 'David Almond', 'Almond'), (6855, 'Eoin Colfer', 'Colfer'), (107787, 'Roddy Doyle', 'Doyle'), (140513, 'Deborah Ellis', 'Ellis'), (52531, 'Nick Hornby', 'Hornby'), (11189, 'Margo Lanagan', 'Lanagan'), (3122, 'Gregory Maguire', 'Maguire'), (140515, 'Ruth Ozeki', 'Ozeki'), (140516, 'Linda Sue Park', 'Park'), (4290, 'Tim Wynne-Jones', 'Wynne-Jones')], 555752: [(8595, 'A. Finnis', 'Finnis')], 627168: [(2692, 'Philip Pullman', 'Pullman')], 627171: [(2692, 'Philip Pullman', 'Pullman')], ...}, pub_publishers = {645: 'Scholastic UK'}, pub_series = {1647: 'Point Horror'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(270259, 'The Shadow in the North', 'THSHDWNTHN0000', '0000-00-00', 645, '279', 'tp', 'NOVEL', '0439977819', 'https://m.media-amazon.com/images/I/515MPR3JR0L.jpg', '\xc2\xa35.99', 144863, None, None, None), pub_authors={270259: [(2692, 'Philip Pullman', 'Pullman')], 270262: [(2692, 'Philip Pullman', 'Pullman')], 270265: [(2692, 'Philip Pullman', 'Pullman')], 358209: [(9369, 'Philip Reeve', 'Reeve')], 497667: [(7476, 'Suzanne Collins', 'Collins')], 498099: [(7395, 'Martin Chatterton', 'Chatterton')], 531397: [(6792, 'David Almond', 'Almond'), (6855, 'Eoin Colfer', 'Colfer'), (107787, 'Roddy Doyle', 'Doyle'), (140513, 'Deborah Ellis', 'Ellis'), (52531, 'Nick Hornby', 'Hornby'), (11189, 'Margo Lanagan', 'Lanagan'), (3122, 'Gregory Maguire', 'Maguire'), (140515, 'Ruth Ozeki', 'Ozeki'), (140516, 'Linda Sue Park', 'Park'), (4290, 'Tim Wynne-Jones', 'Wynne-Jones')], 555752: [(8595, 'A. Finnis', 'Finnis')], 627168: [(2692, 'Philip Pullman', 'Pullman')], 627171: [(2692, 'Philip Pullman', 'Pullman')], ...}, pub_publishers={645: 'Scholastic UK'}, pub_series={1647: 'Point Horror'}, 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 = (270259, 'The Shadow in the North', 'THSHDWNTHN0000', '0000-00-00', 645, '279', 'tp', 'NOVEL', '0439977819', 'https://m.media-amazon.com/images/I/515MPR3JR0L.jpg', '\xc2\xa35.99', 144863, 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=270259, displayed_value='The Shadow in the North', 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 = 270259 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=270259) |
| 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=270259' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=270259') |
| 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=270259' |
| /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=270259') |
| 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=270259' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''