ISFDB banner

Award Bibliography: Victor Appleton

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

Alternate Name. See: Harriet Stratemeyer Adams, Neal Barrett, Jr., Greg Cox, Sharman DiVono, Debra Doyle, John W. Duffield, Howard R. Garis, Steven Grant, James D. Macdonald, F. Gwynplaine MacIntyre, Bill McCay, Bridget McKenna, Mike McQuay, Thomas Moyston Mitchell, Bruce Holland Rogers, William Rotsler, Michael Anthony Steele, unknown, Robert E. Vardeman (or view all titles published using this alternate name) --> -->
 
 
<class 'MySQLdb._exceptions.ProgrammingError'>
Python 2.7.18: /usr/bin/python
Thu Apr 18 12:54:20 2024

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 <module>()
     19 if __name__ == '__main__':
     20 
     21         bib = Bibliography()
     22         bib.page_type = 'Award'
=>   23         bib.displayBiblio()
bib = <biblio.Bibliography instance>, bib.displayBiblio = <bound method Bibliography.displayBiblio of <biblio.Bibliography instance>>
 /var/www/cgi-bin/biblio.py in displayBiblio(self=<biblio.Bibliography instance>)
    231 
    232                 if self.page_type == 'Award':
=>  233                         self.loadAuthorAwards()
    234                         self.printAwards()
    235                 print '</div>'
self = <biblio.Bibliography instance>, self.loadAuthorAwards = <bound method Bibliography.loadAuthorAwards of <biblio.Bibliography instance>>
 /var/www/cgi-bin/biblio.py in loadAuthorAwards(self=<biblio.Bibliography instance>)
    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>, self.au_awards = [], global SQLloadAwardsXBA = <function SQLloadAwardsXBA>, self.author_name = 'Victor Appleton', self.canonical_titles = [], pseudonyms = []
 /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='Victor Appleton', titles=[], pseudonyms=[])
    460                               and ta.title_id = t.title_id)""" % in_clause
    461         query += " order by year, title, ABS(level)"
=>  462         return _StandardQuery(query)
    463 
    464 def SQLloadAwardsForYearType(award_type_id, year):
global _StandardQuery = <function _StandardQuery>, query = "(select a.award_id, a.award_title as title, a.aw...r Appleton+%') ) 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...r Appleton+%') ) 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'>, db.query = <bound method Connection.query of <_mysql.connection open to 'localhost'>>, query = "(select a.award_id, a.award_title as title, a.aw...r Appleton+%') ) order by year, title, ABS(level)"
 /usr/lib64/python2.7/site-packages/MySQLdb/connections.py in query(self=<_mysql.connection open to 'localhost'>, query="(select a.award_id, a.award_title as title, a.aw...r Appleton+%') ) order by year, title, ABS(level)")
    237         if isinstance(query, bytearray):
    238             query = bytes(query)
=>  239         _mysql.connection.query(self, query)
    240 
    241     def _bytes_literal(self, bs):
global _mysql = <module 'MySQLdb._mysql' from '/usr/lib64/python2.7/site-packages/MySQLdb/_mysql.so'>, _mysql.connection = <type '_mysql.connection'>, _mysql.connection.query = <method 'query' of '_mysql.connection' objects>, self = <_mysql.connection open to 'localhost'>, query = "(select a.award_id, a.award_title as title, a.aw...r Appleton+%') ) order by year, title, ABS(level)"

<class 'MySQLdb._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")
      args = (1064, "You have an error in your SQL syntax; check the ...ion for the right syntax to use near '' at line 6")
      message = ''