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 Sun Apr 28 07:51:59 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 = [(750812, "Cupid's Busted Arrow", 'CPDSBSTDRR2015', '2015-01-02', 30811, '', 'ebook', 'NOVEL', '9781628307757', 'https://images-na.ssl-images-amazon.com/images/I/51c9fUb2%2BmL.jpg', '$4.99', 840645, 3928, None, None), (722125, 'Forever Green', 'FRVRGRNWBV2015', '2015-01-07', 30811, None, 'ebook', 'NOVEL', '9781628307245', 'https://images-na.ssl-images-amazon.com/images/I/51Y3LOHULAL.jpg', '$5.99', 794050, 4676, None, None), (722078, 'Bedeviled Angel', 'BDVLDNGLJD2015', '2015-01-15', 30811, '274', 'tp', 'NOVEL', '9781628307184', 'https://images-na.ssl-images-amazon.com/images/I/51fk8aZtdHL.jpg', '$14.99', 794000, 3928, None, None), (722556, 'The Calypso Ring', 'THCLPSRNGT2015', '2015-01-15', 30811, '252', 'tp', 'NOVEL', '9781628307313', 'https://images-na.ssl-images-amazon.com/images/I/51-EvP1a%2BsL.jpg', '$14.99', 794540, 7973, None, None), (698882, 'A Ghost of a Clue', 'GHSTFCLFBF2015', '2015-01-17', 30811, '130', 'tp', 'CHAPBOOK', '9781628308600', 'https://images-na.ssl-images-amazon.com/images/I/41A3ZXx0V-L.jpg', '$11.99', 753270, 3928, None, None), (722079, 'Bedeviled Angel', 'BDVLDNGLTW2015', '2015-01-21', 30811, None, 'ebook', 'NOVEL', '9781628307191', 'https://images-na.ssl-images-amazon.com/images/I/51iGpkTHCrL.jpg', '$4.99', 794001, 3928, None, None), (700553, 'Double Magick in the Falls', 'DBLMGCKNTH2015', '2015-01-23', 30811, '292', 'tp', 'NOVEL', '9781628307351', 'https://images-na.ssl-images-amazon.com/images/I/51IV3cuT-QL.jpg', '$15.99', 759670, 4676, None, None), (722557, 'The Calypso Ring', 'THCLPSRNGM2015', '2015-01-23', 30811, None, 'ebook', 'NOVEL', '9781628307320', 'https://images-na.ssl-images-amazon.com/images/I/51Bnv52FW0L.jpg', '$4.99', 794541, 7973, None, None), (700554, 'Double Magick in the Falls', 'DBLMGCKNTB2015', '2015-01-30', 30811, None, 'ebook', 'NOVEL', '9781628307368', 'https://images-na.ssl-images-amazon.com/images/I/51mTGn2fgdL.jpg', '$14.99', 759671, 4676, None, None), (722813, 'Tortured Embrace', 'TRTRDMBRCW2015', '2015-02-01', 30811, '270', 'tp', 'NOVEL', '9781628307580', 'https://images-na.ssl-images-amazon.com/images/I/51ftVoY6gtL.jpg', '$14.99', 794806, 4676, None, None), (699337, 'Smitten with Death', 'SMTTNWTHDT2015', '2015-02-07', 30811, '228', 'tp', 'NOVEL', '9781628308228', 'https://images-na.ssl-images-amazon.com/images/I/51866YuAijL.jpg', '$13.99', 755622, 4675, None, None), (722552, "The Witch's Kiss", 'THWTCHSKSS2015', '2015-02-07', 30811, '208', 'tp', 'NOVEL', '9781628307504', 'https://images-na.ssl-images-amazon.com/images/I/51duGqPjfxL.jpg', '$13.99', 794536, 4676, None, None), (722814, 'Tortured Embrace', 'TRTRDMBRCL2015', '2015-02-11', 30811, None, 'ebook', 'NOVEL', '9781628307597', 'https://images-na.ssl-images-amazon.com/images/I/51jwc98%2BGuL.jpg', '$4.99', 794807, 4676, None, None), (722546, 'Darkness Embraced', 'DRKNSSMBRC2015', '2015-02-13', 30811, '150', 'tp', 'CHAPBOOK', '9781628308709', 'https://images-na.ssl-images-amazon.com/images/I/51Q4rwoaTBL.jpg', '$11.99', 794530, 4675, None, None), (750044, 'Dead Handsome', 'DDHNDSMBFB2015', '2015-02-13', 30811, '324', 'tp', 'NOVEL', '9781628307641', 'https://images-na.ssl-images-amazon.com/images/I/51qfrPu6AXL.jpg', '$16.99', 839658, 4675, None, None), (722553, "The Witch's Kiss", 'THWTCHSKSB2015', '2015-02-18', 30811, None, 'ebook', 'NOVEL', '9781628307511', 'https://images-na.ssl-images-amazon.com/images/I/51f1OYDwC8L.jpg', '$3.99', 794537, 4676, None, None), (699338, 'Smitten with Death', 'SMTTNWTHDB2015', '2015-02-20', 30811, '', 'ebook', 'NOVEL', '9781628308235', 'https://images-na.ssl-images-amazon.com/images/I/516Fs7emumL.jpg', '$4.99', 755623, 4675, None, None), (722547, 'Darkness Embraced', 'DRKNSSMBRB2015', '2015-02-25', 30811, None, 'ebook', 'CHAPBOOK', '9781628307894', 'https://images-na.ssl-images-amazon.com/images/I/518xr4e614L.jpg', '$3.99', 794531, 4675, None, None), (753877, 'Cravings', 'CRVNGSKLVD2015', '2015-02-25', 30811, '364', 'tp', 'NOVEL', '9781601548665', 'https://images-na.ssl-images-amazon.com/images/I/41buFlncXiL.jpg', '$15.99', 844313, 4676, None, None), (750043, 'Dead Handsome', 'DDHNDSMBFF2015', '2015-02-27', 30811, '', 'ebook', 'NOVEL', '9781628307658', 'https://images-na.ssl-images-amazon.com/images/I/51qPXJDOHHL.jpg', '$4.99', 839657, 4675, None, None), ...] |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintPubsTable(pubs=[(750812, "Cupid's Busted Arrow", 'CPDSBSTDRR2015', '2015-01-02', 30811, '', 'ebook', 'NOVEL', '9781628307757', 'https://images-na.ssl-images-amazon.com/images/I/51c9fUb2%2BmL.jpg', '$4.99', 840645, 3928, None, None), (722125, 'Forever Green', 'FRVRGRNWBV2015', '2015-01-07', 30811, None, 'ebook', 'NOVEL', '9781628307245', 'https://images-na.ssl-images-amazon.com/images/I/51Y3LOHULAL.jpg', '$5.99', 794050, 4676, None, None), (722078, 'Bedeviled Angel', 'BDVLDNGLJD2015', '2015-01-15', 30811, '274', 'tp', 'NOVEL', '9781628307184', 'https://images-na.ssl-images-amazon.com/images/I/51fk8aZtdHL.jpg', '$14.99', 794000, 3928, None, None), (722556, 'The Calypso Ring', 'THCLPSRNGT2015', '2015-01-15', 30811, '252', 'tp', 'NOVEL', '9781628307313', 'https://images-na.ssl-images-amazon.com/images/I/51-EvP1a%2BsL.jpg', '$14.99', 794540, 7973, None, None), (698882, 'A Ghost of a Clue', 'GHSTFCLFBF2015', '2015-01-17', 30811, '130', 'tp', 'CHAPBOOK', '9781628308600', 'https://images-na.ssl-images-amazon.com/images/I/41A3ZXx0V-L.jpg', '$11.99', 753270, 3928, None, None), (722079, 'Bedeviled Angel', 'BDVLDNGLTW2015', '2015-01-21', 30811, None, 'ebook', 'NOVEL', '9781628307191', 'https://images-na.ssl-images-amazon.com/images/I/51iGpkTHCrL.jpg', '$4.99', 794001, 3928, None, None), (700553, 'Double Magick in the Falls', 'DBLMGCKNTH2015', '2015-01-23', 30811, '292', 'tp', 'NOVEL', '9781628307351', 'https://images-na.ssl-images-amazon.com/images/I/51IV3cuT-QL.jpg', '$15.99', 759670, 4676, None, None), (722557, 'The Calypso Ring', 'THCLPSRNGM2015', '2015-01-23', 30811, None, 'ebook', 'NOVEL', '9781628307320', 'https://images-na.ssl-images-amazon.com/images/I/51Bnv52FW0L.jpg', '$4.99', 794541, 7973, None, None), (700554, 'Double Magick in the Falls', 'DBLMGCKNTB2015', '2015-01-30', 30811, None, 'ebook', 'NOVEL', '9781628307368', 'https://images-na.ssl-images-amazon.com/images/I/51mTGn2fgdL.jpg', '$14.99', 759671, 4676, None, None), (722813, 'Tortured Embrace', 'TRTRDMBRCW2015', '2015-02-01', 30811, '270', 'tp', 'NOVEL', '9781628307580', 'https://images-na.ssl-images-amazon.com/images/I/51ftVoY6gtL.jpg', '$14.99', 794806, 4676, None, None), (699337, 'Smitten with Death', 'SMTTNWTHDT2015', '2015-02-07', 30811, '228', 'tp', 'NOVEL', '9781628308228', 'https://images-na.ssl-images-amazon.com/images/I/51866YuAijL.jpg', '$13.99', 755622, 4675, None, None), (722552, "The Witch's Kiss", 'THWTCHSKSS2015', '2015-02-07', 30811, '208', 'tp', 'NOVEL', '9781628307504', 'https://images-na.ssl-images-amazon.com/images/I/51duGqPjfxL.jpg', '$13.99', 794536, 4676, None, None), (722814, 'Tortured Embrace', 'TRTRDMBRCL2015', '2015-02-11', 30811, None, 'ebook', 'NOVEL', '9781628307597', 'https://images-na.ssl-images-amazon.com/images/I/51jwc98%2BGuL.jpg', '$4.99', 794807, 4676, None, None), (722546, 'Darkness Embraced', 'DRKNSSMBRC2015', '2015-02-13', 30811, '150', 'tp', 'CHAPBOOK', '9781628308709', 'https://images-na.ssl-images-amazon.com/images/I/51Q4rwoaTBL.jpg', '$11.99', 794530, 4675, None, None), (750044, 'Dead Handsome', 'DDHNDSMBFB2015', '2015-02-13', 30811, '324', 'tp', 'NOVEL', '9781628307641', 'https://images-na.ssl-images-amazon.com/images/I/51qfrPu6AXL.jpg', '$16.99', 839658, 4675, None, None), (722553, "The Witch's Kiss", 'THWTCHSKSB2015', '2015-02-18', 30811, None, 'ebook', 'NOVEL', '9781628307511', 'https://images-na.ssl-images-amazon.com/images/I/51f1OYDwC8L.jpg', '$3.99', 794537, 4676, None, None), (699338, 'Smitten with Death', 'SMTTNWTHDB2015', '2015-02-20', 30811, '', 'ebook', 'NOVEL', '9781628308235', 'https://images-na.ssl-images-amazon.com/images/I/516Fs7emumL.jpg', '$4.99', 755623, 4675, None, None), (722547, 'Darkness Embraced', 'DRKNSSMBRB2015', '2015-02-25', 30811, None, 'ebook', 'CHAPBOOK', '9781628307894', 'https://images-na.ssl-images-amazon.com/images/I/518xr4e614L.jpg', '$3.99', 794531, 4675, None, None), (753877, 'Cravings', 'CRVNGSKLVD2015', '2015-02-25', 30811, '364', 'tp', 'NOVEL', '9781601548665', 'https://images-na.ssl-images-amazon.com/images/I/41buFlncXiL.jpg', '$15.99', 844313, 4676, None, None), (750043, 'Dead Handsome', 'DDHNDSMBFF2015', '2015-02-27', 30811, '', 'ebook', 'NOVEL', '9781628307658', 'https://images-na.ssl-images-amazon.com/images/I/51qPXJDOHHL.jpg', '$4.99', 839657, 4675, 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 = (750812, "Cupid's Busted Arrow", 'CPDSBSTDRR2015', '2015-01-02', 30811, '', 'ebook', 'NOVEL', '9781628307757', 'https://images-na.ssl-images-amazon.com/images/I/51c9fUb2%2BmL.jpg', '$4.99', 840645, 3928, None, None), pub_authors = {521816: [(107429, 'Mary Morgan', 'Morgan')], 525112: [(107429, 'Mary Morgan', 'Morgan')], 536899: [(34283, 'Candace Sams', 'Sams')], 549073: [(34283, 'Candace Sams', 'Sams')], 553546: [(223502, 'Willa Blair', 'Blair')], 555607: [(136249, 'Alicia Dean', 'Dean'), (224227, 'Cecilia Farrell', 'Farrell'), (146574, 'Dayana Knight', 'Knight'), (134900, 'Eliza March', 'March'), (6816, 'Lara Parker', 'Parker')], 555770: [(223502, 'Willa Blair', 'Blair')], 687984: [(269390, 'Abigail Owen', 'Owen')], 687985: [(269390, 'Abigail Owen', 'Owen')], 687991: [(269390, 'Abigail Owen', 'Owen')], ...}, pub_publishers = {30811: 'The Wild Rose Press'}, pub_series = {3928: 'Faery Rose', 4675: 'Fantasy Rose', 4676: 'Black Rose', 4677: 'Vintage Rose', 7968: 'Crimson Rose', 7973: 'Scarlet Rose', 8340: 'Climbing Rose', 8344: 'Mainstream Historical', 8347: 'American Rose', 8364: 'Black Mainstream', ...}, cover_artists = {}, bgcolor = 1, display_type = 'publisher', user = <login.User instance>, index = 1 |
| /home/stoecker/isfdb/install/cgi-bin/common.py in PrintOnePub(pub=(750812, "Cupid's Busted Arrow", 'CPDSBSTDRR2015', '2015-01-02', 30811, '', 'ebook', 'NOVEL', '9781628307757', 'https://images-na.ssl-images-amazon.com/images/I/51c9fUb2%2BmL.jpg', '$4.99', 840645, 3928, None, None), pub_authors={521816: [(107429, 'Mary Morgan', 'Morgan')], 525112: [(107429, 'Mary Morgan', 'Morgan')], 536899: [(34283, 'Candace Sams', 'Sams')], 549073: [(34283, 'Candace Sams', 'Sams')], 553546: [(223502, 'Willa Blair', 'Blair')], 555607: [(136249, 'Alicia Dean', 'Dean'), (224227, 'Cecilia Farrell', 'Farrell'), (146574, 'Dayana Knight', 'Knight'), (134900, 'Eliza March', 'March'), (6816, 'Lara Parker', 'Parker')], 555770: [(223502, 'Willa Blair', 'Blair')], 687984: [(269390, 'Abigail Owen', 'Owen')], 687985: [(269390, 'Abigail Owen', 'Owen')], 687991: [(269390, 'Abigail Owen', 'Owen')], ...}, pub_publishers={30811: 'The Wild Rose Press'}, pub_series={3928: 'Faery Rose', 4675: 'Fantasy Rose', 4676: 'Black Rose', 4677: 'Vintage Rose', 7968: 'Crimson Rose', 7973: 'Scarlet Rose', 8340: 'Climbing Rose', 8344: 'Mainstream Historical', 8347: 'American Rose', 8364: 'Black Mainstream', ...}, 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 = (750812, "Cupid's Busted Arrow", 'CPDSBSTDRR2015', '2015-01-02', 30811, '', 'ebook', 'NOVEL', '9781628307757', 'https://images-na.ssl-images-amazon.com/images/I/51c9fUb2%2BmL.jpg', '$4.99', 840645, 3928, 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=750812, displayed_value="Cupid's Busted Arrow", 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 = 750812 |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in SQLloadTransPubTitles(pub_id=750812) |
| 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=750812' |
| /home/stoecker/isfdb/install/cgi-bin/SQLparsing.py in _OneField(query='select trans_pub_title from trans_pubs where pub_id=750812') |
| 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=750812' |
| /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=750812') |
| 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=750812' |
<class 'MySQLdb._exceptions.ProgrammingError'>: (1146, "Table 'isfdb.trans_pubs' doesn't exist")
args =
(1146, "Table 'isfdb.trans_pubs' doesn't exist")
message =
''