ISFDB banner

Award Bibliography: Martha Hackett

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

  • Author: Martha Hackett Author Record # 242711
  • Language: English
Not showing translations. Always display translations Registered users can choose which translations are shown.

--> -->
 
 
<class 'MySQLdb._exceptions.ProgrammingError'>
Python 2.7.18: /usr/bin/python
Sat Nov 26 04:23:52 2022

A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.

 /var/www/cgi-bin/eaw.cgi in <module>()
     19 if __name__ == '__main__':
     20 
     21         bib = Bibliography()
     22         bib.page_type = 'Award'
=>   23         bib.displayBiblio()
bib = <biblio.Bibliography instance>, bib.displayBiblio = <bound method Bibliography.displayBiblio of <biblio.Bibliography instance>>
 /var/www/cgi-bin/biblio.py in displayBiblio(self=<biblio.Bibliography instance>)
    231 
    232                 if self.page_type == 'Award':
=>  233                         self.loadAuthorAwards()
    234                         self.printAwards()
    235                 print '</div>'
self = <biblio.Bibliography instance>, self.loadAuthorAwards = <bound method Bibliography.loadAuthorAwards of <biblio.Bibliography instance>>
 /var/www/cgi-bin/biblio.py in loadAuthorAwards(self=<biblio.Bibliography instance>)
    274         def loadAuthorAwards(self):
    275                 pseudonyms = SQLgetBriefPseudoFromActual(self.au_id)
=>  276                 self.au_awards = SQLloadAwardsXBA(self.author_name, self.canonical_titles, pseudonyms)
    277 
    278         def loadParentAuthors(self):
self = <biblio.Bibliography instance>, self.au_awards = [], global SQLloadAwardsXBA = <function SQLloadAwardsXBA>, self.author_name = 'Martha Hackett', self.canonical_titles = [], pseudonyms = []
 /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='Martha Hackett', titles=[], pseudonyms=[])
    440                               and ta.title_id = t.title_id)""" % in_clause
    441         query += " order by year, title, ABS(level)"
=>  442         return _StandardQuery(query)
    443 
    444 def SQLloadAwardsForYearType(award_type_id, year):
global _StandardQuery = <function _StandardQuery>, query = "(select a.award_id, a.award_title as title, a.aw...ha Hackett+%') ) order by year, title, ABS(level)"
 /var/www/cgi-bin/SQLparsing.py in _StandardQuery(query="(select a.award_id, a.award_title as title, a.aw...ha Hackett+%') ) order by year, title, ABS(level)")
     26 
     27 def _StandardQuery(query):
=>   28         db.query(query)
     29         result = db.store_result()
     30         record = result.fetch_row()
global db = <_mysql.connection open to 'localhost'>, db.query = <bound method Connection.query of <_mysql.connection open to 'localhost'>>, query = "(select a.award_id, a.award_title as title, a.aw...ha Hackett+%') ) order by year, title, ABS(level)"
 /usr/lib64/python2.7/site-packages/MySQLdb/connections.py in query(self=<_mysql.connection open to 'localhost'>, query="(select a.award_id, a.award_title as title, a.aw...ha Hackett+%') ) order by year, title, ABS(level)")
    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 'localhost'>, query = "(select a.award_id, a.award_title as title, a.aw...ha Hackett+%') ) order by year, title, ABS(level)"

<class 'MySQLdb._exceptions.ProgrammingError'>: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6")
      args = (1064, "You have an error in your SQL syntax; check the ...ion for the right syntax to use near '' at line 6")
      message = ''