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 16:13:11 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 = [(375247, 'John Carter of Mars Volume 3', 'JHNCRTRFMR2007', '2007-01-22', 23749, '348', 'hc', 'OMNIBUS', '9781846771583', 'https://m.media-amazon.com/images/I/51Kxd9xmdqL.jpg', '\xc2\xa320.99', 287747, None, None, None), (375258, 'John Carter of Mars Volume 3', 'JHNCRTRFMD2007', '2007-01-22', 23749, '348', 'tp', 'OMNIBUS', '9781846771521', 'https://m.media-amazon.com/images/I/51Kxd9xmdqL.jpg', '\xc2\xa311.99', 287760, None, None, None), (375262, 'John Carter of Mars Volume 5', 'JHNCRTRFMJ2007', '2007-03-15', 23749, '408', 'hc', 'OMNIBUS', '9781846772177', 'https://m.media-amazon.com/images/I/51HiydEHhWL.jpg', '\xc2\xa320.99', 287764, None, None, None), (375259, 'John Carter of Mars Volume 4', 'JHNCRTRFMF2007', '2007-03-15', 23749, '408', 'tp', 'OMNIBUS', '9781846772009', 'https://m.media-amazon.com/images/I/51LR-ADMq3L.jpg', '\xc2\xa312.99', 287761, None, None, None), (375261, 'John Carter of Mars Volume 4', 'JHNCRTRFMH2007', '2007-03-15', 23749, '408', 'hc', 'OMNIBUS', '9781846771996', 'https://m.media-amazon.com/images/I/51LR-ADMq3L.jpg', '\xc2\xa320.99', 287763, None, None, None), (375260, 'John Carter of Mars Volume 5', 'JHNCRTRFMG2007', '2007-03-15', 23749, '408', 'tp', 'OMNIBUS', '9781846772184', 'https://m.media-amazon.com/images/I/51XCDWbF9%2BL.jpg', '\xc2\xa312.99', 287762, None, None, None), (297240, 'Junk Day', 'JNKDGXRKHK2007', '2007-04-13', 23749, '172', 'hc', 'NOVEL', '1846772036', 'https://m.media-amazon.com/images/P/1846772036.jpg', '\xc2\xa318.99', None, None, None, None), (297241, 'Junk Day', 'JNKDVMQXQJ2007', '2007-04-13', 23749, '172', 'tp', 'NOVEL', '1846772044', 'https://m.media-amazon.com/images/P/1846772044.jpg', '\xc2\xa39.99', None, None, None, None), (375256, 'John Carter of Mars, Volume 6', 'JHNCRTRFMB2007', '2007-04-13', 23749, '156', 'tp', 'COLLECTION', '9781846772146', 'https://m.media-amazon.com/images/I/51852nd3srL.jpg', '\xc2\xa38.99', 287758, None, None, None), (375257, 'John Carter of Mars, Volume 6', 'JHNCRTRFMC2007', '2007-04-13', 23749, '156', 'hc', 'COLLECTION', '9781846772139', 'https://m.media-amazon.com/images/I/51852nd3srL.jpg', '\xc2\xa317.99', 287759, None, None, None), (351425, 'Serpent of the Waves', 'SRPNTFTHWV2007', '2007-05-22', 23749, '328', 'tp', 'NOVEL', '9781846771866', 'https://m.media-amazon.com/images/I/51tEUDYjMYL.jpg', '\xc2\xa310.99', 259154, 592, None, None), (351426, 'Dragons of the North', 'DRGNSFTHNR2007', '2007-05-22', 23749, '304', 'tp', 'NOVEL', '9781846771842', 'https://m.media-amazon.com/images/I/51FkyiwbAOL.jpg', '\xc2\xa310.99', 259155, 592, None, None), (351427, 'Wolves of the Tiber', 'WLVSFTHTBR2007', '2007-05-22', 23749, '275', 'tp', 'NOVEL', '9781846771828', 'https://m.media-amazon.com/images/I/51v9pphqo5L.jpg', '\xc2\xa39.99', 259156, 592, None, None), (351428, 'City of Eagles', 'CTFGLSQWRZ2007', '2007-05-22', 23749, '200', 'tp', 'NOVEL', '9781846771880', 'https://m.media-amazon.com/images/I/51SRfmKJR2L.jpg', '\xc2\xa38.99', 259157, 592, None, None), (317345, "Garrett P. Serviss' Science Fiction", 'GRRTTPSRVS2007', '2007-10-00', 23749, '408', 'tp', 'COLLECTION', '9781846773235', None, '\xc2\xa312.99', None, None, None, None), (317346, "Garrett P. Serviss' Science Fiction", 'GRRTTPSRVB2007', '2007-10-00', 23749, '408', 'hc', 'COLLECTION', '9781846773242', 'https://data.fantlab.ru/images/editions/big/122351', '\xc2\xa320.99', None, 2513, None, None), (288589, 'Almuric', 'LMRCMKTFQP2007', '2007-12-00', 23749, '160', 'tp', 'NOVEL', '1846773695', 'http://www.isfdb.org/wiki/images/e/ed/LMRCMKTFQP2007.jpg', '\xc2\xa38.99', 170462, 2513, 'SF28', None), (288590, 'Almuric', 'LMRCVHTWHM2007', '2007-12-00', 23749, '158', 'hc', 'NOVEL', '1846773709', 'http://www.isfdb.org/wiki/images/e/ed/LMRCMKTFQP2007.jpg', '\xc2\xa316.99', 170463, 2513, 'SF28', None), (317347, 'Challenger & Company', 'CHLLNGRCMP2007', '2007-12-00', 23749, '492', 'tp', 'OMNIBUS', '9781846773716', None, '\xc2\xa313.99', None, 2513, 'SF29', None), (317348, 'Challenger & Company', 'CHLLNGRCMB2007', '2007-12-00', 23749, '492', 'hc', 'OMNIBUS', '9781846773723', None, '\xc2\xa321.99', None, 2513, 'SF29', None)] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(375247, 'John Carter of Mars Volume 3', 'JHNCRTRFMR2007', '2007-01-22', 23749, '348', 'hc', 'OMNIBUS', '9781846771583', 'https://m.media-amazon.com/images/I/51Kxd9xmdqL.jpg', '\xc2\xa320.99', 287747, None, None, None), (375258, 'John Carter of Mars Volume 3', 'JHNCRTRFMD2007', '2007-01-22', 23749, '348', 'tp', 'OMNIBUS', '9781846771521', 'https://m.media-amazon.com/images/I/51Kxd9xmdqL.jpg', '\xc2\xa311.99', 287760, None, None, None), (375262, 'John Carter of Mars Volume 5', 'JHNCRTRFMJ2007', '2007-03-15', 23749, '408', 'hc', 'OMNIBUS', '9781846772177', 'https://m.media-amazon.com/images/I/51HiydEHhWL.jpg', '\xc2\xa320.99', 287764, None, None, None), (375259, 'John Carter of Mars Volume 4', 'JHNCRTRFMF2007', '2007-03-15', 23749, '408', 'tp', 'OMNIBUS', '9781846772009', 'https://m.media-amazon.com/images/I/51LR-ADMq3L.jpg', '\xc2\xa312.99', 287761, None, None, None), (375261, 'John Carter of Mars Volume 4', 'JHNCRTRFMH2007', '2007-03-15', 23749, '408', 'hc', 'OMNIBUS', '9781846771996', 'https://m.media-amazon.com/images/I/51LR-ADMq3L.jpg', '\xc2\xa320.99', 287763, None, None, None), (375260, 'John Carter of Mars Volume 5', 'JHNCRTRFMG2007', '2007-03-15', 23749, '408', 'tp', 'OMNIBUS', '9781846772184', 'https://m.media-amazon.com/images/I/51XCDWbF9%2BL.jpg', '\xc2\xa312.99', 287762, None, None, None), (297240, 'Junk Day', 'JNKDGXRKHK2007', '2007-04-13', 23749, '172', 'hc', 'NOVEL', '1846772036', 'https://m.media-amazon.com/images/P/1846772036.jpg', '\xc2\xa318.99', None, None, None, None), (297241, 'Junk Day', 'JNKDVMQXQJ2007', '2007-04-13', 23749, '172', 'tp', 'NOVEL', '1846772044', 'https://m.media-amazon.com/images/P/1846772044.jpg', '\xc2\xa39.99', None, None, None, None), (375256, 'John Carter of Mars, Volume 6', 'JHNCRTRFMB2007', '2007-04-13', 23749, '156', 'tp', 'COLLECTION', '9781846772146', 'https://m.media-amazon.com/images/I/51852nd3srL.jpg', '\xc2\xa38.99', 287758, None, None, None), (375257, 'John Carter of Mars, Volume 6', 'JHNCRTRFMC2007', '2007-04-13', 23749, '156', 'hc', 'COLLECTION', '9781846772139', 'https://m.media-amazon.com/images/I/51852nd3srL.jpg', '\xc2\xa317.99', 287759, None, None, None), (351425, 'Serpent of the Waves', 'SRPNTFTHWV2007', '2007-05-22', 23749, '328', 'tp', 'NOVEL', '9781846771866', 'https://m.media-amazon.com/images/I/51tEUDYjMYL.jpg', '\xc2\xa310.99', 259154, 592, None, None), (351426, 'Dragons of the North', 'DRGNSFTHNR2007', '2007-05-22', 23749, '304', 'tp', 'NOVEL', '9781846771842', 'https://m.media-amazon.com/images/I/51FkyiwbAOL.jpg', '\xc2\xa310.99', 259155, 592, None, None), (351427, 'Wolves of the Tiber', 'WLVSFTHTBR2007', '2007-05-22', 23749, '275', 'tp', 'NOVEL', '9781846771828', 'https://m.media-amazon.com/images/I/51v9pphqo5L.jpg', '\xc2\xa39.99', 259156, 592, None, None), (351428, 'City of Eagles', 'CTFGLSQWRZ2007', '2007-05-22', 23749, '200', 'tp', 'NOVEL', '9781846771880', 'https://m.media-amazon.com/images/I/51SRfmKJR2L.jpg', '\xc2\xa38.99', 259157, 592, None, None), (317345, "Garrett P. Serviss' Science Fiction", 'GRRTTPSRVS2007', '2007-10-00', 23749, '408', 'tp', 'COLLECTION', '9781846773235', None, '\xc2\xa312.99', None, None, None, None), (317346, "Garrett P. Serviss' Science Fiction", 'GRRTTPSRVB2007', '2007-10-00', 23749, '408', 'hc', 'COLLECTION', '9781846773242', 'https://data.fantlab.ru/images/editions/big/122351', '\xc2\xa320.99', None, 2513, None, None), (288589, 'Almuric', 'LMRCMKTFQP2007', '2007-12-00', 23749, '160', 'tp', 'NOVEL', '1846773695', 'http://www.isfdb.org/wiki/images/e/ed/LMRCMKTFQP2007.jpg', '\xc2\xa38.99', 170462, 2513, 'SF28', None), (288590, 'Almuric', 'LMRCVHTWHM2007', '2007-12-00', 23749, '158', 'hc', 'NOVEL', '1846773709', 'http://www.isfdb.org/wiki/images/e/ed/LMRCMKTFQP2007.jpg', '\xc2\xa316.99', 170463, 2513, 'SF28', None), (317347, 'Challenger & Company', 'CHLLNGRCMP2007', '2007-12-00', 23749, '492', 'tp', 'OMNIBUS', '9781846773716', None, '\xc2\xa313.99', None, 2513, 'SF29', None), (317348, 'Challenger & Company', 'CHLLNGRCMB2007', '2007-12-00', 23749, '492', 'hc', 'OMNIBUS', '9781846773723', None, '\xc2\xa321.99', None, 2513, 'SF29', 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 = (375247, 'John Carter of Mars Volume 3', 'JHNCRTRFMR2007', '2007-01-22', 23749, '348', 'hc', 'OMNIBUS', '9781846771583', 'https://m.media-amazon.com/images/I/51Kxd9xmdqL.jpg', '\xc2\xa320.99', 287747, None, None, None), pub_authors = {288589: [(822, 'Robert E. Howard', 'Howard')], 288590: [(822, 'Robert E. Howard', 'Howard')], 297240: [(2082, 'Arthur Sellings', 'Sellings')], 297241: [(2082, 'Arthur Sellings', 'Sellings')], 317345: [(1134, 'Garrett P. Serviss', 'Serviss')], 317346: [(1134, 'Garrett P. Serviss', 'Serviss')], 317347: [(1131, 'Arthur Conan Doyle', 'Doyle')], 317348: [(1131, 'Arthur Conan Doyle', 'Doyle')], 351425: [(2118, 'Talbot Mundy', 'Mundy')], 351426: [(2118, 'Talbot Mundy', 'Mundy')], ...}, pub_publishers = {23749: 'Leonaur Ltd'}, pub_series = {592: 'Adventure & Historical Series', 2513: 'Leonaur Classic Science Fiction 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=(375247, 'John Carter of Mars Volume 3', 'JHNCRTRFMR2007', '2007-01-22', 23749, '348', 'hc', 'OMNIBUS', '9781846771583', 'https://m.media-amazon.com/images/I/51Kxd9xmdqL.jpg', '\xc2\xa320.99', 287747, None, None, None), pub_authors={288589: [(822, 'Robert E. Howard', 'Howard')], 288590: [(822, 'Robert E. Howard', 'Howard')], 297240: [(2082, 'Arthur Sellings', 'Sellings')], 297241: [(2082, 'Arthur Sellings', 'Sellings')], 317345: [(1134, 'Garrett P. Serviss', 'Serviss')], 317346: [(1134, 'Garrett P. Serviss', 'Serviss')], 317347: [(1131, 'Arthur Conan Doyle', 'Doyle')], 317348: [(1131, 'Arthur Conan Doyle', 'Doyle')], 351425: [(2118, 'Talbot Mundy', 'Mundy')], 351426: [(2118, 'Talbot Mundy', 'Mundy')], ...}, pub_publishers={23749: 'Leonaur Ltd'}, pub_series={592: 'Adventure & Historical Series', 2513: 'Leonaur Classic Science Fiction 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 = (375247, 'John Carter of Mars Volume 3', 'JHNCRTRFMR2007', '2007-01-22', 23749, '348', 'hc', 'OMNIBUS', '9781846771583', 'https://m.media-amazon.com/images/I/51Kxd9xmdqL.jpg', '\xc2\xa320.99', 287747, 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=375247, displayed_value='John Carter of Mars Volume 3', 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 = 375247 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=375247) |
| 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=375247' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=375247') |
| 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=375247' |
| /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=375247') |
| 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=375247' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''