Opened 16 years ago

Last modified 20 months ago

#3088 new defect

Error in MySQL Query Syntax — at Initial Version

Reported by: abidoon@… Owned by: dagomez
Priority: highest Component: StractisticsPlugin
Severity: blocker Keywords:
Cc: dagomez, mjrecena@… Trac Release: 0.11

Description

Trac detected an internal error:

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 ')\n GROUP BY r.author \n ORDER BY commits DESC \n LIMIT 5' at line 3")

Most recent call last:

  • File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py", line 417, in _dispatch_request Code fragment:
    1. try:
    2. if not env and env_error:
    3. raise HTTPInternalError(env_error)
    4. try:
    5. dispatcher = RequestDispatcher(env)
    6. dispatcher.dispatch(req)
    7. except RequestDone:
    8. pass
    9. resp = req._response or []
    11. except HTTPException, e:
    Local variables: Name Value after [u' except RequestDone:', u' pass', u' resp = ... before [u' try:', u' if not env and env_error:', u' raise ... dispatcher <trac.web.main.RequestDispatcher object at 0x2aaad0d9ab10> e <_mysql_exceptions.ProgrammingError instance at 0x2aaad0d82518> env <trac.env.Environment object at 0x2aaaccfc4ad0> env_error None exc_info (<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>, ... filename '/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py' frames [{'function': '_dispatch_request', 'lines_before': [u' try:', u' ... has_admin True line u' dispatcher.dispatch(req)' lineno 416 message u'ProgrammingError: (1064, "You have an error in your SQL syntax; check ... req <Request "GET u'/stractistics'"> resp [] tb <traceback object at 0x2aaad0d82c68> tb_hide None traceback 'Traceback (most recent call last):\n File ...
  • File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py", line 197, in dispatch Code fragment:
    1. req.args.get('FORM_TOKEN') != req.form_token:
    2. raise HTTPBadRequest('Missing or invalid form token. '
    3. 'Do you have cookies enabled?')
    5. # Process the request and render the template
    6. resp = chosen_handler.process_request(req)
    7. if resp:
    8. if len(resp) == 2: # Clearsilver
    9. chrome.populate_hdf(req)
    10. template, content_type = \
    11. self._post_process_request(req, *resp)
    Local variables: Name Value chosen_handler <stractistics.web_ui.StractisticsModule object at 0x2aaad0d80cd0> chrome <trac.web.chrome.Chrome object at 0x2aaad0d9a790> err (<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>, ... handler <stractistics.web_ui.StractisticsModule object at 0x2aaad0d80cd0> req <Request "GET u'/stractistics'"> self <trac.web.main.RequestDispatcher object at 0x2aaad0d9ab10>
  • File "build/bdist.linux-x86_64/egg/stractistics/web_ui.py", line 116, in process_request Local variables: Name Value config {'wiki_ignored_authors': [], 'repository_ignored_authors': [], ... db <trac.db.pool.PooledConnection object at 0x2aaad0d82440> elem ('User reports', 'user_reports') links [('Project reports', '/stractistics/project_reports'), ('User reports', ... module None req <Request "GET u'/stractistics'"> self <stractistics.web_ui.StractisticsModule object at 0x2aaad0d80cd0> strac_ref '/stractistics'
  • File "build/bdist.linux-x86_64/egg/stractistics/global_reports.py", line 31, in global_reports Local variables: Name Value config {'wiki_ignored_authors': [], 'repository_ignored_authors': [], ... db <trac.db.pool.PooledConnection object at 0x2aaad0d82440> end_date datetime.datetime(2008, 5, 28, 11, 9, 29, 652479) req <Request "GET u'/stractistics'"> start_date datetime.datetime(2008, 3, 5, 11, 9, 29, 652479) weeks_back 12
  • File "build/bdist.linux-x86_64/egg/stractistics/global_reports.py", line 64, in _repository_activity Local variables: Name Value AUTHORS_LIMIT 5 WEEKS_NUMBER 12 config {'wiki_ignored_authors': [], 'repository_ignored_authors': [], ... db <trac.db.pool.PooledConnection object at 0x2aaad0d82440> end_date datetime.datetime(2008, 5, 28, 11, 9, 29, 652479) ignored_authors req <Request "GET u'/stractistics'"> start_date datetime.datetime(2008, 3, 5, 11, 9, 29, 652479) weeks_back 12
  • File "build/bdist.linux-x86_64/egg/stractistics/global_reports.py", line 113, in _most_active_repository_authors Local variables: Name Value AUTHORS_LIMIT 5 authors [] db <trac.db.pool.PooledConnection object at 0x2aaad0d82440> end_date datetime.datetime(2008, 5, 28, 11, 9, 29, 652479) ignored_authors map_rows <function map_rows at 0x2aaad0d855f0> sql_expr '\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ... start_date datetime.datetime(2008, 3, 5, 11, 9, 29, 652479)
  • File "build/bdist.linux-x86_64/egg/stractistics/util.py", line 117, in execute_sql_expression Local variables: Name Value cursor <trac.db.util.IterableCursor object at 0x2aaad0d9e6a8> db <trac.db.pool.PooledConnection object at 0x2aaad0d82440> map_rows <function map_rows at 0x2aaad0d855f0> sql_expr '\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ...
  • File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py", line 51, in execute Code fragment:
    1. # -- In case of SQL errors, uncomment the following 'print' statements
    2. # print 'execute', repr(sql)
    3. if args:
    4. # print repr(args)
    5. return self.cursor.execute(sql_escape_percent(sql), args)
    6. return self.cursor.execute(sql)
    8. def executemany(self, sql, args=None):
    9. # print 'executemany', repr(sql)
    10. if args:
    11. # print repr(args)
    Local variables: Name Value args None self <trac.db.util.IterableCursor object at 0x2aaad0d9e6a8> sql '\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ...
  • File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py", line 51, in execute Code fragment:
    1. # -- In case of SQL errors, uncomment the following 'print' statements
    2. # print 'execute', repr(sql)
    3. if args:
    4. # print repr(args)
    5. return self.cursor.execute(sql_escape_percent(sql), args)
    6. return self.cursor.execute(sql)
    8. def executemany(self, sql, args=None):
    9. # print 'executemany', repr(sql)
    10. if args:
    11. # print repr(args)
    Local variables: Name Value args None self <trac.db.util.IterableCursor object at 0x2aaad0d9ea28> sql '\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ...
  • File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute Code fragment:
    1. self.errorhandler(self, TypeError, m)
    2. except:
    3. exc, value, tb = exc_info()
    4. del tb
    5. self.messages.append((exc, value))
    6. self.errorhandler(self, exc, value)
    7. self._executed = query
    8. self._warning_check()
    9. return r
    11. def executemany(self, query, args):
    Local variables: Name Value ListType <type 'list'> TupleType <type 'tuple'> args None charset 'utf8' db <weakproxy at 0x2aaace3f8d08 to Connection at 0x2aaabcc7dfe0> exc <class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0> exc_info <built-in function exc_info> query '\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ... self <MySQLdb.cursors.Cursor object at 0x2aaad0d9b190> value <_mysql_exceptions.ProgrammingError instance at 0x2aaad0d82518>
  • File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler Code fragment:
    1. cursor.messages.append(error)
    2. else:
    3. connection.messages.append(error)
    4. del cursor
    5. del connection
    6. raise errorclass, errorvalue
    9. class Connection(_mysql.connection):
    11. """MySQL Database Connection Object"""
    Local variables: Name Value error (<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>, ... errorclass <class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0> errorvalue <_mysql_exceptions.ProgrammingError instance at 0x2aaad0d82518>

File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py", line 417, in _dispatch_request

dispatcher.dispatch(req)

File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py", line 197, in dispatch

resp = chosen_handler.process_request(req)

File "build/bdist.linux-x86_64/egg/stractistics/web_ui.py", line 116, in process_requestFile "build/bdist.linux-x86_64/egg/stractistics/global_reports.py", line 31, in global_reportsFile "build/bdist.linux-x86_64/egg/stractistics/global_reports.py", line 64, in _repository_activityFile "build/bdist.linux-x86_64/egg/stractistics/global_reports.py", line 113, in _most_active_repository_authorsFile "build/bdist.linux-x86_64/egg/stractistics/util.py", line 117, in execute_sql_expressionFile "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py", line 51, in execute

return self.cursor.execute(sql)

File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py", line 51, in execute

return self.cursor.execute(sql)

File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute

self.errorhandler(self, exc, value)

File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler

raise errorclass, errorvalue

System Information:

User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14 Trac: 0.11rc1 Python: 2.4.3 (#1, Mar 14 2007, 19:01:42) [GCC 4.1.1 20070105 (Red Hat 4.1.1-52)] setuptools: 0.6c8 MySQL: server: "5.1.22-rc-log", client: "5.0.22", thread-safe: 0 MySQLdb: 1.2.1 Genshi: 0.5dev-r852 mod_python: 3.2.8 Subversion: 1.4.2 (r22196) jQuery: 1.2.3

Change History (0)

Note: See TracTickets for help on using tickets.