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: Rob Bowman

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

  • Author: Rob Bowman Author Record # 238359
Showing all translations. Never display translations Registered users can choose which translations are shown.

--> -->
 
 
<class '_mysql_exceptions.ProgrammingError'>
Python 2.5: /usr/bin/python
Sun Sep 4 13:16:09 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 0xb6dd0f8c>, bib.displayBiblio = <bound method Bibliography.displayBiblio of <biblio.Bibliography instance at 0xb6dd0f8c>>
 /var/www/cgi-bin/biblio.py in displayBiblio(self=<biblio.Bibliography instance at 0xb6dd0f8c>)
  231 
  232                 if self.page_type == 'Award':
  233                         self.loadAuthorAwards()
  234                         self.printAwards()
  235                 print '</div>'
self = <biblio.Bibliography instance at 0xb6dd0f8c>, self.loadAuthorAwards = <bound method Bibliography.loadAuthorAwards of <biblio.Bibliography instance at 0xb6dd0f8c>>
 /var/www/cgi-bin/biblio.py in loadAuthorAwards(self=<biblio.Bibliography instance at 0xb6dd0f8c>)
  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 0xb6dd0f8c>, self.au_awards = [], global SQLloadAwardsXBA = <function SQLloadAwardsXBA at 0xb6eccd84>, self.author_name = 'Rob Bowman', self.canonical_titles = [], pseudonyms = []
 /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='Rob Bowman', 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 0xb737fd84>, query = "(select a.award_id, a.award_title as title, a.aw...Rob Bowman+%') ) 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...Rob Bowman+%') ) 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 84eddbc>, db.query = <built-in method query of Connection object at 0x84eddbc>, query = "(select a.award_id, a.award_title as title, a.aw...Rob Bowman+%') ) 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")