Not Compatible with Custom Ticket Workflow?

[Mr Papa]

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'")

[Mr Papa]

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

[anonymous]

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 

[Peter]

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

[Ryan J Ollos]

Reassigning ticket to new maintainer.

[Ryan J Ollos]

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