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 Tue Apr 30 05:03:22 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 = [(755645, '\xd0\x93\xd0\xbe\xd1\x80\xd0\xbe\xd0\xb4 \xd0\xbb\xd0\xb5\xd1\x81\xd1\x82\xd0\xbd\xd0\xb8\xd1\x86', 'QGHLXBDFQG2017', '2017-00-00', 6715, '560', 'hc', 'NOVEL', '9785170892723', 'https://data.fantlab.ru/images/editions/orig/185558', None, 846798, 8908, None, None), (863834, '\xd0\x9a\xd0\xbb\xd0\xb0\xd0\xbd \xd1\x83 \xd0\xbf\xd1\x80\xd0\xbe\xd0\xbf\xd0\xb0\xd1\x81\xd1\x82\xd0\xb8', 'SPCNXKXKGK2017', '2017-02-00', 6715, '320', 'hc', 'NOVEL', '9785171023201', 'https://data.fantlab.ru/images/editions/orig/190280', None, 987376, 10106, '3', None), (738152, '\xd0\xa7\xd0\xb5\xd0\xbb\xd0\xbe\xd0\xb2\xd0\xb5\xd0\xba \xd0\xb1\xd0\xb5\xd0\xb7 \xd1\x81\xd1\x82\xd1\x80\xd0\xb0\xd1\x85\xd0\xb0', 'WNRHMRRPVG2017', '2017-05-05', 6715, '320', 'hc', 'NOVEL', '9785170997435', 'http://www.isfdb.org/wiki/images/6/64/CHLVKBZSTRKH2017.jpg', 'RUB 321', 821893, 8497, None, None), (735414, '\xd0\x92\xd0\xb5\xd1\x87\xd0\xbd\xd0\xb0\xd1\x8f \xd1\x8e\xd0\xbd\xd0\xbe\xd1\x81\xd1\x82\xd1\x8c', 'MPMJFLPCXJ2017', '2017-06-01', 6715, '352', 'hc', 'NOVEL', '9785170997503', 'http://www.isfdb.org/wiki/images/8/82/VCHNNST2017.jpg', None, 817777, 8497, None, None), (897283, '\xd0\x9f\xd0\xbb\xd0\xb0\xd0\xbd\xd0\xb5\xd1\x82\xd0\xb0 \xd0\xbe\xd0\xb1\xd0\xb5\xd0\xb7\xd1\x8c\xd1\x8f\xd0\xbd: \xd0\x92\xd0\xbe\xd0\xb9\xd0\xbd\xd0\xb0', 'SJZWBWXKPK2017', '2017-07-03', 6715, '320', 'hc', 'NOVEL', '9785171044091', 'https://fantlab.ru/images/editions/big/200388?r=1542888960', None, 1033149, None, None, None), (896677, '\xd0\xa1\xd0\xbc\xd0\xb5\xd1\x80\xd1\x82\xd0\xbd\xd1\x8b\xd0\xb9 \xd0\xbf\xd1\x80\xd0\xb8\xd0\xb3\xd0\xbe\xd0\xb2\xd0\xbe\xd1\x80', 'GSTLHHFZWM2017', '2017-09-08', 6715, '352', 'hc', 'NOVEL', '9785170997473', 'https://data.fantlab.ru/images/editions/big/205537?r=1506042057', None, 1032219, 8497, None, None), (847981, '\xd0\x9a\xd1\x80\xd0\xb0\xd1\x81\xd0\xbd\xd0\xb0\xd1\x8f \xd0\xbc\xd0\xb5\xd1\x82\xd0\xba\xd0\xb0', 'QDSQWJKFSK2017', '2017-10-00', 6715, '384', 'hc', 'NOVEL', '9785171035822', 'https://data.fantlab.ru/images/editions/big/210697?r=1528299155', None, 965080, 8497, None, None), (902456, '\xd0\x9c\xd0\xb8\xd1\x81\xd1\x82\xd0\xb5\xd1\x80 \xd0\x9c\xd0\xb5\xd1\x80\xd1\x81\xd0\xb5\xd0\xb4\xd0\xb5\xd1\x81', 'JMLJFDMZNN2017', '2017-10-00', 6715, '480', 'hc', 'NOVEL', '9785171056445', 'http://www.isfdb.org/wiki/images/0/06/JMLJFDMZNN2017.jpg', None, 1040462, None, None, None), (773607, '\xd0\x91\xd0\xb8\xd0\xb1\xd0\xbb\xd0\xb8\xd0\xbe\xd1\x82\xd0\xb5\xd0\xba\xd0\xb0 \xd0\xbd\xd0\xb0 \xd0\x9e\xd0\xb1\xd1\x83\xd0\xb3\xd0\xbb\xd0\xb5\xd0\xbd\xd0\xbd\xd0\xbe\xd0\xb9 \xd0\xb3\xd0\xbe\xd1\x80\xd0\xb5', 'PVPQPKCFFN2017', '2017-11-15', 6715, '510', 'hc', 'NOVEL', '9785170909599', 'https://data.fantlab.ru/images/editions/orig/207291', None, 872643, 9167, None, None), (745145, '\xd0\x94\xd1\x80\xd0\xb0\xd0\xba\xd0\xbe\xd0\xbd\xd0\xb8\xd0\xb9 \xd0\xbb\xd1\x83\xd0\xb3', 'NSDKKLHQNF2017', '2017-11-20', 6715, '384', 'hc', 'NOVEL', '9785171007805', 'https://data.fantlab.ru/images/editions/orig/203099', None, 832176, 8756, '1', None)] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(755645, '\xd0\x93\xd0\xbe\xd1\x80\xd0\xbe\xd0\xb4 \xd0\xbb\xd0\xb5\xd1\x81\xd1\x82\xd0\xbd\xd0\xb8\xd1\x86', 'QGHLXBDFQG2017', '2017-00-00', 6715, '560', 'hc', 'NOVEL', '9785170892723', 'https://data.fantlab.ru/images/editions/orig/185558', None, 846798, 8908, None, None), (863834, '\xd0\x9a\xd0\xbb\xd0\xb0\xd0\xbd \xd1\x83 \xd0\xbf\xd1\x80\xd0\xbe\xd0\xbf\xd0\xb0\xd1\x81\xd1\x82\xd0\xb8', 'SPCNXKXKGK2017', '2017-02-00', 6715, '320', 'hc', 'NOVEL', '9785171023201', 'https://data.fantlab.ru/images/editions/orig/190280', None, 987376, 10106, '3', None), (738152, '\xd0\xa7\xd0\xb5\xd0\xbb\xd0\xbe\xd0\xb2\xd0\xb5\xd0\xba \xd0\xb1\xd0\xb5\xd0\xb7 \xd1\x81\xd1\x82\xd1\x80\xd0\xb0\xd1\x85\xd0\xb0', 'WNRHMRRPVG2017', '2017-05-05', 6715, '320', 'hc', 'NOVEL', '9785170997435', 'http://www.isfdb.org/wiki/images/6/64/CHLVKBZSTRKH2017.jpg', 'RUB 321', 821893, 8497, None, None), (735414, '\xd0\x92\xd0\xb5\xd1\x87\xd0\xbd\xd0\xb0\xd1\x8f \xd1\x8e\xd0\xbd\xd0\xbe\xd1\x81\xd1\x82\xd1\x8c', 'MPMJFLPCXJ2017', '2017-06-01', 6715, '352', 'hc', 'NOVEL', '9785170997503', 'http://www.isfdb.org/wiki/images/8/82/VCHNNST2017.jpg', None, 817777, 8497, None, None), (897283, '\xd0\x9f\xd0\xbb\xd0\xb0\xd0\xbd\xd0\xb5\xd1\x82\xd0\xb0 \xd0\xbe\xd0\xb1\xd0\xb5\xd0\xb7\xd1\x8c\xd1\x8f\xd0\xbd: \xd0\x92\xd0\xbe\xd0\xb9\xd0\xbd\xd0\xb0', 'SJZWBWXKPK2017', '2017-07-03', 6715, '320', 'hc', 'NOVEL', '9785171044091', 'https://fantlab.ru/images/editions/big/200388?r=1542888960', None, 1033149, None, None, None), (896677, '\xd0\xa1\xd0\xbc\xd0\xb5\xd1\x80\xd1\x82\xd0\xbd\xd1\x8b\xd0\xb9 \xd0\xbf\xd1\x80\xd0\xb8\xd0\xb3\xd0\xbe\xd0\xb2\xd0\xbe\xd1\x80', 'GSTLHHFZWM2017', '2017-09-08', 6715, '352', 'hc', 'NOVEL', '9785170997473', 'https://data.fantlab.ru/images/editions/big/205537?r=1506042057', None, 1032219, 8497, None, None), (847981, '\xd0\x9a\xd1\x80\xd0\xb0\xd1\x81\xd0\xbd\xd0\xb0\xd1\x8f \xd0\xbc\xd0\xb5\xd1\x82\xd0\xba\xd0\xb0', 'QDSQWJKFSK2017', '2017-10-00', 6715, '384', 'hc', 'NOVEL', '9785171035822', 'https://data.fantlab.ru/images/editions/big/210697?r=1528299155', None, 965080, 8497, None, None), (902456, '\xd0\x9c\xd0\xb8\xd1\x81\xd1\x82\xd0\xb5\xd1\x80 \xd0\x9c\xd0\xb5\xd1\x80\xd1\x81\xd0\xb5\xd0\xb4\xd0\xb5\xd1\x81', 'JMLJFDMZNN2017', '2017-10-00', 6715, '480', 'hc', 'NOVEL', '9785171056445', 'http://www.isfdb.org/wiki/images/0/06/JMLJFDMZNN2017.jpg', None, 1040462, None, None, None), (773607, '\xd0\x91\xd0\xb8\xd0\xb1\xd0\xbb\xd0\xb8\xd0\xbe\xd1\x82\xd0\xb5\xd0\xba\xd0\xb0 \xd0\xbd\xd0\xb0 \xd0\x9e\xd0\xb1\xd1\x83\xd0\xb3\xd0\xbb\xd0\xb5\xd0\xbd\xd0\xbd\xd0\xbe\xd0\xb9 \xd0\xb3\xd0\xbe\xd1\x80\xd0\xb5', 'PVPQPKCFFN2017', '2017-11-15', 6715, '510', 'hc', 'NOVEL', '9785170909599', 'https://data.fantlab.ru/images/editions/orig/207291', None, 872643, 9167, None, None), (745145, '\xd0\x94\xd1\x80\xd0\xb0\xd0\xba\xd0\xbe\xd0\xbd\xd0\xb8\xd0\xb9 \xd0\xbb\xd1\x83\xd0\xb3', 'NSDKKLHQNF2017', '2017-11-20', 6715, '384', 'hc', 'NOVEL', '9785171007805', 'https://data.fantlab.ru/images/editions/orig/203099', None, 832176, 8756, '1', 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 = (755645, '\xd0\x93\xd0\xbe\xd1\x80\xd0\xbe\xd0\xb4 \xd0\xbb\xd0\xb5\xd1\x81\xd1\x82\xd0\xbd\xd0\xb8\xd1\x86', 'QGHLXBDFQG2017', '2017-00-00', 6715, '560', 'hc', 'NOVEL', '9785170892723', 'https://data.fantlab.ru/images/editions/orig/185558', None, 846798, 8908, None, None), pub_authors = {735414: [(299670, '\xd0\xa1\xd1\x82\xd0\xb5\xd1\x84\xd0\xb0\xd0\xbd \xd0\x9f\xd0\xb5\xd1\x82\xd1\x80\xd1\x83\xd1\x87\xd0\xbe', 'Petrucho')], 738152: [(300812, '\xd0\x9f\xd0\xbe\xd0\xbb \xd0\x9a\xd1\x80\xd0\xb8\xd0\xbb\xd0\xbb\xd0\xb8', 'Krilli')], 745145: [(303240, '\xd0\xa1\xd0\xba\xd0\xb0\xd1\x80\xd0\xbb\xd0\xb5\xd1\x82\xd1\x82 \xd0\xa2\xd0\xbe\xd0\xbc\xd0\xb0\xd1\x81', 'Tomas')], 755645: [(306242, '\xd0\xa0\xd0\xbe\xd0\xb1\xd0\xb5\xd1\x80\xd1\x82 \xd0\x94\xd0\xb6\xd0\xb5\xd0\xba\xd1\x81\xd0\xbe\xd0\xbd \xd0\x91\xd0\xb5\xd0\xbd\xd0\xbd\xd0\xb5\xd1\x82\xd1\x82', 'Bennett')], 773607: [(311794, '\xd0\xa1\xd0\xba\xd0\xbe\xd1\x82\xd1\x82 \xd0\xa5\xd0\xbe\xd0\xba\xd0\xb8\xd0\xbd\xd1\x81', 'Hokins')], 847981: [(328616, '\xd0\x9c\xd0\xb0\xd1\x80\xd0\xb3\xd0\xb0\xd1\x80\xd0\xb5\xd1\x82 \xd0\xa8\xd1\x82\xd0\xbe\xd0\xbb\xd1\x8c', 'Stoll')], 863834: [(334106, '\xd0\x9d\xd0\xb8\xd0\xba\xd0\xbe\xd0\xbb\xd0\xb0\xd0\xb9 \xd0\x9c\xd0\xb5\xd1\x82\xd0\xb5\xd0\xbb\xd1\x8c\xd1\x81\xd0\xba\xd0\xb8\xd0\xb9', "Metel'skiy")], 896677: [(298816, '\xd0\xa1\xd1\x82\xd1\x8e\xd0\xb0\xd1\x80\xd1\x82 \xd0\x9c\xd1\x83\xd1\x80', 'Mur')], 897283: [(345057, '\xd0\x93\xd1\x80\xd0\xb5\xd0\xb3 \xd0\x9a\xd0\xbe\xd0\xba\xd1\x81', 'Koks')], 902456: [(70, 'Stephen King', 'King')]}, pub_publishers = {6715: '\xd0\x90\xd0\xa1\xd0\xa2'}, pub_series = {8497: '\xd0\x92\xd1\x81\xd0\xb5\xd0\xbb\xd0\xb5\xd0\xbd\xd0\xbd\xd0\xb0\xd1\x8f MARVEL', 8756: '\xd0\x9c\xd0\xb8\xd1\x80\xd0\xbe\xd1\x82\xd1\x80\xd1\x8f\xd1\x81\xd0\xb5\xd0\xbd\xd0\xb8\xd0\xb5', 8908: '\xd0\x9c\xd0\xb0\xd1\x81\xd1\x82\xd0\xb5\xd1\x80\xd0\xb0 \xd1\x84\xd0\xb0\xd0\xbd\xd1\x82\xd0\xb0\xd0\xb7\xd0\xb8\xd0\xb8 (\xd0\x90\xd0\xa1\xd0\xa2)', 9167: 'Best Book Ever', 10106: '\xd0\x91\xd0\xbe\xd1\x8f\xd1\x80\xd1\x8a-\xd0\xb0\xd0\xbd\xd0\xb8\xd0\xbc\xd0\xb5'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(755645, '\xd0\x93\xd0\xbe\xd1\x80\xd0\xbe\xd0\xb4 \xd0\xbb\xd0\xb5\xd1\x81\xd1\x82\xd0\xbd\xd0\xb8\xd1\x86', 'QGHLXBDFQG2017', '2017-00-00', 6715, '560', 'hc', 'NOVEL', '9785170892723', 'https://data.fantlab.ru/images/editions/orig/185558', None, 846798, 8908, None, None), pub_authors={735414: [(299670, '\xd0\xa1\xd1\x82\xd0\xb5\xd1\x84\xd0\xb0\xd0\xbd \xd0\x9f\xd0\xb5\xd1\x82\xd1\x80\xd1\x83\xd1\x87\xd0\xbe', 'Petrucho')], 738152: [(300812, '\xd0\x9f\xd0\xbe\xd0\xbb \xd0\x9a\xd1\x80\xd0\xb8\xd0\xbb\xd0\xbb\xd0\xb8', 'Krilli')], 745145: [(303240, '\xd0\xa1\xd0\xba\xd0\xb0\xd1\x80\xd0\xbb\xd0\xb5\xd1\x82\xd1\x82 \xd0\xa2\xd0\xbe\xd0\xbc\xd0\xb0\xd1\x81', 'Tomas')], 755645: [(306242, '\xd0\xa0\xd0\xbe\xd0\xb1\xd0\xb5\xd1\x80\xd1\x82 \xd0\x94\xd0\xb6\xd0\xb5\xd0\xba\xd1\x81\xd0\xbe\xd0\xbd \xd0\x91\xd0\xb5\xd0\xbd\xd0\xbd\xd0\xb5\xd1\x82\xd1\x82', 'Bennett')], 773607: [(311794, '\xd0\xa1\xd0\xba\xd0\xbe\xd1\x82\xd1\x82 \xd0\xa5\xd0\xbe\xd0\xba\xd0\xb8\xd0\xbd\xd1\x81', 'Hokins')], 847981: [(328616, '\xd0\x9c\xd0\xb0\xd1\x80\xd0\xb3\xd0\xb0\xd1\x80\xd0\xb5\xd1\x82 \xd0\xa8\xd1\x82\xd0\xbe\xd0\xbb\xd1\x8c', 'Stoll')], 863834: [(334106, '\xd0\x9d\xd0\xb8\xd0\xba\xd0\xbe\xd0\xbb\xd0\xb0\xd0\xb9 \xd0\x9c\xd0\xb5\xd1\x82\xd0\xb5\xd0\xbb\xd1\x8c\xd1\x81\xd0\xba\xd0\xb8\xd0\xb9', "Metel'skiy")], 896677: [(298816, '\xd0\xa1\xd1\x82\xd1\x8e\xd0\xb0\xd1\x80\xd1\x82 \xd0\x9c\xd1\x83\xd1\x80', 'Mur')], 897283: [(345057, '\xd0\x93\xd1\x80\xd0\xb5\xd0\xb3 \xd0\x9a\xd0\xbe\xd0\xba\xd1\x81', 'Koks')], 902456: [(70, 'Stephen King', 'King')]}, pub_publishers={6715: '\xd0\x90\xd0\xa1\xd0\xa2'}, pub_series={8497: '\xd0\x92\xd1\x81\xd0\xb5\xd0\xbb\xd0\xb5\xd0\xbd\xd0\xbd\xd0\xb0\xd1\x8f MARVEL', 8756: '\xd0\x9c\xd0\xb8\xd1\x80\xd0\xbe\xd1\x82\xd1\x80\xd1\x8f\xd1\x81\xd0\xb5\xd0\xbd\xd0\xb8\xd0\xb5', 8908: '\xd0\x9c\xd0\xb0\xd1\x81\xd1\x82\xd0\xb5\xd1\x80\xd0\xb0 \xd1\x84\xd0\xb0\xd0\xbd\xd1\x82\xd0\xb0\xd0\xb7\xd0\xb8\xd0\xb8 (\xd0\x90\xd0\xa1\xd0\xa2)', 9167: 'Best Book Ever', 10106: '\xd0\x91\xd0\xbe\xd1\x8f\xd1\x80\xd1\x8a-\xd0\xb0\xd0\xbd\xd0\xb8\xd0\xbc\xd0\xb5'}, 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 = (755645, '\xd0\x93\xd0\xbe\xd1\x80\xd0\xbe\xd0\xb4 \xd0\xbb\xd0\xb5\xd1\x81\xd1\x82\xd0\xbd\xd0\xb8\xd1\x86', 'QGHLXBDFQG2017', '2017-00-00', 6715, '560', 'hc', 'NOVEL', '9785170892723', 'https://data.fantlab.ru/images/editions/orig/185558', None, 846798, 8908, 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=755645, displayed_value='\xd0\x93\xd0\xbe\xd1\x80\xd0\xbe\xd0\xb4 \xd0\xbb\xd0\xb5\xd1\x81\xd1\x82\xd0\xbd\xd0\xb8\xd1\x86', 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 = 755645 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=755645) |
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=755645' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=755645') |
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=755645' |
/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=755645') |
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=755645' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''