Publisher HarperCollins (Australia): Books Published in 2018

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
Wed May 1 05:42:56 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 = [(672174, 'Low Chicago', 'LWCHCGPJDZ0000', '2018-00-00', 714, '', 'tp', 'NOVEL', '9780008285203', 'https://images-na.ssl-images-amazon.com/images/I/5191B2VpqUL.jpg', '', 711753, None, None, None), (704868, 'His Name Was Walter', 'HSNMWSWLTR2018', '2018-07-23', 714, '288', 'hc', 'NOVEL', '9781460756188', 'https://images-na.ssl-images-amazon.com/images/I/51K5yGmKbCL.jpg', None, 770078, None, None, None), (704874, 'Lady Helen and the Dark Days Deceit', 'LDHLNNDTHD2018', '2018-12-01', 714, None, 'ebook', 'NOVEL', None, 'https://images-fe.ssl-images-amazon.com/images/I/51ZdND8YuuL.jpg', None, None, None, None, None)]

/home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(672174, 'Low Chicago', 'LWCHCGPJDZ0000', '2018-00-00', 714, '', 'tp', 'NOVEL', '9780008285203', 'https://images-na.ssl-images-amazon.com/images/I/5191B2VpqUL.jpg', '', 711753, None, None, None), (704868, 'His Name Was Walter', 'HSNMWSWLTR2018', '2018-07-23', 714, '288', 'hc', 'NOVEL', '9781460756188', 'https://images-na.ssl-images-amazon.com/images/I/51K5yGmKbCL.jpg', None, 770078, None, None, None), (704874, 'Lady Helen and the Dark Days Deceit', 'LDHLNNDTHD2018', '2018-12-01', 714, None, 'ebook', 'NOVEL', None, 'https://images-fe.ssl-images-amazon.com/images/I/51ZdND8YuuL.jpg', None, None, 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 = (672174, 'Low Chicago', 'LWCHCGPJDZ0000', '2018-00-00', 714, '', 'tp', 'NOVEL', '9780008285203', 'https://images-na.ssl-images-amazon.com/images/I/5191B2VpqUL.jpg', '', 711753, None, None, None), pub_authors = {672174: [(136774, 'Saladin Ahmed', 'Ahmed'), (3257, 'Paul Cornell', 'Cornell'), (160245, 'Marko Kloos', 'Kloos'), (5204, 'John J. Miller', 'Miller'), (80741, 'Mary Anne Mohanraj', 'Mohanraj'), (5169, 'Kevin Andrew Murphy', 'Murphy'), (17471, 'Christopher Rowe', 'Rowe'), (1567, 'Melinda M. Snodgrass', 'Snodgrass')], 704868: [(4845, 'Emily Rodda', 'Rodda')], 704874: [(18301, 'Alison Goodman', 'Goodman')]}, pub_publishers = {714: 'HarperCollins (Australia)'}, 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=(672174, 'Low Chicago', 'LWCHCGPJDZ0000', '2018-00-00', 714, '', 'tp', 'NOVEL', '9780008285203', 'https://images-na.ssl-images-amazon.com/images/I/5191B2VpqUL.jpg', '', 711753, None, None, None), pub_authors={672174: [(136774, 'Saladin Ahmed', 'Ahmed'), (3257, 'Paul Cornell', 'Cornell'), (160245, 'Marko Kloos', 'Kloos'), (5204, 'John J. Miller', 'Miller'), (80741, 'Mary Anne Mohanraj', 'Mohanraj'), (5169, 'Kevin Andrew Murphy', 'Murphy'), (17471, 'Christopher Rowe', 'Rowe'), (1567, 'Melinda M. Snodgrass', 'Snodgrass')], 704868: [(4845, 'Emily Rodda', 'Rodda')], 704874: [(18301, 'Alison Goodman', 'Goodman')]}, pub_publishers={714: 'HarperCollins (Australia)'}, 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 = (672174, 'Low Chicago', 'LWCHCGPJDZ0000', '2018-00-00', 714, '', 'tp', 'NOVEL', '9780008285203', 'https://images-na.ssl-images-amazon.com/images/I/5191B2VpqUL.jpg', '', 711753, 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=672174, displayed_value='Low Chicago', 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 = 672174

/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=672174)

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=672174'

/home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=672174')

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=672174'

/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=672174')

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=672174'

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

Publisher HarperCollins (Australia): Books Published in 2018

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