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 17:01:57 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 = [(260479, 'Swimming Without a Net', 'SWMMNGWTHT2008', '2008-01-00', 523, '191', 'pb', 'NOVEL', '9780749938581', 'http://www.isfdb.org/wiki/images/9/9f/SWMMNGWTHT2008.jpg', '\xc2\xa36.99', 132963, None, None, None), (313685, 'Sizzle and Burn', 'SZZLNDBRNL2008', '2008-01-00', 523, '359', 'tp', 'NOVEL', '9780749938574', 'https://m.media-amazon.com/images/I/41imLGrxSLL.jpg', '\xc2\xa312.99', 208675, None, None, None), (313691, 'White Lies', 'WHTLSXCSDB2008', '2008-01-00', 523, '371', 'pb', 'NOVEL', '9780749938451', 'https://m.media-amazon.com/images/I/41X6iDzE8WL.jpg', '\xc2\xa36.99', 208681, None, None, None), (339856, 'The Devil Inside', 'THDVLNSDHL2008', '2008-01-00', 523, '325', 'pb', 'NOVEL', '9780749938871', 'http://www.isfdb.org/wiki/images/b/bc/THDVLNSDHL2008.jpg', '\xc2\xa36.99', 245066, None, None, None), (543784, 'Strangers in Death', 'STRNGRSNDK2008', '2008-01-24', 523, '368', 'hc', 'NOVEL', '9780749908560', 'https://m.media-amazon.com/images/I/51VqWp5P85L.jpg', '\xc2\xa319.99', 497855, None, None, None), (340314, "The Wise Woman's Tale", 'THWSWMNSTL2008', '2008-02-00', 523, '232', 'tp', 'NOVEL', '9780749938390', 'http://www.isfdb.org/wiki/images/0/0c/THWSWMNSTL2008.jpg', '\xc2\xa36.99', 245604, None, None, None), (390934, 'The Secrets of the Cave', 'THSCRTSFTH2008', '2008-02-07', 523, '320', 'tp', 'NOVEL', '9780749938796', 'https://m.media-amazon.com/images/I/416aGc8Y1JL.jpg', '\xc2\xa312.99', 305981, None, None, None), (543589, 'Dream Chaser', 'DRMCHSRSQF2008', '2008-02-07', 523, '368', 'pb', 'NOVEL', '9780749938888', 'https://m.media-amazon.com/images/I/4121KlmNeVL.jpg', '\xc2\xa37.99', 497650, None, None, None), (543590, 'Strangers in Death', 'STRNGRSNDJ2008', '2008-02-07', 523, '368', 'tp', 'NOVEL', '9780749938833', 'https://m.media-amazon.com/images/I/51DXTiaQ2qL.jpg', '\xc2\xa312.99', 497651, None, None, None), (348782, 'Shadow Game', 'SHDWGMBWZZ2008', '2008-03-00', 523, '323', 'pb', 'NOVEL', '9780749938772', 'http://www.isfdb.org/wiki/images/0/04/SHDWGMBWZZ2008.jpg', '\xc2\xa36.99', 255871, None, None, None), (348754, 'Mind Game', 'MNDGMFCHWD2008', '2008-03-00', 523, '358', 'pb', 'NOVEL', '9780749938789', 'http://www.isfdb.org/wiki/images/5/5d/MNDGMFCHWD2008.jpg', '\xc2\xa36.99', 255837, None, None, None), (348777, 'Predatory Game', 'PRDTRGMMBP2008', '2008-03-00', 523, '313', 'pb', 'NOVEL', '9780749939168', 'http://www.isfdb.org/wiki/images/4/43/PRDTRGMMBP2008.jpg', '\xc2\xa36.99', 255865, None, None, None), (300664, 'Creation in Death', 'CRTNNDTHRM2008', '2008-04-03', 523, '352', 'pb', 'NOVEL', '9780749938710', 'https://m.media-amazon.com/images/P/0749938714.jpg', None, None, None, None, None), (390926, 'Devil May Cry: The Dark-Hunter World: Book 12', 'DVLMCRTHDR2008', '2008-04-03', 523, '320', 'pb', 'NOVEL', '9780749938741', 'https://m.media-amazon.com/images/I/41%2BKDiPeoLL.jpg', '\xc2\xa37.99', 305973, None, None, None), (390931, 'Knight Of Darkness: The Lords of Avalon Series: Book 2', 'KNGHTFDRKN2008', '2008-04-03', 523, '320', 'pb', 'NOVEL', '9780749938734', 'https://m.media-amazon.com/images/I/41Sm85HP5RL.jpg', '\xc2\xa36.99', 305978, None, None, None), (390932, 'Sword of Darkness: The Lords of Avalon Series: Book 1', 'SWRDFDRKNS2008', '2008-04-03', 523, '320', 'pb', 'NOVEL', '9780749938727', 'https://m.media-amazon.com/images/I/41hPVW6y%2BUL.jpg', '\xc2\xa36.99', 305979, None, None, None), (352000, 'The Hollow (Sign of Seven Trilogy 2)', 'THHLLWSGNF2008', '2008-04-24', 523, '352', 'hc', 'NOVEL', '9780749908546', 'https://m.media-amazon.com/images/I/41W-BDJdTgL.jpg', '\xc2\xa319.99', 259854, None, None, None), (261860, "Derik's Bane", 'DRKSBNTFGF2008', '2008-04-25', 523, '208', 'pb', 'NOVEL', '9780749938826', 'https://m.media-amazon.com/images/I/51GAPa4ENML.jpg', '\xc2\xa36.99', 134489, None, None, None), (261859, 'Night Game', 'NGHTGMGHST2008', '2008-05-00', 523, 'ix+419', 'pb', 'NOVEL', '9780749938901', 'http://www.isfdb.org/wiki/images/8/8f/NGHTGMGHST2008.jpg', '\xc2\xa36.99', 134488, None, None, None), (261872, 'Conspiracy Game', 'CNSPRCGMGH2008', '2008-05-00', 523, '420', 'pb', 'NOVEL', '9780749938994', 'http://www.isfdb.org/wiki/images/0/00/CNSPRCGMGH2008.jpg', '\xc2\xa36.99', 134502, None, None, None), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(260479, 'Swimming Without a Net', 'SWMMNGWTHT2008', '2008-01-00', 523, '191', 'pb', 'NOVEL', '9780749938581', 'http://www.isfdb.org/wiki/images/9/9f/SWMMNGWTHT2008.jpg', '\xc2\xa36.99', 132963, None, None, None), (313685, 'Sizzle and Burn', 'SZZLNDBRNL2008', '2008-01-00', 523, '359', 'tp', 'NOVEL', '9780749938574', 'https://m.media-amazon.com/images/I/41imLGrxSLL.jpg', '\xc2\xa312.99', 208675, None, None, None), (313691, 'White Lies', 'WHTLSXCSDB2008', '2008-01-00', 523, '371', 'pb', 'NOVEL', '9780749938451', 'https://m.media-amazon.com/images/I/41X6iDzE8WL.jpg', '\xc2\xa36.99', 208681, None, None, None), (339856, 'The Devil Inside', 'THDVLNSDHL2008', '2008-01-00', 523, '325', 'pb', 'NOVEL', '9780749938871', 'http://www.isfdb.org/wiki/images/b/bc/THDVLNSDHL2008.jpg', '\xc2\xa36.99', 245066, None, None, None), (543784, 'Strangers in Death', 'STRNGRSNDK2008', '2008-01-24', 523, '368', 'hc', 'NOVEL', '9780749908560', 'https://m.media-amazon.com/images/I/51VqWp5P85L.jpg', '\xc2\xa319.99', 497855, None, None, None), (340314, "The Wise Woman's Tale", 'THWSWMNSTL2008', '2008-02-00', 523, '232', 'tp', 'NOVEL', '9780749938390', 'http://www.isfdb.org/wiki/images/0/0c/THWSWMNSTL2008.jpg', '\xc2\xa36.99', 245604, None, None, None), (390934, 'The Secrets of the Cave', 'THSCRTSFTH2008', '2008-02-07', 523, '320', 'tp', 'NOVEL', '9780749938796', 'https://m.media-amazon.com/images/I/416aGc8Y1JL.jpg', '\xc2\xa312.99', 305981, None, None, None), (543589, 'Dream Chaser', 'DRMCHSRSQF2008', '2008-02-07', 523, '368', 'pb', 'NOVEL', '9780749938888', 'https://m.media-amazon.com/images/I/4121KlmNeVL.jpg', '\xc2\xa37.99', 497650, None, None, None), (543590, 'Strangers in Death', 'STRNGRSNDJ2008', '2008-02-07', 523, '368', 'tp', 'NOVEL', '9780749938833', 'https://m.media-amazon.com/images/I/51DXTiaQ2qL.jpg', '\xc2\xa312.99', 497651, None, None, None), (348782, 'Shadow Game', 'SHDWGMBWZZ2008', '2008-03-00', 523, '323', 'pb', 'NOVEL', '9780749938772', 'http://www.isfdb.org/wiki/images/0/04/SHDWGMBWZZ2008.jpg', '\xc2\xa36.99', 255871, None, None, None), (348754, 'Mind Game', 'MNDGMFCHWD2008', '2008-03-00', 523, '358', 'pb', 'NOVEL', '9780749938789', 'http://www.isfdb.org/wiki/images/5/5d/MNDGMFCHWD2008.jpg', '\xc2\xa36.99', 255837, None, None, None), (348777, 'Predatory Game', 'PRDTRGMMBP2008', '2008-03-00', 523, '313', 'pb', 'NOVEL', '9780749939168', 'http://www.isfdb.org/wiki/images/4/43/PRDTRGMMBP2008.jpg', '\xc2\xa36.99', 255865, None, None, None), (300664, 'Creation in Death', 'CRTNNDTHRM2008', '2008-04-03', 523, '352', 'pb', 'NOVEL', '9780749938710', 'https://m.media-amazon.com/images/P/0749938714.jpg', None, None, None, None, None), (390926, 'Devil May Cry: The Dark-Hunter World: Book 12', 'DVLMCRTHDR2008', '2008-04-03', 523, '320', 'pb', 'NOVEL', '9780749938741', 'https://m.media-amazon.com/images/I/41%2BKDiPeoLL.jpg', '\xc2\xa37.99', 305973, None, None, None), (390931, 'Knight Of Darkness: The Lords of Avalon Series: Book 2', 'KNGHTFDRKN2008', '2008-04-03', 523, '320', 'pb', 'NOVEL', '9780749938734', 'https://m.media-amazon.com/images/I/41Sm85HP5RL.jpg', '\xc2\xa36.99', 305978, None, None, None), (390932, 'Sword of Darkness: The Lords of Avalon Series: Book 1', 'SWRDFDRKNS2008', '2008-04-03', 523, '320', 'pb', 'NOVEL', '9780749938727', 'https://m.media-amazon.com/images/I/41hPVW6y%2BUL.jpg', '\xc2\xa36.99', 305979, None, None, None), (352000, 'The Hollow (Sign of Seven Trilogy 2)', 'THHLLWSGNF2008', '2008-04-24', 523, '352', 'hc', 'NOVEL', '9780749908546', 'https://m.media-amazon.com/images/I/41W-BDJdTgL.jpg', '\xc2\xa319.99', 259854, None, None, None), (261860, "Derik's Bane", 'DRKSBNTFGF2008', '2008-04-25', 523, '208', 'pb', 'NOVEL', '9780749938826', 'https://m.media-amazon.com/images/I/51GAPa4ENML.jpg', '\xc2\xa36.99', 134489, None, None, None), (261859, 'Night Game', 'NGHTGMGHST2008', '2008-05-00', 523, 'ix+419', 'pb', 'NOVEL', '9780749938901', 'http://www.isfdb.org/wiki/images/8/8f/NGHTGMGHST2008.jpg', '\xc2\xa36.99', 134488, None, None, None), (261872, 'Conspiracy Game', 'CNSPRCGMGH2008', '2008-05-00', 523, '420', 'pb', 'NOVEL', '9780749938994', 'http://www.isfdb.org/wiki/images/0/00/CNSPRCGMGH2008.jpg', '\xc2\xa36.99', 134502, 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 = (260479, 'Swimming Without a Net', 'SWMMNGWTHT2008', '2008-01-00', 523, '191', 'pb', 'NOVEL', '9780749938581', 'http://www.isfdb.org/wiki/images/9/9f/SWMMNGWTHT2008.jpg', '\xc2\xa36.99', 132963, None, None, None), pub_authors = {260479: [(28441, 'MaryJanice Davidson', 'Davidson')], 261859: [(7241, 'Christine Feehan', 'Feehan')], 261860: [(28441, 'MaryJanice Davidson', 'Davidson')], 261872: [(7241, 'Christine Feehan', 'Feehan')], 261874: [(7241, 'Christine Feehan', 'Feehan')], 261895: [(35790, 'Keri Arthur', 'Arthur')], 290491: [(7241, 'Christine Feehan', 'Feehan')], 290502: [(7241, 'Christine Feehan', 'Feehan')], 300664: [(4853, 'Nora Roberts', 'Roberts')], 300665: [(4853, 'Nora Roberts', 'Roberts')], ...}, pub_publishers = {523: 'Piatkus'}, 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=(260479, 'Swimming Without a Net', 'SWMMNGWTHT2008', '2008-01-00', 523, '191', 'pb', 'NOVEL', '9780749938581', 'http://www.isfdb.org/wiki/images/9/9f/SWMMNGWTHT2008.jpg', '\xc2\xa36.99', 132963, None, None, None), pub_authors={260479: [(28441, 'MaryJanice Davidson', 'Davidson')], 261859: [(7241, 'Christine Feehan', 'Feehan')], 261860: [(28441, 'MaryJanice Davidson', 'Davidson')], 261872: [(7241, 'Christine Feehan', 'Feehan')], 261874: [(7241, 'Christine Feehan', 'Feehan')], 261895: [(35790, 'Keri Arthur', 'Arthur')], 290491: [(7241, 'Christine Feehan', 'Feehan')], 290502: [(7241, 'Christine Feehan', 'Feehan')], 300664: [(4853, 'Nora Roberts', 'Roberts')], 300665: [(4853, 'Nora Roberts', 'Roberts')], ...}, pub_publishers={523: 'Piatkus'}, 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 = (260479, 'Swimming Without a Net', 'SWMMNGWTHT2008', '2008-01-00', 523, '191', 'pb', 'NOVEL', '9780749938581', 'http://www.isfdb.org/wiki/images/9/9f/SWMMNGWTHT2008.jpg', '\xc2\xa36.99', 132963, 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=260479, displayed_value='Swimming Without a Net', 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 = 260479 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=260479) |
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=260479' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=260479') |
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=260479' |
/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=260479') |
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=260479' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''