- Author: Jiang Bo Author Record # 270755
- Language: Chinese
- Used As Alternate Name By:
江波?Jiang Bo
Alternate Name. See:
江波?Jiang Bo
(or view all titles published using this alternate name)
--> -->
| <class 'MySQLdb._exceptions.ProgrammingError'> | Python 2.7.18: /usr/bin/python Wed Sep 11 13:31:56 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 = 'Jiang Bo', self.canonical_titles = [], pseudonyms = [] |
| /var/www/cgi-bin/SQLparsing.py in SQLloadAwardsXBA(author='Jiang Bo', 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...%+Jiang Bo+%') ) 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...%+Jiang Bo+%') ) 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...%+Jiang Bo+%') ) 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...%+Jiang Bo+%') ) 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...%+Jiang Bo+%') ) 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 =
''