ISFDB banner

Publisher HarperCollins: Books Published in 2024

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 yearReturn 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
Sun Apr 28 09:39:32 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 = [(981938, 'Lulu Sinagtala and the City of Noble Warriors', 'LLSNGTLNDT2024', '2024-01-09', 4, '368', 'hc', 'NOVEL', '9780063255364', 'https://m.media-amazon.com/images/I/51sgFwJ00QL.jpg', '$19.99', 1152311, None, None, None), (993511, 'Lulu Sinagtala and the City of Noble Warriors', 'LLSNGTLNDB2024', '2024-01-09', 4, None, 'ebook', 'NOVEL', '9780063255388', 'https://m.media-amazon.com/images/I/41WRW7HCgqL.jpg', '$10.99', 1167687, None, None, None), (982680, 'The Treacherous Tower', 'RSCTLSTHTR2024', '2024-01-16', 4, '160', 'hc', 'CHAPBOOK', '9780063224995', 'https://m.media-amazon.com/images/I/51dUl1MjojL.jpg', '$18.99', 1153562, None, None, None), (994998, 'The Treacherous Tower', 'RSCTLSTHTB2024', '2024-01-16', 4, None, 'ebook', 'CHAPBOOK', '9780063225022', 'https://m.media-amazon.com/images/I/51dUl1MjojL.jpg', '$11.99', 1169809, None, None, None), (983046, 'Monsters Take Manhattan', 'MNSTRCLBMN2024', '2024-01-30', 4, '368', 'hc', 'NOVEL', '9780063136694', 'https://m.media-amazon.com/images/I/51dpOTAuFJL.jpg', '$19.99', 1154037, None, None, None), (995263, 'Monsters Take Manhattan', 'MNSTRCLBMB2024', '2024-01-30', 4, None, 'ebook', 'NOVEL', '9780063136717', 'https://m.media-amazon.com/images/I/51dpOTAuFJL.jpg', '$10.99', 1170174, None, None, None), (986103, 'A Thousand Steps Into Night', 'THSNDSTPSN2024', '2024-02-06', 4, '384', 'tp', 'NOVEL', '9780063306677', 'https://m.media-amazon.com/images/I/51jgUYmeBUL.jpg', '$15.99', 1158217, None, None, None), (988272, 'All This Twisted Glory', 'LLTHSTWSTD2024', '2024-02-06', 4, '416', 'hc', 'NOVEL', '9780062972507', 'https://m.media-amazon.com/images/I/51dBAzDdpOL.jpg', '$19.99', 1160781, None, None, None), (990192, 'The Shattered Horn', 'BRVLNDSTHN2024', '2024-02-06', 4, '288', 'tp', 'NOVEL', '9780062966988', 'https://m.media-amazon.com/images/I/51ifUFZmlSL.jpg', '$10.99', 1163574, None, None, None), (990193, 'Breakers of the Code', 'BRVLNDSTHB2024', '2024-02-06', 4, '208', 'hc', 'NOVEL', '9780062967008', 'https://m.media-amazon.com/images/I/51MsLFoapIL.jpg', '$19.99', 1163575, None, None, None), (995267, 'Breakers of the Code', 'BRVLNDSTHC2024', '2024-02-06', 4, None, 'ebook', 'NOVEL', '9780062967039', 'https://m.media-amazon.com/images/I/51MsLFoapIL.jpg', '$10.99', 1170179, None, None, None), (995307, 'All This Twisted Glory', 'LLTHSTWSTB2024', '2024-02-06', 4, None, 'ebook', 'NOVEL', '9780062972521', 'https://m.media-amazon.com/images/I/51dBAzDdpOL.jpg', '$10.99', 1170230, None, None, None), (990072, 'Kindling', 'KNDLNGRVDD2024', '2024-02-27', 4, '432', 'hc', 'NOVEL', '9780063269354', 'https://m.media-amazon.com/images/I/51xFpmJIuEL.jpg', '$19.99', 1163438, None, None, None), (995308, 'Kindling', 'KNDLNGVHRX2024', '2024-02-27', 4, None, 'ebook', 'NOVEL', '9780063269378', 'https://m.media-amazon.com/images/I/51xFpmJIuEL.jpg', '$9.99', 1170231, None, None, None), (999269, 'Kindling', 'KNDLNGBVDD2024', '2024-02-27', 4, '432', 'tp', 'NOVEL', '9780063381353', 'https://m.media-amazon.com/images/I/51Iv4-z3AkL.jpg', '$', 1176153, None, None, None), (991786, 'Phoenix and the Frost Palace', 'FRBRNPHNXN2024', '2024-03-19', 4, '448', 'tp', 'NOVEL', '9780062996756', 'https://m.media-amazon.com/images/I/511Eap1VEML.jpg', '$9.99', 1165540, None, None, None), (997992, 'Shadow', 'WRRRSSTRLS2024', '2024-04-02', 4, '320', 'tp', 'NOVEL', '9780063050228', 'https://m.media-amazon.com/images/I/41+ORdud55L.jpg', '$10.99', 1174015, None, None, None), (997993, 'Wind', 'WRRRSSTRLB2024', '2024-04-02', 4, '304', 'hc', 'NOVEL', '9780063050334', 'https://m.media-amazon.com/images/I/51a9ATjrh8L.jpg', '$19.99', 1174016, None, None, None), (998651, 'Wind', 'WRRRSSTRLC2024', '2024-04-02', 4, None, 'ebook', 'NOVEL', '9780063050365', 'https://m.media-amazon.com/images/I/51a9ATjrh8L.jpg', '$10.99', 1175077, None, None, None), (997299, 'Starling and the Cavern of Light', 'FRBRNSTRLN2024', '2024-04-16', 4, '512', 'hc', 'NOVEL', '9780062996770', 'https://m.media-amazon.com/images/I/51tGMXvAHEL.jpg', '$19.99', 1173001, None, None, None), ...]
 /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(981938, 'Lulu Sinagtala and the City of Noble Warriors', 'LLSNGTLNDT2024', '2024-01-09', 4, '368', 'hc', 'NOVEL', '9780063255364', 'https://m.media-amazon.com/images/I/51sgFwJ00QL.jpg', '$19.99', 1152311, None, None, None), (993511, 'Lulu Sinagtala and the City of Noble Warriors', 'LLSNGTLNDB2024', '2024-01-09', 4, None, 'ebook', 'NOVEL', '9780063255388', 'https://m.media-amazon.com/images/I/41WRW7HCgqL.jpg', '$10.99', 1167687, None, None, None), (982680, 'The Treacherous Tower', 'RSCTLSTHTR2024', '2024-01-16', 4, '160', 'hc', 'CHAPBOOK', '9780063224995', 'https://m.media-amazon.com/images/I/51dUl1MjojL.jpg', '$18.99', 1153562, None, None, None), (994998, 'The Treacherous Tower', 'RSCTLSTHTB2024', '2024-01-16', 4, None, 'ebook', 'CHAPBOOK', '9780063225022', 'https://m.media-amazon.com/images/I/51dUl1MjojL.jpg', '$11.99', 1169809, None, None, None), (983046, 'Monsters Take Manhattan', 'MNSTRCLBMN2024', '2024-01-30', 4, '368', 'hc', 'NOVEL', '9780063136694', 'https://m.media-amazon.com/images/I/51dpOTAuFJL.jpg', '$19.99', 1154037, None, None, None), (995263, 'Monsters Take Manhattan', 'MNSTRCLBMB2024', '2024-01-30', 4, None, 'ebook', 'NOVEL', '9780063136717', 'https://m.media-amazon.com/images/I/51dpOTAuFJL.jpg', '$10.99', 1170174, None, None, None), (986103, 'A Thousand Steps Into Night', 'THSNDSTPSN2024', '2024-02-06', 4, '384', 'tp', 'NOVEL', '9780063306677', 'https://m.media-amazon.com/images/I/51jgUYmeBUL.jpg', '$15.99', 1158217, None, None, None), (988272, 'All This Twisted Glory', 'LLTHSTWSTD2024', '2024-02-06', 4, '416', 'hc', 'NOVEL', '9780062972507', 'https://m.media-amazon.com/images/I/51dBAzDdpOL.jpg', '$19.99', 1160781, None, None, None), (990192, 'The Shattered Horn', 'BRVLNDSTHN2024', '2024-02-06', 4, '288', 'tp', 'NOVEL', '9780062966988', 'https://m.media-amazon.com/images/I/51ifUFZmlSL.jpg', '$10.99', 1163574, None, None, None), (990193, 'Breakers of the Code', 'BRVLNDSTHB2024', '2024-02-06', 4, '208', 'hc', 'NOVEL', '9780062967008', 'https://m.media-amazon.com/images/I/51MsLFoapIL.jpg', '$19.99', 1163575, None, None, None), (995267, 'Breakers of the Code', 'BRVLNDSTHC2024', '2024-02-06', 4, None, 'ebook', 'NOVEL', '9780062967039', 'https://m.media-amazon.com/images/I/51MsLFoapIL.jpg', '$10.99', 1170179, None, None, None), (995307, 'All This Twisted Glory', 'LLTHSTWSTB2024', '2024-02-06', 4, None, 'ebook', 'NOVEL', '9780062972521', 'https://m.media-amazon.com/images/I/51dBAzDdpOL.jpg', '$10.99', 1170230, None, None, None), (990072, 'Kindling', 'KNDLNGRVDD2024', '2024-02-27', 4, '432', 'hc', 'NOVEL', '9780063269354', 'https://m.media-amazon.com/images/I/51xFpmJIuEL.jpg', '$19.99', 1163438, None, None, None), (995308, 'Kindling', 'KNDLNGVHRX2024', '2024-02-27', 4, None, 'ebook', 'NOVEL', '9780063269378', 'https://m.media-amazon.com/images/I/51xFpmJIuEL.jpg', '$9.99', 1170231, None, None, None), (999269, 'Kindling', 'KNDLNGBVDD2024', '2024-02-27', 4, '432', 'tp', 'NOVEL', '9780063381353', 'https://m.media-amazon.com/images/I/51Iv4-z3AkL.jpg', '$', 1176153, None, None, None), (991786, 'Phoenix and the Frost Palace', 'FRBRNPHNXN2024', '2024-03-19', 4, '448', 'tp', 'NOVEL', '9780062996756', 'https://m.media-amazon.com/images/I/511Eap1VEML.jpg', '$9.99', 1165540, None, None, None), (997992, 'Shadow', 'WRRRSSTRLS2024', '2024-04-02', 4, '320', 'tp', 'NOVEL', '9780063050228', 'https://m.media-amazon.com/images/I/41+ORdud55L.jpg', '$10.99', 1174015, None, None, None), (997993, 'Wind', 'WRRRSSTRLB2024', '2024-04-02', 4, '304', 'hc', 'NOVEL', '9780063050334', 'https://m.media-amazon.com/images/I/51a9ATjrh8L.jpg', '$19.99', 1174016, None, None, None), (998651, 'Wind', 'WRRRSSTRLC2024', '2024-04-02', 4, None, 'ebook', 'NOVEL', '9780063050365', 'https://m.media-amazon.com/images/I/51a9ATjrh8L.jpg', '$10.99', 1175077, None, None, None), (997299, 'Starling and the Cavern of Light', 'FRBRNSTRLN2024', '2024-04-16', 4, '512', 'hc', 'NOVEL', '9780062996770', 'https://m.media-amazon.com/images/I/51tGMXvAHEL.jpg', '$19.99', 1173001, 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 = (981938, 'Lulu Sinagtala and the City of Noble Warriors', 'LLSNGTLNDT2024', '2024-01-09', 4, '368', 'hc', 'NOVEL', '9780063255364', 'https://m.media-amazon.com/images/I/51sgFwJ00QL.jpg', '$19.99', 1152311, None, None, None), pub_authors = {981938: [(261137, 'Gail D. Villanueva', 'Villanueva')], 982680: [(271168, 'StacyPlays', 'StacyPlays')], 983046: [(202636, 'Darren Aronofsky', 'Aronofsky'), (349320, 'Ari Handel', 'Handel'), (216294, 'Lance Rubin', 'Rubin')], 986103: [(233692, 'Traci Chee', 'Chee')], 988272: [(161903, 'Tahereh Mafi', 'Mafi')], 990072: [(233692, 'Traci Chee', 'Chee')], 990192: [(7269, 'Erin Hunter', 'Hunter')], 990193: [(7269, 'Erin Hunter', 'Hunter')], 991786: [(331780, 'Aisling Fowler', 'Fowler')], 993511: [(261137, 'Gail D. Villanueva', 'Villanueva')], ...}, pub_publishers = {4: 'HarperCollins'}, 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=(981938, 'Lulu Sinagtala and the City of Noble Warriors', 'LLSNGTLNDT2024', '2024-01-09', 4, '368', 'hc', 'NOVEL', '9780063255364', 'https://m.media-amazon.com/images/I/51sgFwJ00QL.jpg', '$19.99', 1152311, None, None, None), pub_authors={981938: [(261137, 'Gail D. Villanueva', 'Villanueva')], 982680: [(271168, 'StacyPlays', 'StacyPlays')], 983046: [(202636, 'Darren Aronofsky', 'Aronofsky'), (349320, 'Ari Handel', 'Handel'), (216294, 'Lance Rubin', 'Rubin')], 986103: [(233692, 'Traci Chee', 'Chee')], 988272: [(161903, 'Tahereh Mafi', 'Mafi')], 990072: [(233692, 'Traci Chee', 'Chee')], 990192: [(7269, 'Erin Hunter', 'Hunter')], 990193: [(7269, 'Erin Hunter', 'Hunter')], 991786: [(331780, 'Aisling Fowler', 'Fowler')], 993511: [(261137, 'Gail D. Villanueva', 'Villanueva')], ...}, pub_publishers={4: 'HarperCollins'}, 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 = (981938, 'Lulu Sinagtala and the City of Noble Warriors', 'LLSNGTLNDT2024', '2024-01-09', 4, '368', 'hc', 'NOVEL', '9780063255364', 'https://m.media-amazon.com/images/I/51sgFwJ00QL.jpg', '$19.99', 1152311, 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=981938, displayed_value='Lulu Sinagtala and the City of Noble Warriors', 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 = 981938
 /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=981938)
   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=981938'
 /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=981938')
     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=981938'
 /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=981938')
    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=981938'

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