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: Melody Cooper

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

  • Author: Melody Cooper Author Record # 285508
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
Sun Sep 4 15:54:25 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 0xb6e3ef8c>, bib.displayBiblio = <bound method Bibliography.displayBiblio of <biblio.Bibliography instance at 0xb6e3ef8c>>
 /var/www/cgi-bin/biblio.py in displayBiblio(self=<biblio.Bibliography instance at 0xb6e3ef8c>)
  231 
  232                 if self.page_type == 'Award':
  233                         self.loadAuthorAwards()
  234                         self.printAwards()
  235                 print '</div>'
self = <biblio.Bibliography instance at 0xb6e3ef8c>, self.loadAuthorAwards = <bound method Bibliography.loadAuthorAwards of <biblio.Bibliography instance at 0xb6e3ef8c>>
 /var/www/cgi-bin/biblio.py in loadAuthorAwards(self=<biblio.Bibliography instance at 0xb6e3ef8c>)
  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 0xb6e3ef8c>, self.au_awards = [], global SQLloadAwardsXBA = <function SQLloadAwardsXBA at 0xb6f3ad84>, self.author_name = 'Melody Cooper', self.canonical_titles = [], pseudonyms = []
 /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='Melody Cooper', 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 0xb73edd84>, query = "(select a.award_id, a.award_title as title, a.aw...ody Cooper+%') ) 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...ody Cooper+%') ) 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 8eccdbc>, db.query = <built-in method query of Connection object at 0x8eccdbc>, query = "(select a.award_id, a.award_title as title, a.aw...ody Cooper+%') ) 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")