id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 8573,no access to 'estimatedhours' when executing macro,Jan Boehme,Chris Nelson,"Here the macro which is called in the main wiki page: "" [ [ TracJSGanttChart(milestone=K10-BOSCH-03) ] ]"" Results in the following error message in trac.log: 2011-03-07 14:32:50,793 Trac[formatter] DEBUG: Executing Wiki macro TracJSGanttChart by provider 2011-03-07 14:32:50,793 Trac[formatter] DEBUG: Executing Wiki macro TracJSGanttChart by provider 2011-03-07 14:32:50,800 Trac[query] DEBUG: Count results in Query: 8 2011-03-07 14:32:50,800 Trac[query] DEBUG: Query SQL: SELECT t.id AS id,t.description AS description,t.owner AS owner,t.type AS type,t.status AS status,t.summary AS summary,t.milestone AS milestone,t.priority AS priority,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,`blockedby`.value AS `blockedby`,`blocking`.value AS `blocking`,`estimatedhours`.value AS `estimatedhours`,`totalhours`.value AS `totalhours` FROM ticket AS t LEFT OUTER JOIN ticket_custom AS `blockedby` ON (id=`blockedby`.ticket AND `blockedby`.name='blockedby') LEFT OUTER JOIN ticket_custom AS `blocking` ON (id=`blocking`.ticket AND `blocking`.name='blocking') LEFT OUTER JOIN ticket_custom AS `estimatedhours` ON (id=`estimatedhours`.ticket AND `estimatedhours`.name='estimatedhours') LEFT OUTER JOIN ticket_custom AS `totalhours` ON (id=`totalhours`.ticket AND `totalhours`.name='totalhours') LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority) WHERE ((COALESCE(t.milestone,'')=u'K10-BOSCH-03')) ORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS integer),t.id 2011-03-07 14:32:50,808 Trac[formatter] ERROR: Macro TracJSGanttChart(milestone=K10-BOSCH-03) failed: Traceback (most recent call last): File ""/usr/lib/python2.7/site-packages/trac/wiki/formatter.py"", line 717, in _macro_formatter return macro.process(args, in_paragraph=True) File ""/usr/lib/python2.7/site-packages/trac/wiki/formatter.py"", line 304, in process text = self.processor(text) File ""/usr/lib/python2.7/site-packages/trac/wiki/formatter.py"", line 291, in _macro_processor text) File ""/usr/lib/python2.7/site-packages/Trac_jsGantt-0.3-py2.7.egg/tracjsgantt/tracjsgantt.py"", line 620, in expand_macro tasks = self._add_tasks(options) File ""/usr/lib/python2.7/site-packages/Trac_jsGantt-0.3-py2.7.egg/tracjsgantt/tracjsgantt.py"", line 598, in _add_tasks tasks += self._format_ticket(ticket, options) File ""/usr/lib/python2.7/site-packages/Trac_jsGantt-0.3-py2.7.egg/tracjsgantt/tracjsgantt.py"", line 532, in _format_ticket task += '""%s"",' % _start(t) File ""/usr/lib/python2.7/site-packages/Trac_jsGantt-0.3-py2.7.egg/tracjsgantt/tracjsgantt.py"", line 491, in _start days = _workDays(t) File ""/usr/lib/python2.7/site-packages/Trac_jsGantt-0.3-py2.7.egg/tracjsgantt/tracjsgantt.py"", line 457, in _workDays if self.fields['estimate'] and t[self.fields['estimate']] != '': KeyError: u'estimatedhours' Maybe something wasn't upgraded well oor there is no 'estimatedhours' in the current table. The belonging values can be found in 'ticket_custom' table. Can anyone help here? Thanks, Jan.",defect,closed,highest,TracJsGanttPlugin,normal,worksforme,,,0.12