ISFDB banner

The ISFDB is moving servers the week of 9/4.

Editing will be disabled on 9/6 until the database is migrated, and you may see either the old server or the new server while the domain name change propagates across the Internet.

You are currently on the OLD SERVER.

Award Bibliography: Barry Hill

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

  • Author: Barry Hill Author Record # 323429
Showing all translations. Never display translations Registered users can choose which translations are shown.
Other views: Summary Alphabetical Chronological

--> -->
 
 
<class '_mysql_exceptions.ProgrammingError'>		Python 2.5: /usr/bin/python
Tue Sep 6 00:46:26 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 ()
   19 if __name__ == '__main__':
   20 
   21         bib = Bibliography()
   22         bib.page_type = 'Award'
   23         bib.displayBiblio()
bib = <biblio.Bibliography instance at 0xb6d6ff8c>, bib.displayBiblio = <bound method Bibliography.displayBiblio of <biblio.Bibliography instance at 0xb6d6ff8c>>
 /var/www/cgi-bin/biblio.py in displayBiblio(self=<biblio.Bibliography instance at 0xb6d6ff8c>)
  231 
  232                 if self.page_type == 'Award':
  233                         self.loadAuthorAwards()
  234                         self.printAwards()
  235                 print '</div>'
self = <biblio.Bibliography instance at 0xb6d6ff8c>, self.loadAuthorAwards = <bound method Bibliography.loadAuthorAwards of <biblio.Bibliography instance at 0xb6d6ff8c>>
 /var/www/cgi-bin/biblio.py in loadAuthorAwards(self=<biblio.Bibliography instance at 0xb6d6ff8c>)
  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 at 0xb6d6ff8c>, self.au_awards = [], global SQLloadAwardsXBA = <function SQLloadAwardsXBA at 0xb6e6bd84>, self.author_name = 'Barry Hill', self.canonical_titles = [], pseudonyms = []
 /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='Barry Hill', titles=[], pseudonyms=[])
  444                               and ta.title_id = t.title_id)""" % in_clause
  445         query += " order by year, title, ABS(level)"
  446         return _StandardQuery(query)
  447 
  448 def SQLloadAwardsForYearType(award_type_id, year):
global _StandardQuery = <function _StandardQuery at 0xb731ed84>, query = "(select a.award_id, a.award_title as title, a.aw...Barry Hill+%') ) 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...Barry Hill+%') ) 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' at 977cdbc>, db.query = <built-in method query of Connection object at 0x977cdbc>, query = "(select a.award_id, a.award_title as title, a.aw...Barry Hill+%') ) order by year, title, ABS(level)"

<class '_mysql_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")