ISFDB banner

Publisher Black Coat Press: Books Published in 2009

You are not logged in. If you create a free account and sign in, you will be able to customize what is displayed.

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
Thu May 2 01:47:38 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 = [(319537, 'Sherlock Holmes and the Vampires of Eternity', 'SHRLCKHLMS2009', '2009-01-00', 17405, '346', 'tp', 'NOVEL', '9781934543061', 'http://www.isfdb.org/wiki/images/6/62/SHRLCKHLMS2009.jpg', '$24.95', 220388, None, None, None), (576205, "Les cr\xc3\xa9atures d'Hypn\xc3\xb4s: suivi de Le retour d'Hypn\xc3\xb4s", 'LSCRTRSDHP2009', '2009-01-00', 17405, '431', 'tp', 'OMNIBUS', '9781934543382', 'http://www.isfdb.org/wiki/images/4/4f/LSCRTRSDHP2009.jpg', '\xe2\x82\xac28.00', 548285, 3833, '2053', None), (686979, "Les Compagnons de l'Ombre 3", 'LSCMPGNNSD2009', '2009-01-00', 17405, '305', 'tp', 'ANTHOLOGY', '9781934543474', 'http://www.isfdb.org/wiki/images/d/d8/LSCMPGNNSD2009.jpg', '\xe2\x82\xac20.00', 733589, 3835, '12', None), (687107, "\xc3\x80 l'ombre d'Halloween: suivi de Passions Fatales", 'LMBRDHLLWN2009', '2009-01-00', 17405, '309', 'tp', 'OMNIBUS', '9781934543689', 'http://www.isfdb.org/wiki/images/d/dc/LMBRDHLLWN2009.jpg', '\xe2\x82\xac20.00', 733838, 3835, '14', None), (280795, 'The Vampires of Paris', 'TLSFTHSHDW2009', '2009-01-01', 17405, '312', 'tp', 'ANTHOLOGY', '9781934543504', 'https://m.media-amazon.com/images/P/1934543500.jpg', '$22.95', 478300, None, None, None), (352629, 'Anticipation: 50 ans de collections fantastiques et de Science-Fiction au Fleuve Noir', 'NTCPTNNSDC2009', '2009-02-00', 17405, '406', 'tp', 'NONFICTION', '9781934543641', 'http://www.isfdb.org/wiki/images/a/a5/NTCPTNNSDC2009.jpg', '\xe2\x82\xac25.00', 260748, 3876, '', None), (588784, 'Onde de choc', 'NDDCHCPWFX2009', '2009-02-00', 17405, '179', 'tp', 'NOVEL', '9781934543542', 'http://www.isfdb.org/wiki/images/d/d1/NDDCHCPWFX2009.jpg', '\xe2\x82\xac16.00', 569765, 3833, '2054', None), (588785, 'Pacifica', 'PCFCGZDBPP2009', '2009-03-00', 17405, '272', 'tp', 'COLLECTION', '9781934543733', 'http://www.isfdb.org/wiki/images/e/ee/PCFCGZDBPP2009.jpg', '\xe2\x82\xac20.00', 569766, 3833, '2055', None), (374270, 'The Germans on Venus', 'THGRMNSNVN2009', '2009-03-01', 17405, '300', 'tp', 'ANTHOLOGY', '9781934543566', 'https://m.media-amazon.com/images/I/51aMJxiAtuL.jpg', '$22.95', 286677, 2439, '20', None), (374286, 'Science Fiction Illustrations', 'SCNCFCTNLL2009', '2009-03-02', 17405, '59', 'tp', 'NONFICTION', '9781934543795', 'http://www.isfdb.org/wiki/images/9/9c/SCNCFCTNLL2009.jpg', '$12.95', 286696, None, None, None), (588789, 'Enigma', 'NGMTRGKRQN2009', '2009-04-00', 17405, '223', 'tp', 'NOVEL', '9781934543764', 'http://www.isfdb.org/wiki/images/4/43/NGMTRGKRQN2009.jpg', '\xe2\x82\xac17.00', 569785, 3833, '2056', None), (590706, 'Dimension URSS', 'DMNSNRSSRW2009', '2009-04-00', 17405, '295', 'tp', 'ANTHOLOGY', '9781934543702', 'http://www.isfdb.org/wiki/images/3/3d/DMNSNRSSRW2009.jpg', '\xe2\x82\xac20.00', 573273, 3836, '5', None), (387248, 'The Terror of Fu Manchu', 'THTRRRFFMN2009', '2009-04-01', 17405, '248', 'tp', 'NOVEL', '9781934543719', 'https://m.media-amazon.com/images/I/51HWEK%2BDRcL.jpg', '$20.95', 301532, None, None, None), (528697, 'The Terror of Fu Manchu: Collectors Edition', 'THTRRRFFMB2009', '2009-04-01', 17405, '192', 'hc', 'NOVEL', '9781934543801', 'https://m.media-amazon.com/images/I/51%2BfKTBx5BL.jpg', '$39.95', 479994, None, None, None), (588811, 'Le voleur de Shorn', 'LVLRDSHRNP2009', '2009-05-00', 17405, '229', 'tp', 'NOVEL', '9781934543665', 'http://www.isfdb.org/wiki/images/b/bf/LVLRDSHRNP2009.jpg', '\xe2\x82\xac17.00', 569817, 3833, '2057', None), (374411, 'Panic in Paris', 'PNCNPRSPXK2009', '2009-05-01', 17405, '252', 'tp', 'NOVEL', '9781934543832', 'https://m.media-amazon.com/images/I/51gDlAifOcL.jpg', '$20.95', 286827, 2439, '25', None), (588886, 'Nova Roma', 'NVRMHXLBCC2009', '2009-06-00', 17405, '223', 'tp', 'NOVEL', '9781934543771', 'http://www.isfdb.org/wiki/images/5/55/NVRMHXLBCC2009.jpg', '\xe2\x82\xac17.00', 569997, 3833, '2058', None), (686982, '16, rue du Repos', 'RDRPSTWNQT2009', '2009-06-00', 17405, '249', 'tp', 'NOVEL', '9781934543917', 'http://www.isfdb.org/wiki/images/f/ff/RDRPSTWNQT2009.jpg', '\xe2\x82\xac17.00', 733600, 3835, '13', None), (374274, 'Journey to the Land of the Fourth Dimension', 'JRNTTHLNDF2009', '2009-06-01', 17405, '308', 'tp', 'NOVEL', '9781934543375', 'https://m.media-amazon.com/images/I/51Y2cTpKhzL.jpg', '$22.95', 286681, 2439, '21', None), (374438, 'Enter the Nyctalope', 'NTRTHNCTLP2009', '2009-06-30', 17405, '208', 'tp', 'ANTHOLOGY', '9781934543993', 'https://m.media-amazon.com/images/I/51oEbFGQNIL.jpg', '$19.95', 286870, None, None, None), ...]
 /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(319537, 'Sherlock Holmes and the Vampires of Eternity', 'SHRLCKHLMS2009', '2009-01-00', 17405, '346', 'tp', 'NOVEL', '9781934543061', 'http://www.isfdb.org/wiki/images/6/62/SHRLCKHLMS2009.jpg', '$24.95', 220388, None, None, None), (576205, "Les cr\xc3\xa9atures d'Hypn\xc3\xb4s: suivi de Le retour d'Hypn\xc3\xb4s", 'LSCRTRSDHP2009', '2009-01-00', 17405, '431', 'tp', 'OMNIBUS', '9781934543382', 'http://www.isfdb.org/wiki/images/4/4f/LSCRTRSDHP2009.jpg', '\xe2\x82\xac28.00', 548285, 3833, '2053', None), (686979, "Les Compagnons de l'Ombre 3", 'LSCMPGNNSD2009', '2009-01-00', 17405, '305', 'tp', 'ANTHOLOGY', '9781934543474', 'http://www.isfdb.org/wiki/images/d/d8/LSCMPGNNSD2009.jpg', '\xe2\x82\xac20.00', 733589, 3835, '12', None), (687107, "\xc3\x80 l'ombre d'Halloween: suivi de Passions Fatales", 'LMBRDHLLWN2009', '2009-01-00', 17405, '309', 'tp', 'OMNIBUS', '9781934543689', 'http://www.isfdb.org/wiki/images/d/dc/LMBRDHLLWN2009.jpg', '\xe2\x82\xac20.00', 733838, 3835, '14', None), (280795, 'The Vampires of Paris', 'TLSFTHSHDW2009', '2009-01-01', 17405, '312', 'tp', 'ANTHOLOGY', '9781934543504', 'https://m.media-amazon.com/images/P/1934543500.jpg', '$22.95', 478300, None, None, None), (352629, 'Anticipation: 50 ans de collections fantastiques et de Science-Fiction au Fleuve Noir', 'NTCPTNNSDC2009', '2009-02-00', 17405, '406', 'tp', 'NONFICTION', '9781934543641', 'http://www.isfdb.org/wiki/images/a/a5/NTCPTNNSDC2009.jpg', '\xe2\x82\xac25.00', 260748, 3876, '', None), (588784, 'Onde de choc', 'NDDCHCPWFX2009', '2009-02-00', 17405, '179', 'tp', 'NOVEL', '9781934543542', 'http://www.isfdb.org/wiki/images/d/d1/NDDCHCPWFX2009.jpg', '\xe2\x82\xac16.00', 569765, 3833, '2054', None), (588785, 'Pacifica', 'PCFCGZDBPP2009', '2009-03-00', 17405, '272', 'tp', 'COLLECTION', '9781934543733', 'http://www.isfdb.org/wiki/images/e/ee/PCFCGZDBPP2009.jpg', '\xe2\x82\xac20.00', 569766, 3833, '2055', None), (374270, 'The Germans on Venus', 'THGRMNSNVN2009', '2009-03-01', 17405, '300', 'tp', 'ANTHOLOGY', '9781934543566', 'https://m.media-amazon.com/images/I/51aMJxiAtuL.jpg', '$22.95', 286677, 2439, '20', None), (374286, 'Science Fiction Illustrations', 'SCNCFCTNLL2009', '2009-03-02', 17405, '59', 'tp', 'NONFICTION', '9781934543795', 'http://www.isfdb.org/wiki/images/9/9c/SCNCFCTNLL2009.jpg', '$12.95', 286696, None, None, None), (588789, 'Enigma', 'NGMTRGKRQN2009', '2009-04-00', 17405, '223', 'tp', 'NOVEL', '9781934543764', 'http://www.isfdb.org/wiki/images/4/43/NGMTRGKRQN2009.jpg', '\xe2\x82\xac17.00', 569785, 3833, '2056', None), (590706, 'Dimension URSS', 'DMNSNRSSRW2009', '2009-04-00', 17405, '295', 'tp', 'ANTHOLOGY', '9781934543702', 'http://www.isfdb.org/wiki/images/3/3d/DMNSNRSSRW2009.jpg', '\xe2\x82\xac20.00', 573273, 3836, '5', None), (387248, 'The Terror of Fu Manchu', 'THTRRRFFMN2009', '2009-04-01', 17405, '248', 'tp', 'NOVEL', '9781934543719', 'https://m.media-amazon.com/images/I/51HWEK%2BDRcL.jpg', '$20.95', 301532, None, None, None), (528697, 'The Terror of Fu Manchu: Collectors Edition', 'THTRRRFFMB2009', '2009-04-01', 17405, '192', 'hc', 'NOVEL', '9781934543801', 'https://m.media-amazon.com/images/I/51%2BfKTBx5BL.jpg', '$39.95', 479994, None, None, None), (588811, 'Le voleur de Shorn', 'LVLRDSHRNP2009', '2009-05-00', 17405, '229', 'tp', 'NOVEL', '9781934543665', 'http://www.isfdb.org/wiki/images/b/bf/LVLRDSHRNP2009.jpg', '\xe2\x82\xac17.00', 569817, 3833, '2057', None), (374411, 'Panic in Paris', 'PNCNPRSPXK2009', '2009-05-01', 17405, '252', 'tp', 'NOVEL', '9781934543832', 'https://m.media-amazon.com/images/I/51gDlAifOcL.jpg', '$20.95', 286827, 2439, '25', None), (588886, 'Nova Roma', 'NVRMHXLBCC2009', '2009-06-00', 17405, '223', 'tp', 'NOVEL', '9781934543771', 'http://www.isfdb.org/wiki/images/5/55/NVRMHXLBCC2009.jpg', '\xe2\x82\xac17.00', 569997, 3833, '2058', None), (686982, '16, rue du Repos', 'RDRPSTWNQT2009', '2009-06-00', 17405, '249', 'tp', 'NOVEL', '9781934543917', 'http://www.isfdb.org/wiki/images/f/ff/RDRPSTWNQT2009.jpg', '\xe2\x82\xac17.00', 733600, 3835, '13', None), (374274, 'Journey to the Land of the Fourth Dimension', 'JRNTTHLNDF2009', '2009-06-01', 17405, '308', 'tp', 'NOVEL', '9781934543375', 'https://m.media-amazon.com/images/I/51Y2cTpKhzL.jpg', '$22.95', 286681, 2439, '21', None), (374438, 'Enter the Nyctalope', 'NTRTHNCTLP2009', '2009-06-30', 17405, '208', 'tp', 'ANTHOLOGY', '9781934543993', 'https://m.media-amazon.com/images/I/51oEbFGQNIL.jpg', '$19.95', 286870, 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 = (319537, 'Sherlock Holmes and the Vampires of Eternity', 'SHRLCKHLMS2009', '2009-01-00', 17405, '346', 'tp', 'NOVEL', '9781934543061', 'http://www.isfdb.org/wiki/images/6/62/SHRLCKHLMS2009.jpg', '$24.95', 220388, None, None, None), pub_authors = {280795: [(21534, 'Jean-Marc Lofficier', 'Lofficier'), (21535, 'Randy Lofficier', 'Lofficier')], 319537: [(556, 'Brian Stableford', 'Stableford')], 321928: [(21534, 'Jean-Marc Lofficier', 'Lofficier'), (21535, 'Randy Lofficier', 'Lofficier')], 329842: [(25313, 'Albert Robida', 'Robida')], 329848: [(556, 'Brian Stableford', 'Stableford')], 352629: [(156910, 'Alain Douilly', 'Douilly')], 374270: [(556, 'Brian Stableford', 'Stableford')], 374274: [(168632, 'Gaston de Pawlowski', 'Pawlowski')], 374286: [(24890, 'Jean-Pierre Normand', 'Normand')], 374288: [(168637, 'Henri de Graffigny', 'Graffigny'), (130238, 'Georges Le Faure', 'Le Faure')], ...}, pub_publishers = {17405: 'Black Coat Press'}, pub_series = {2439: 'Black Coat French Science Fiction', 2451: 'Black Coat French Horror', 3833: 'Rivi\xc3\xa8re Blanche', 3835: 'Rivi\xc3\xa8re Blanche - Collection Noire', 3836: 'Rivi\xc3\xa8re Blanche - Collection Fus\xc3\xa9e', 3876: 'Rivi\xc3\xa8re Blanche - Hors-Collection'}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1
 /home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(319537, 'Sherlock Holmes and the Vampires of Eternity', 'SHRLCKHLMS2009', '2009-01-00', 17405, '346', 'tp', 'NOVEL', '9781934543061', 'http://www.isfdb.org/wiki/images/6/62/SHRLCKHLMS2009.jpg', '$24.95', 220388, None, None, None), pub_authors={280795: [(21534, 'Jean-Marc Lofficier', 'Lofficier'), (21535, 'Randy Lofficier', 'Lofficier')], 319537: [(556, 'Brian Stableford', 'Stableford')], 321928: [(21534, 'Jean-Marc Lofficier', 'Lofficier'), (21535, 'Randy Lofficier', 'Lofficier')], 329842: [(25313, 'Albert Robida', 'Robida')], 329848: [(556, 'Brian Stableford', 'Stableford')], 352629: [(156910, 'Alain Douilly', 'Douilly')], 374270: [(556, 'Brian Stableford', 'Stableford')], 374274: [(168632, 'Gaston de Pawlowski', 'Pawlowski')], 374286: [(24890, 'Jean-Pierre Normand', 'Normand')], 374288: [(168637, 'Henri de Graffigny', 'Graffigny'), (130238, 'Georges Le Faure', 'Le Faure')], ...}, pub_publishers={17405: 'Black Coat Press'}, pub_series={2439: 'Black Coat French Science Fiction', 2451: 'Black Coat French Horror', 3833: 'Rivi\xc3\xa8re Blanche', 3835: 'Rivi\xc3\xa8re Blanche - Collection Noire', 3836: 'Rivi\xc3\xa8re Blanche - Collection Fus\xc3\xa9e', 3876: 'Rivi\xc3\xa8re Blanche - Hors-Collection'}, 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 = (319537, 'Sherlock Holmes and the Vampires of Eternity', 'SHRLCKHLMS2009', '2009-01-00', 17405, '346', 'tp', 'NOVEL', '9781934543061', 'http://www.isfdb.org/wiki/images/6/62/SHRLCKHLMS2009.jpg', '$24.95', 220388, 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=319537, displayed_value='Sherlock Holmes and the Vampires of Eternity', 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 = 319537
 /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=319537)
   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=319537'
 /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=319537')
     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=319537'
 /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=319537')
    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=319537'

<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
      args = (1146, "Table 'isfdb.trans_pubs' doesn't exist")
      message = ''