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 23:47:30 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 = [(929734, 'Blut und Spiele', 'BLTNDSPLCK2023', '2023-01-05', 34608, None, 'ebook', 'NOVEL', '9783845354958', 'https://isfdb.org/wiki/images/9/9d/BLTNDSPLCK2023.jpg', '\xe2\x82\xac3.49', 1082832, 6479, '295', None), (931570, 'Facetten der Revolution', 'FCTTNDRRVL2023', '2023-01-19', 34608, None, 'ebook', 'NOVEL', '9783845354965', 'https://isfdb.org/wiki/images/e/e2/FCTTNDRRVL2023.jpg', '\xe2\x82\xac3.49', 1086583, 6479, '296', None), (933782, 'Die Stunde des Protektors', 'DSTNDDSPRT2023', '2023-02-02', 34608, None, 'ebook', 'NOVEL', '9783845354972', 'https://isfdb.org/wiki/images/e/e3/DSTNDDSPRT2023.jpg', '\xe2\x82\xac3.49', 1090170, 6479, '297', None), (935846, 'Die Totenuhr', 'DTTNHRHTMJ2023', '2023-02-16', 34608, None, 'ebook', 'NOVEL', '9783845354989', 'https://isfdb.org/wiki/images/6/66/DTTNHRHTMJ2023.jpg', '\xe2\x82\xac3.49', 1093063, 6479, '298', None), (938486, 'Planet ohne Zeit', 'PLNTHNZTFZ2023', '2023-03-02', 34608, None, 'ebook', 'NOVEL', '9783845354996', 'https://isfdb.org/wiki/images/3/3c/PLNTHNZTFZ2023.jpg', '\xe2\x82\xac3.49', 1096301, 6479, '299', None), (938818, 'DORIFER', 'DRFRTTLDHV2023', '2023-03-02', 34608, None, 'ebook', 'NOVEL', '9783845351247', 'https://isfdb.org/wiki/images/a/a3/DRFRTTLDHV2023.jpg', '\xe2\x82\xac9.99', 1096722, 1833, '161', None), (938820, 'DORIFER', 'DRFRSPNWPV2023', '2023-03-04', 34608, '400', 'hc', 'NOVEL', '9783955480400', 'https://isfdb.org/wiki/images/a/a3/DRFRTTLDHV2023.jpg', '\xe2\x82\xac21.50', 1096731, 1833, '161', None), (941526, 'Sektor Morgenrot', 'SKTRMRGNRT2023', '2023-03-16', 34608, None, 'ebook', 'NOVEL', '9783845355009', 'https://isfdb.org/wiki/images/4/4d/SKTRMRGNRT2023.jpg', '\xe2\x82\xac3.49', 1100215, 6479, '300', None), (944689, 'Welt der Cenoten', 'WLTDRCNTNT2023', '2023-03-30', 34608, None, 'ebook', 'NOVEL', '9783845355016', 'https://isfdb.org/wiki/images/6/66/WLTDRCNTNT2023.jpg', '\xe2\x82\xac3.49', 1104015, 6479, '301', None), (946715, 'Labyrinth des Wassers', 'LBRNTHDSWS2023', '2023-04-13', 34608, None, 'ebook', 'NOVEL', '9783845355023', 'https://isfdb.org/wiki/images/b/be/LBRNTHDSWS2023.jpg', '\xe2\x82\xac3.49', 1106449, 6479, '302', None), (949048, 'Zeit und Zorn', 'ZTNDZRNGBS2023', '2023-04-27', 34608, None, 'ebook', 'NOVEL', '9783845355030', 'https://isfdb.org/wiki/images/f/f3/ZTNDZRNGBS2023.jpg', '\xe2\x82\xac3.49', 1109702, 6479, '303', None), (952014, 'Der Tod eines Kriegers', 'DRTDNSKRGR2023', '2023-05-02', 34608, None, 'ebook', 'NOVEL', '9783845351254', 'https://isfdb.org/wiki/images/2/25/DRTDNSKRGR2023.jpg', '\xe2\x82\xac9.99', 1113664, 1833, '162', None), (952017, 'Der Tod eines Kriegers', 'DRTDNSKRGB2023', '2023-05-06', 34608, '400', 'hc', 'NOVEL', '9783955480417', 'https://isfdb.org/wiki/images/2/25/DRTDNSKRGR2023.jpg', '\xe2\x82\xac21.50', 1113669, 1833, '162', None), (955604, 'Amtraniks Zorn', 'MTRNKSZRNL2023', '2023-05-11', 34608, None, 'ebook', 'NOVEL', '9783845355047', 'https://isfdb.org/wiki/images/8/82/MTRNKSZRNL2023.jpg', '\xe2\x82\xac3.49', 1117971, 6479, '304', None), (955605, 'Die Wasserwelt', 'DWSSRWLTQH2023', '2023-05-25', 34608, None, 'ebook', 'NOVEL', '9783845355054', 'https://isfdb.org/wiki/images/f/f1/DWSSRWLTQH2023.jpg', '\xe2\x82\xac3.49', 1117972, 6479, '305', None), (955607, 'Facetten der Gewalt', 'FCTTNDRGWL2023', '2023-06-08', 34608, None, 'ebook', 'NOVEL', '9783845355061', 'https://isfdb.org/wiki/images/e/e8/FCTTNDRGWL2023.jpg', '\xe2\x82\xac3.49', 1117974, 6479, '306', None), (960379, 'Tanz der Magnetare', 'TNZDRMGNTR2023', '2023-06-22', 34608, None, 'ebook', 'NOVEL', '9783845355078', 'https://isfdb.org/wiki/images/f/f2/TNZDRMGNTR2023.jpg', '\xe2\x82\xac3.49', 1123921, 6479, '307', None), (960384, 'Gegen den Wall', 'GGNDNWLLNC2023', '2023-07-06', 34608, None, 'ebook', 'NOVEL', '9783845355085', 'https://isfdb.org/wiki/images/3/37/GGNDNWLLNC2023.jpg', '\xe2\x82\xac3.49', 1123926, 6479, '308', ''), (961728, 'Hundert Millionen Jahre', 'HNDRTMLLNN2023', '2023-07-20', 34608, None, 'ebook', 'NOVEL', '9783845355092', 'https://isfdb.org/wiki/images/2/2e/HNDRTMLLNN2023.jpg', '\xe2\x82\xac3.49', 1125802, 6479, '309', None), (966458, 'Welt ohne Liebe', 'WLTHNLBNHK2023', '2023-08-03', 34608, None, 'ebook', 'NOVEL', '9783845355108', 'https://isfdb.org/wiki/images/c/c4/WLTHNLBNHK2023.jpg', '\xe2\x82\xac3.49', 1131700, 6479, '310', None), ...] |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(929734, 'Blut und Spiele', 'BLTNDSPLCK2023', '2023-01-05', 34608, None, 'ebook', 'NOVEL', '9783845354958', 'https://isfdb.org/wiki/images/9/9d/BLTNDSPLCK2023.jpg', '\xe2\x82\xac3.49', 1082832, 6479, '295', None), (931570, 'Facetten der Revolution', 'FCTTNDRRVL2023', '2023-01-19', 34608, None, 'ebook', 'NOVEL', '9783845354965', 'https://isfdb.org/wiki/images/e/e2/FCTTNDRRVL2023.jpg', '\xe2\x82\xac3.49', 1086583, 6479, '296', None), (933782, 'Die Stunde des Protektors', 'DSTNDDSPRT2023', '2023-02-02', 34608, None, 'ebook', 'NOVEL', '9783845354972', 'https://isfdb.org/wiki/images/e/e3/DSTNDDSPRT2023.jpg', '\xe2\x82\xac3.49', 1090170, 6479, '297', None), (935846, 'Die Totenuhr', 'DTTNHRHTMJ2023', '2023-02-16', 34608, None, 'ebook', 'NOVEL', '9783845354989', 'https://isfdb.org/wiki/images/6/66/DTTNHRHTMJ2023.jpg', '\xe2\x82\xac3.49', 1093063, 6479, '298', None), (938486, 'Planet ohne Zeit', 'PLNTHNZTFZ2023', '2023-03-02', 34608, None, 'ebook', 'NOVEL', '9783845354996', 'https://isfdb.org/wiki/images/3/3c/PLNTHNZTFZ2023.jpg', '\xe2\x82\xac3.49', 1096301, 6479, '299', None), (938818, 'DORIFER', 'DRFRTTLDHV2023', '2023-03-02', 34608, None, 'ebook', 'NOVEL', '9783845351247', 'https://isfdb.org/wiki/images/a/a3/DRFRTTLDHV2023.jpg', '\xe2\x82\xac9.99', 1096722, 1833, '161', None), (938820, 'DORIFER', 'DRFRSPNWPV2023', '2023-03-04', 34608, '400', 'hc', 'NOVEL', '9783955480400', 'https://isfdb.org/wiki/images/a/a3/DRFRTTLDHV2023.jpg', '\xe2\x82\xac21.50', 1096731, 1833, '161', None), (941526, 'Sektor Morgenrot', 'SKTRMRGNRT2023', '2023-03-16', 34608, None, 'ebook', 'NOVEL', '9783845355009', 'https://isfdb.org/wiki/images/4/4d/SKTRMRGNRT2023.jpg', '\xe2\x82\xac3.49', 1100215, 6479, '300', None), (944689, 'Welt der Cenoten', 'WLTDRCNTNT2023', '2023-03-30', 34608, None, 'ebook', 'NOVEL', '9783845355016', 'https://isfdb.org/wiki/images/6/66/WLTDRCNTNT2023.jpg', '\xe2\x82\xac3.49', 1104015, 6479, '301', None), (946715, 'Labyrinth des Wassers', 'LBRNTHDSWS2023', '2023-04-13', 34608, None, 'ebook', 'NOVEL', '9783845355023', 'https://isfdb.org/wiki/images/b/be/LBRNTHDSWS2023.jpg', '\xe2\x82\xac3.49', 1106449, 6479, '302', None), (949048, 'Zeit und Zorn', 'ZTNDZRNGBS2023', '2023-04-27', 34608, None, 'ebook', 'NOVEL', '9783845355030', 'https://isfdb.org/wiki/images/f/f3/ZTNDZRNGBS2023.jpg', '\xe2\x82\xac3.49', 1109702, 6479, '303', None), (952014, 'Der Tod eines Kriegers', 'DRTDNSKRGR2023', '2023-05-02', 34608, None, 'ebook', 'NOVEL', '9783845351254', 'https://isfdb.org/wiki/images/2/25/DRTDNSKRGR2023.jpg', '\xe2\x82\xac9.99', 1113664, 1833, '162', None), (952017, 'Der Tod eines Kriegers', 'DRTDNSKRGB2023', '2023-05-06', 34608, '400', 'hc', 'NOVEL', '9783955480417', 'https://isfdb.org/wiki/images/2/25/DRTDNSKRGR2023.jpg', '\xe2\x82\xac21.50', 1113669, 1833, '162', None), (955604, 'Amtraniks Zorn', 'MTRNKSZRNL2023', '2023-05-11', 34608, None, 'ebook', 'NOVEL', '9783845355047', 'https://isfdb.org/wiki/images/8/82/MTRNKSZRNL2023.jpg', '\xe2\x82\xac3.49', 1117971, 6479, '304', None), (955605, 'Die Wasserwelt', 'DWSSRWLTQH2023', '2023-05-25', 34608, None, 'ebook', 'NOVEL', '9783845355054', 'https://isfdb.org/wiki/images/f/f1/DWSSRWLTQH2023.jpg', '\xe2\x82\xac3.49', 1117972, 6479, '305', None), (955607, 'Facetten der Gewalt', 'FCTTNDRGWL2023', '2023-06-08', 34608, None, 'ebook', 'NOVEL', '9783845355061', 'https://isfdb.org/wiki/images/e/e8/FCTTNDRGWL2023.jpg', '\xe2\x82\xac3.49', 1117974, 6479, '306', None), (960379, 'Tanz der Magnetare', 'TNZDRMGNTR2023', '2023-06-22', 34608, None, 'ebook', 'NOVEL', '9783845355078', 'https://isfdb.org/wiki/images/f/f2/TNZDRMGNTR2023.jpg', '\xe2\x82\xac3.49', 1123921, 6479, '307', None), (960384, 'Gegen den Wall', 'GGNDNWLLNC2023', '2023-07-06', 34608, None, 'ebook', 'NOVEL', '9783845355085', 'https://isfdb.org/wiki/images/3/37/GGNDNWLLNC2023.jpg', '\xe2\x82\xac3.49', 1123926, 6479, '308', ''), (961728, 'Hundert Millionen Jahre', 'HNDRTMLLNN2023', '2023-07-20', 34608, None, 'ebook', 'NOVEL', '9783845355092', 'https://isfdb.org/wiki/images/2/2e/HNDRTMLLNN2023.jpg', '\xe2\x82\xac3.49', 1125802, 6479, '309', None), (966458, 'Welt ohne Liebe', 'WLTHNLBNHK2023', '2023-08-03', 34608, None, 'ebook', 'NOVEL', '9783845355108', 'https://isfdb.org/wiki/images/c/c4/WLTHNLBNHK2023.jpg', '\xe2\x82\xac3.49', 1131700, 6479, '310', 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 = (929734, 'Blut und Spiele', 'BLTNDSPLCK2023', '2023-01-05', 34608, None, 'ebook', 'NOVEL', '9783845354958', 'https://isfdb.org/wiki/images/9/9d/BLTNDSPLCK2023.jpg', '\xe2\x82\xac3.49', 1082832, 6479, '295', None), pub_authors = {929734: [(297612, 'Marlene von Hagen', 'Hagen')], 931570: [(151214, 'Roman Schleifer', 'Schleifer')], 933782: [(293808, 'Lucy Guth', 'Guth')], 935846: [(200370, 'Rainer Schorm', 'Schorm')], 938486: [(163790, 'R\xc3\xbcdiger Sch\xc3\xa4fer', 'Schaefer')], 938818: [(20754, 'uncredited', 'uncredited')], 938820: [(20754, 'uncredited', 'uncredited')], 941526: [(163790, 'R\xc3\xbcdiger Sch\xc3\xa4fer', 'Schaefer'), (200370, 'Rainer Schorm', 'Schorm')], 944689: [(293808, 'Lucy Guth', 'Guth')], 946715: [(235568, 'Ruben Wickenh\xc3\xa4user', 'Wickenhaeuser')], ...}, pub_publishers = {34608: 'Pabel-Moewig'}, pub_series = {1833: 'Perry Rhodan', 6479: 'Perry Rhodan NEO'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
/home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(929734, 'Blut und Spiele', 'BLTNDSPLCK2023', '2023-01-05', 34608, None, 'ebook', 'NOVEL', '9783845354958', 'https://isfdb.org/wiki/images/9/9d/BLTNDSPLCK2023.jpg', '\xe2\x82\xac3.49', 1082832, 6479, '295', None), pub_authors={929734: [(297612, 'Marlene von Hagen', 'Hagen')], 931570: [(151214, 'Roman Schleifer', 'Schleifer')], 933782: [(293808, 'Lucy Guth', 'Guth')], 935846: [(200370, 'Rainer Schorm', 'Schorm')], 938486: [(163790, 'R\xc3\xbcdiger Sch\xc3\xa4fer', 'Schaefer')], 938818: [(20754, 'uncredited', 'uncredited')], 938820: [(20754, 'uncredited', 'uncredited')], 941526: [(163790, 'R\xc3\xbcdiger Sch\xc3\xa4fer', 'Schaefer'), (200370, 'Rainer Schorm', 'Schorm')], 944689: [(293808, 'Lucy Guth', 'Guth')], 946715: [(235568, 'Ruben Wickenh\xc3\xa4user', 'Wickenhaeuser')], ...}, pub_publishers={34608: 'Pabel-Moewig'}, pub_series={1833: 'Perry Rhodan', 6479: 'Perry Rhodan NEO'}, 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 = (929734, 'Blut und Spiele', 'BLTNDSPLCK2023', '2023-01-05', 34608, None, 'ebook', 'NOVEL', '9783845354958', 'https://isfdb.org/wiki/images/9/9d/BLTNDSPLCK2023.jpg', '\xe2\x82\xac3.49', 1082832, 6479, '295', 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=929734, displayed_value='Blut und Spiele', 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 = 929734 |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=929734) |
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=929734' |
/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=929734') |
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=929734' |
/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=929734') |
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=929734' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''