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: David Rain

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

  • Author: David Rain Author Record # 245479
  • Birthplace: Mount Gambier, South Australia, Australia
  • Language: English
  • Webpages: davidrain.net
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 03:21:15 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 0xb6e1dfac>, bib.displayBiblio = <bound method Bibliography.displayBiblio of <biblio.Bibliography instance at 0xb6e1dfac>>
 /var/www/cgi-bin/biblio.py in displayBiblio(self=<biblio.Bibliography instance at 0xb6e1dfac>)
  231 
  232                 if self.page_type == 'Award':
  233                         self.loadAuthorAwards()
  234                         self.printAwards()
  235                 print '</div>'
self = <biblio.Bibliography instance at 0xb6e1dfac>, self.loadAuthorAwards = <bound method Bibliography.loadAuthorAwards of <biblio.Bibliography instance at 0xb6e1dfac>>
 /var/www/cgi-bin/biblio.py in loadAuthorAwards(self=<biblio.Bibliography instance at 0xb6e1dfac>)
  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 0xb6e1dfac>, self.au_awards = [], global SQLloadAwardsXBA = <function SQLloadAwardsXBA at 0xb6f19dbc>, self.author_name = 'David Rain', self.canonical_titles = [], pseudonyms = []
 /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='David Rain', 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 0xb73cc02c>, query = "(select a.award_id, a.award_title as title, a.aw...David Rain+%') ) 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...David Rain+%') ) 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 98a8b44>, db.query = <built-in method query of Connection object at 0x98a8b44>, query = "(select a.award_id, a.award_title as title, a.aw...David Rain+%') ) 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")