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