--> -->
<class 'MySQLdb._exceptions.ProgrammingError'> | Python 2.7.18: /usr/bin/python
Sun Sep 11 01:54:21 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 <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 = 'Jeffrey Combs', self.canonical_titles = [], pseudonyms = [] |
| /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='Jeffrey Combs', titles=[], pseudonyms=[]) |
440 and ta.title_id = t.title_id)""" % in_clause
|
441 query += " order by year, title, ABS(level)"
|
=> 442 return _StandardQuery(query)
|
443
|
444 def SQLloadAwardsForYearType(award_type_id, year):
|
| global _StandardQuery = <function _StandardQuery>, query = "(select a.award_id, a.award_title as title, a.aw...frey Combs+%') ) 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...frey Combs+%') ) 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...frey Combs+%') ) 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...frey Combs+%') ) 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...frey Combs+%') ) 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 =
''
