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 07:12:40 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 = [(387969, 'Spiegels en Rook', 'SPGLSNRKFP1999', '1999-00-00', 37221, '317', 'tp', 'COLLECTION', '9024536790', 'http://www.isfdb.org/wiki/images/7/7a/SPGLSNRKFP1999.jpg', '\xc6\x9239.90', 302415, None, None, None), (507121, 'Het spel der tronen', 'HTSPLDRTRN1999', '1999-00-00', 37221, '767', 'tp', 'NOVEL', '9024533929', 'https://www.deboekenplank.nl/naslag/aut/m/img/martin_g_ijs_1_1997_1.jpg', None, 453988, None, None, None), (507699, 'De Grote Jacht', 'DGRTJCHTGB1999', '1999-00-00', 37221, '672', 'tp', 'NOVEL', '9024523478', 'https://www.deboekenplank.nl/naslag/aut/j/img/jordan_r_rad_2_1995.jpg', None, 454749, None, None, None), (507815, 'De Gevangene', 'DGVNGNVQKZ1999', '1999-00-00', 37221, '430', 'tp', 'NOVEL', '9024521912', 'https://www.deboekenplank.nl/naslag/aut/r/img/russell_md_gevangene_1999.jpg', None, 454899, None, None, None), (507834, 'Het Bevel van de Zwerver', 'HTBVLVNDZW1999', '1999-00-00', 37221, '416', 'tp', 'NOVEL', '9024535727', 'https://www.deboekenplank.nl/naslag/aut/w/img/weis_hickman_roosprofeet_1_2000_2.jpg', None, 454919, None, None, None), (508402, 'Hemelse Wiskunde', 'HMLSWSKNDX1999', '1999-00-00', 37221, '451', 'tp', 'NOVEL', '9024534119', 'https://www.deboekenplank.nl/naslag/aut/k/img/keyes_g_eeuwderwonderen_2_1999_1e.jpg', None, 455619, None, None, None), (508403, 'Het Wapen van Newton', 'HTWPNVNNWT1999', '1999-00-00', 37221, '448', 'tp', 'NOVEL', '9024521874', 'https://www.deboekenplank.nl/naslag/aut/k/img/keyes_g_eeuwderwonderen_1_1999_1e.jpg', None, 455620, None, None, None), (508412, 'De Strijd der Koningen', 'DSTRJDDRKN1999', '1999-00-00', 37221, '827', 'tp', 'NOVEL', '9024511372', 'https://www.deboekenplank.nl/naslag/aut/m/img/martin_g_ijs_2_1999_1.jpg', None, 455638, None, None, None), (508962, 'De Planeet Barrayar', 'DPLNTBRRRW1999', '1999-00-00', 37221, '335', 'tp', 'NOVEL', '9024535611', 'https://www.deboekenplank.nl/naslag/aut/b/img/bujold_l_mv_1_1999.jpg', None, 456259, None, None, None), (514379, 'Legenden', 'LGNDNCBRMG1999', '1999-00-00', 37221, '670', 'tp', 'ANTHOLOGY', '9024505828', 'https://www.deboekenplank.nl/naslag/aut/s/img/silverberg_r_legenden_1999_2.jpg', None, 462788, None, None, None), (515035, 'Sperenwoud', 'SPRNWDRDRS1999', '1999-00-00', 37221, '382', 'tp', 'NOVEL', '9024527309', 'https://www.deboekenplank.nl/naslag/aut/k/img/kerr_k_deverry_3_sperenwoud_1997_1e.jpg', None, 463635, None, None, None), (515036, 'Lotsverbond', 'LTSVRBNDJP1999', '1999-00-00', 37221, '415', 'tp', 'NOVEL', '9024509238', 'https://www.deboekenplank.nl/naslag/aut/k/img/kerr_k_deverry_4_lotsverbond_1999_2e.jpg', None, 463636, None, None, None), (525291, 'Vuur uit de hemel', 'VRTDHMLRGF1999', '1999-00-00', 37221, '832', 'tp', 'NOVEL', '9024527201', 'https://www.deboekenplank.nl/naslag/aut/j/img/jordan_r_rad_5_1999.jpg', None, 476155, None, None, None), (525915, 'Het Palazzo', 'HTPLZZKFDK1999', '1999-00-00', 37221, '479', 'tp', 'NOVEL', '9024522528', 'https://www.deboekenplank.nl/naslag/aut/y/img/yarbro_c_palazzo_1999.jpg', None, 476815, None, None, None), (526333, 'De drakentroon', 'DDRKNTRNDT1999', '1999-00-00', 37221, '754', 'pb', 'NOVEL', '9024534801', 'https://www.deboekenplank.nl/naslag/aut/w/img/williams_t_heugenis_1_1999_8.jpg', None, 477298, 4358, None, None), (526335, 'De steen des afscheids', 'DSTNDSFSCH1999', '1999-00-00', 37221, '697', 'pb', 'NOVEL', '9024536723', 'https://www.deboekenplank.nl/naslag/aut/w/img/williams_t_heugenis_2_1999_7.jpg', None, 477300, 4358, None, None), (526336, 'De groene engeltoren: Deel 1 - De belegering', 'DGRNNGLTRN1999', '1999-00-00', 37221, '688', 'pb', 'NOVEL', '9024536820', 'https://www.deboekenplank.nl/naslag/aut/w/img/williams_t_heugenis_3_1_1999_5.jpg', None, 477301, 4358, None, None), (527274, 'Merlijn - De Oude Magie', 'MRLJNDDMGN1999', '1999-00-00', 37221, '206', 'tp', 'NOVEL', '9024537002', 'https://www.deboekenplank.nl/naslag/aut/m/img/mallory_j_merlin_1.jpg', None, 478410, 4352, None, None), (527275, 'Merlijn - Tovenaar des Konings', 'MRLJNTVNRD1999', '1999-00-00', 37221, '223', 'tp', 'NOVEL', '9024534429', 'https://www.deboekenplank.nl/naslag/aut/m/img/mallory_j_merlin_2.jpg', None, 478411, 4352, None, None), (532167, 'Dodelijk Tij', 'DDLJKTJZQL1999', '1999-00-00', 37221, '348', 'tp', 'NOVEL', '9024509114', 'http://www.isfdb.org/wiki/images/9/9c/DDLJKTJZQL1999.jpg', '\xe2\x82\xac17.02', 484036, None, None, None), ...] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(387969, 'Spiegels en Rook', 'SPGLSNRKFP1999', '1999-00-00', 37221, '317', 'tp', 'COLLECTION', '9024536790', 'http://www.isfdb.org/wiki/images/7/7a/SPGLSNRKFP1999.jpg', '\xc6\x9239.90', 302415, None, None, None), (507121, 'Het spel der tronen', 'HTSPLDRTRN1999', '1999-00-00', 37221, '767', 'tp', 'NOVEL', '9024533929', 'https://www.deboekenplank.nl/naslag/aut/m/img/martin_g_ijs_1_1997_1.jpg', None, 453988, None, None, None), (507699, 'De Grote Jacht', 'DGRTJCHTGB1999', '1999-00-00', 37221, '672', 'tp', 'NOVEL', '9024523478', 'https://www.deboekenplank.nl/naslag/aut/j/img/jordan_r_rad_2_1995.jpg', None, 454749, None, None, None), (507815, 'De Gevangene', 'DGVNGNVQKZ1999', '1999-00-00', 37221, '430', 'tp', 'NOVEL', '9024521912', 'https://www.deboekenplank.nl/naslag/aut/r/img/russell_md_gevangene_1999.jpg', None, 454899, None, None, None), (507834, 'Het Bevel van de Zwerver', 'HTBVLVNDZW1999', '1999-00-00', 37221, '416', 'tp', 'NOVEL', '9024535727', 'https://www.deboekenplank.nl/naslag/aut/w/img/weis_hickman_roosprofeet_1_2000_2.jpg', None, 454919, None, None, None), (508402, 'Hemelse Wiskunde', 'HMLSWSKNDX1999', '1999-00-00', 37221, '451', 'tp', 'NOVEL', '9024534119', 'https://www.deboekenplank.nl/naslag/aut/k/img/keyes_g_eeuwderwonderen_2_1999_1e.jpg', None, 455619, None, None, None), (508403, 'Het Wapen van Newton', 'HTWPNVNNWT1999', '1999-00-00', 37221, '448', 'tp', 'NOVEL', '9024521874', 'https://www.deboekenplank.nl/naslag/aut/k/img/keyes_g_eeuwderwonderen_1_1999_1e.jpg', None, 455620, None, None, None), (508412, 'De Strijd der Koningen', 'DSTRJDDRKN1999', '1999-00-00', 37221, '827', 'tp', 'NOVEL', '9024511372', 'https://www.deboekenplank.nl/naslag/aut/m/img/martin_g_ijs_2_1999_1.jpg', None, 455638, None, None, None), (508962, 'De Planeet Barrayar', 'DPLNTBRRRW1999', '1999-00-00', 37221, '335', 'tp', 'NOVEL', '9024535611', 'https://www.deboekenplank.nl/naslag/aut/b/img/bujold_l_mv_1_1999.jpg', None, 456259, None, None, None), (514379, 'Legenden', 'LGNDNCBRMG1999', '1999-00-00', 37221, '670', 'tp', 'ANTHOLOGY', '9024505828', 'https://www.deboekenplank.nl/naslag/aut/s/img/silverberg_r_legenden_1999_2.jpg', None, 462788, None, None, None), (515035, 'Sperenwoud', 'SPRNWDRDRS1999', '1999-00-00', 37221, '382', 'tp', 'NOVEL', '9024527309', 'https://www.deboekenplank.nl/naslag/aut/k/img/kerr_k_deverry_3_sperenwoud_1997_1e.jpg', None, 463635, None, None, None), (515036, 'Lotsverbond', 'LTSVRBNDJP1999', '1999-00-00', 37221, '415', 'tp', 'NOVEL', '9024509238', 'https://www.deboekenplank.nl/naslag/aut/k/img/kerr_k_deverry_4_lotsverbond_1999_2e.jpg', None, 463636, None, None, None), (525291, 'Vuur uit de hemel', 'VRTDHMLRGF1999', '1999-00-00', 37221, '832', 'tp', 'NOVEL', '9024527201', 'https://www.deboekenplank.nl/naslag/aut/j/img/jordan_r_rad_5_1999.jpg', None, 476155, None, None, None), (525915, 'Het Palazzo', 'HTPLZZKFDK1999', '1999-00-00', 37221, '479', 'tp', 'NOVEL', '9024522528', 'https://www.deboekenplank.nl/naslag/aut/y/img/yarbro_c_palazzo_1999.jpg', None, 476815, None, None, None), (526333, 'De drakentroon', 'DDRKNTRNDT1999', '1999-00-00', 37221, '754', 'pb', 'NOVEL', '9024534801', 'https://www.deboekenplank.nl/naslag/aut/w/img/williams_t_heugenis_1_1999_8.jpg', None, 477298, 4358, None, None), (526335, 'De steen des afscheids', 'DSTNDSFSCH1999', '1999-00-00', 37221, '697', 'pb', 'NOVEL', '9024536723', 'https://www.deboekenplank.nl/naslag/aut/w/img/williams_t_heugenis_2_1999_7.jpg', None, 477300, 4358, None, None), (526336, 'De groene engeltoren: Deel 1 - De belegering', 'DGRNNGLTRN1999', '1999-00-00', 37221, '688', 'pb', 'NOVEL', '9024536820', 'https://www.deboekenplank.nl/naslag/aut/w/img/williams_t_heugenis_3_1_1999_5.jpg', None, 477301, 4358, None, None), (527274, 'Merlijn - De Oude Magie', 'MRLJNDDMGN1999', '1999-00-00', 37221, '206', 'tp', 'NOVEL', '9024537002', 'https://www.deboekenplank.nl/naslag/aut/m/img/mallory_j_merlin_1.jpg', None, 478410, 4352, None, None), (527275, 'Merlijn - Tovenaar des Konings', 'MRLJNTVNRD1999', '1999-00-00', 37221, '223', 'tp', 'NOVEL', '9024534429', 'https://www.deboekenplank.nl/naslag/aut/m/img/mallory_j_merlin_2.jpg', None, 478411, 4352, None, None), (532167, 'Dodelijk Tij', 'DDLJKTJZQL1999', '1999-00-00', 37221, '348', 'tp', 'NOVEL', '9024509114', 'http://www.isfdb.org/wiki/images/9/9c/DDLJKTJZQL1999.jpg', '\xe2\x82\xac17.02', 484036, 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 = (387969, 'Spiegels en Rook', 'SPGLSNRKFP1999', '1999-00-00', 37221, '317', 'tp', 'COLLECTION', '9024536790', 'http://www.isfdb.org/wiki/images/7/7a/SPGLSNRKFP1999.jpg', '\xc6\x9239.90', 302415, None, None, None), pub_authors = {387969: [(410, 'Neil Gaiman', 'Gaiman')], 507121: [(401, 'George R. R. Martin', 'Martin')], 507699: [(845, 'Robert Jordan', 'Jordan')], 507815: [(2991, 'Mary Doria Russell', 'Russell')], 507834: [(1464, 'Tracy Hickman', 'Hickman'), (671, 'Margaret Weis', 'Weis')], 508402: [(37638, 'Greg Keyes', 'Keyes')], 508403: [(37638, 'Greg Keyes', 'Keyes')], 508412: [(401, 'George R. R. Martin', 'Martin')], 508962: [(13, 'Lois McMaster Bujold', 'Bujold')], 514379: [(54, 'Robert Silverberg', 'Silverberg')], ...}, pub_publishers = {37221: 'Luitingh-Sijthoff'}, pub_series = {4352: 'Dromen en Demonen', 4358: 'Poema Pocket'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(387969, 'Spiegels en Rook', 'SPGLSNRKFP1999', '1999-00-00', 37221, '317', 'tp', 'COLLECTION', '9024536790', 'http://www.isfdb.org/wiki/images/7/7a/SPGLSNRKFP1999.jpg', '\xc6\x9239.90', 302415, None, None, None), pub_authors={387969: [(410, 'Neil Gaiman', 'Gaiman')], 507121: [(401, 'George R. R. Martin', 'Martin')], 507699: [(845, 'Robert Jordan', 'Jordan')], 507815: [(2991, 'Mary Doria Russell', 'Russell')], 507834: [(1464, 'Tracy Hickman', 'Hickman'), (671, 'Margaret Weis', 'Weis')], 508402: [(37638, 'Greg Keyes', 'Keyes')], 508403: [(37638, 'Greg Keyes', 'Keyes')], 508412: [(401, 'George R. R. Martin', 'Martin')], 508962: [(13, 'Lois McMaster Bujold', 'Bujold')], 514379: [(54, 'Robert Silverberg', 'Silverberg')], ...}, pub_publishers={37221: 'Luitingh-Sijthoff'}, pub_series={4352: 'Dromen en Demonen', 4358: 'Poema Pocket'}, 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 = (387969, 'Spiegels en Rook', 'SPGLSNRKFP1999', '1999-00-00', 37221, '317', 'tp', 'COLLECTION', '9024536790', 'http://www.isfdb.org/wiki/images/7/7a/SPGLSNRKFP1999.jpg', '\xc6\x9239.90', 302415, 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=387969, displayed_value='Spiegels en Rook', 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 = 387969 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=387969) |
| 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=387969' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=387969') |
| 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=387969' |
| /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=387969') |
| 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=387969' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''