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: Ranea Dick

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

  • Author: Ranea Dick Author Record # 181882
Showing all translations. Never display translations Registered users can choose which translations are shown.

--> -->
 
 
<class '_mysql_exceptions.ProgrammingError'>
Python 2.5: /usr/bin/python
Tue Sep 6 03:27:14 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 0xb6d48f8c>, bib.displayBiblio = <bound method Bibliography.displayBiblio of <biblio.Bibliography instance at 0xb6d48f8c>>
 /var/www/cgi-bin/biblio.py in displayBiblio(self=<biblio.Bibliography instance at 0xb6d48f8c>)
  231 
  232                 if self.page_type == 'Award':
  233                         self.loadAuthorAwards()
  234                         self.printAwards()
  235                 print '</div>'
self = <biblio.Bibliography instance at 0xb6d48f8c>, self.loadAuthorAwards = <bound method Bibliography.loadAuthorAwards of <biblio.Bibliography instance at 0xb6d48f8c>>
 /var/www/cgi-bin/biblio.py in loadAuthorAwards(self=<biblio.Bibliography instance at 0xb6d48f8c>)
  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 0xb6d48f8c>, self.au_awards = [], global SQLloadAwardsXBA = <function SQLloadAwardsXBA at 0xb6e44d84>, self.author_name = 'Ranea Dick', self.canonical_titles = [], pseudonyms = []
 /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='Ranea Dick', 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 0xb72f7d84>, query = "(select a.award_id, a.award_title as title, a.aw...Ranea Dick+%') ) 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...Ranea Dick+%') ) 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 9c21dbc>, db.query = <built-in method query of Connection object at 0x9c21dbc>, query = "(select a.award_id, a.award_title as title, a.aw...Ranea Dick+%') ) 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")