Modify

Opened 6 years ago

Closed 11 months ago

#3421 closed defect (duplicate)

Not Compatible with Custom Ticket Workflow?

Reported by: Mr Papa Owned by: rjollos
Priority: high Component: TracTicketStatsPlugin
Severity: major Keywords:
Cc: zelts@… Trac Release: 0.11

Description

This doesnt seem compatible with the custom ticket workflow that can be generated in 0.11 or am I missing something?

I dont have any of the ordinary status states and I get the following error trying to run

Trac detected an internal error:

OperationalError: (1054, "Unknown column 'created' in 'where clause'")

Attachments (0)

Change History (5)

comment:1 Changed 6 years ago by Mr Papa

seems more like might be python 2.4 issue (yes, I read the part about only tested with 2.5)...

comment:2 Changed 5 years ago by anonymous

  • Priority changed from normal to high
  • Severity changed from normal to major

i have the same issue:
FreeBSD
Trac 11.2.1

error that i get is:

Trac detected an internal error: OperationalError: (1054, "Unknown column 'created' in 'where clause'")


Python Traceback
Most recent call last: 
File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/web/main.py", line 432, in _dispatch_request 
Code fragment:
    try:        if not env and env_error:            raise HTTPInternalError(env_error)        try:            dispatcher = RequestDispatcher(env)
                                      dispatcher.dispatch(req)
                                  except RequestDone:            pass        resp = req._response or []     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 0x2a9ddd8c> 
e OperationalError(1054, "Unknown column 'created' in 'where clause'") 
env <trac.env.Environment object at 0x2a83ccac> 
env_error None 
exc_info (<class '_mysql_exceptions.OperationalError'>, OperationalError(1054, ... 
filename '/usr/local/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/web/ma ... 
frames [{'function': '_dispatch_request', 'lines_before': [u'    try:', u'        ... 
has_admin True 
line u'            dispatcher.dispatch(req)' 
lineno 431 
message u'OperationalError: (1054, "Unknown column \'created\' in \'where ... 
req <Request "GET u'/ticketstats'"> 
resp [] 
tb <traceback object at 0x2a8d725c> 
tb_hide None 
traceback 'Traceback (most recent call last):\n  File ... 

File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/web/main.py", line 204, in dispatch 
Code fragment:
                            req.args.get('__FORM_TOKEN') != req.form_token:                        raise HTTPBadRequest('Missing or invalid form token. '                                             'Do you have cookies enabled?')                 # Process the request and render the template
                                          resp = chosen_handler.process_request(req)
                                          if resp:                    if len(resp) == 2: # Clearsilver                        chrome.populate_hdf(req)                        template, content_type = \                                  self._post_process_request(req, *resp)
                        Local variables:
Name Value 
chosen_handler <ticketstats.ticketstats.TicketStatsPlugin object at 0x2a85e2ec> 
chrome <trac.web.chrome.Chrome object at 0x2a873ccc> 
err (<class '_mysql_exceptions.OperationalError'>, OperationalError(1054, ... 
handler <ticketstats.ticketstats.TicketStatsPlugin object at 0x2a85e2ec> 
req <Request "GET u'/ticketstats'"> 
self <trac.web.main.RequestDispatcher object at 0x2a9ddd8c> 

File "/usr/local/www/trac/plugins/Tracticketsats-1.0-py2.5.egg/ticketstats/ticketstats.py", line 170, in process_request 
Local variables:
Name Value 
at_date datetime.datetime(2008, 11, 21, 11, 59, 59, tzinfo=<FixedOffset "UTC" ... 
at_date_str '11/21/2008' 
count [] 
from_date datetime.datetime(2008, 5, 25, 0, 0, tzinfo=<FixedOffset "UTC" 0:00:00>) 
from_date_str '05/25/2008' 
graph_res 30 
last_date datetime.datetime(2008, 4, 25, 0, 0, tzinfo=<FixedOffset "UTC" 0:00:00>) 
req <Request "GET u'/ticketstats'"> 
self <ticketstats.ticketstats.TicketStatsPlugin object at 0x2a85e2ec> 
todays_date datetime.date(2008, 11, 21) 

File "/usr/local/www/trac/plugins/Tracticketsats-1.0-py2.5.egg/ticketstats/ticketstats.py", line 91, in _get_num_open_tix 
Local variables:
Name Value 
at_date datetime.datetime(2008, 4, 25, 0, 0, tzinfo=<FixedOffset "UTC" 0:00:00>) 
count 0 
cursor <trac.db.util.IterableCursor object at 0x2a67e344> 
db <trac.db.pool.PooledConnection object at 0x2a717d8c> 
req <Request "GET u'/ticketstats'"> 
self <ticketstats.ticketstats.TicketStatsPlugin object at 0x2a85e2ec> 
status_map {'assigned': 0, 'new': 0, 'reopened': 1, 'edit': 0, 'closed': -1} 

File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/db/util.py", line 51, in execute 
Code fragment:
        # -- In case of SQL errors, uncomment the following 'print' statements        # print 'execute', repr(sql)        if args:            # print repr(args)            return self.cursor.execute(sql_escape_percent(sql), args)
                     return self.cursor.execute(sql)
                               def executemany(self, sql, args=None):        # print 'executemany', repr(sql)        if args:            # print repr(args)
                        Local variables:
Name Value 
args None 
self <trac.db.util.IterableCursor object at 0x2a67e344> 
sql "SELECT t.type AS type, owner, status, time AS created FROM ticket t, enum ... 

File "/usr/local/lib/python2.5/site-packages/MySQL_python-1.2.2-py2.5-freebsd-7.0-RELEASE-i386.egg/MySQLdb/cursors.py", line 166, in execute 
Local variables:
Name Value 
ListType <type 'list'> 
TupleType <type 'tuple'> 
args None 
charset 'utf8' 
db <weakproxy at 0x2a25eacc to Connection at 0x2a88980c> 
exc <class '_mysql_exceptions.OperationalError'> 
exc_info <built-in function exc_info> 
query "SELECT t.type AS type, owner, status, time AS created FROM ticket t, enum ... 
self <trac.db.mysql_backend.MySQLUnicodeCursor object at 0x2a857f8c> 
value OperationalError(1054, "Unknown column 'created' in 'where clause'") 

File "/usr/local/lib/python2.5/site-packages/MySQL_python-1.2.2-py2.5-freebsd-7.0-RELEASE-i386.egg/MySQLdb/connections.py", line 35, in defaulterrorhandler 

comment:3 Changed 5 years ago by goldman

  • Cc zelts@… added

This seems more like a Postgres issue. In ticketstats.py line 114:

select time as created from ticket where created <= %s

Should be:

select time as created from ticket where time <= %s

comment:4 Changed 3 years ago by rjollos

  • Owner changed from echo0101 to rjollos

Reassigning ticket to new maintainer.

comment:5 Changed 11 months ago by rjollos

  • Resolution set to duplicate
  • Status changed from new to closed

I'm assuming this has been fixed by now, but if not, it will be fixed in #8703 or #7001.

Add Comment

Modify Ticket

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from rjollos. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.