--> -->
<class '_mysql_exceptions.ProgrammingError'> | Python 2.5: /usr/bin/python
Sun Sep 4 15:30:40 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 0xb6dd8fac>, bib.displayBiblio = <bound method Bibliography.displayBiblio of <biblio.Bibliography instance at 0xb6dd8fac>> |
| /var/www/cgi-bin/biblio.py in displayBiblio(self=<biblio.Bibliography instance at 0xb6dd8fac>) |
231
|
232 if self.page_type == 'Award':
|
233 self.loadAuthorAwards()
|
234 self.printAwards()
|
235 print '</div>'
|
| self = <biblio.Bibliography instance at 0xb6dd8fac>, self.loadAuthorAwards = <bound method Bibliography.loadAuthorAwards of <biblio.Bibliography instance at 0xb6dd8fac>> |
| /var/www/cgi-bin/biblio.py in loadAuthorAwards(self=<biblio.Bibliography instance at 0xb6dd8fac>) |
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 0xb6dd8fac>, self.au_awards = [], global SQLloadAwardsXBA = <function SQLloadAwardsXBA at 0xb6ed4dbc>, self.author_name = 'Larry Kirshbaum', self.canonical_titles = [], pseudonyms = [] |
| /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='Larry Kirshbaum', 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 0xb738702c>, query = "(select a.award_id, a.award_title as title, a.aw... Kirshbaum+%') ) 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... Kirshbaum+%') ) 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 8b00b44>, db.query = <built-in method query of Connection object at 0x8b00b44>, query = "(select a.award_id, a.award_title as title, a.aw... Kirshbaum+%') ) 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")
