On Wednesday, May 8, 2013 5:10:23 PM UTC-7, ynoslenav wrote: > Hello, > > My Trac1.0 / Ubuntu / Postgres. > > I'm trying to use the plugin [1]TracChartMacro. > > [1] http://trac-hacks.org/wiki/TicketChartsMacro > > Found 02 errors: > > 2013-05-08 20:48:25,537 Trac[formatter] ERROR: Macro TicketChart(type = >> stacked_bars, key = owner, x_axis = status, height = 400, width = 600) >> failed: >> Traceback (most recent call last): >> File >> "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/wiki/formatter.py", >> >> line 765, in _macro_formatter >> return macro.ensure_inline(macro.process(args)) >> File >> "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/wiki/formatter.py", >> >> line 356, in process >> text = self.processor(text) >> File >> "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/wiki/formatter.py", >> >> line 343, in _macro_processor >> text) >> File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 460, >> in expand_macro >> return create_graph(formatter.req, formatter.env, args) >> File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 404, >> in create_graph >> chart, chart_div_id, additional_html = >> chart_creation[args['type']](env, db, args) >> File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 308, >> in stacked_bars_graph >> title = args.get('title')) >> File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 279, >> in _stacked_bars_graph >> key_colours[key_value] = COLOURS[i] >> IndexError: list index out of range >> > > 2013-05-08 21:02:06,537 Trac[formatter] ERROR: Macro TicketChart(type = >> pie, factor = status, query = milestone="milestone4") failed: >> Traceback (most recent call last): >> File >> "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/wiki/formatter.py", >> >> line 765, in _macro_formatter >> return macro.ensure_inline(macro.process(args)) >> File >> "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/wiki/formatter.py", >> >> line 356, in process >> text = self.processor(text) >> File >> "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/wiki/formatter.py", >> >> line 343, in _macro_processor >> text) >> File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 460, >> in expand_macro >> return create_graph(formatter.req, formatter.env, args) >> File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 404, >> in create_graph >> chart, chart_div_id, additional_html = >> chart_creation[args['type']](env, db, args) >> File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 391, >> in pie_graph >> return _pie_graph(env, db, args['factor'], query = args.get('query'), >> title = args.get('title')) >> File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 366, >> in _pie_graph >> ticket_stats = _get_pie_graph_stats(env, db, factor, query) >> File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 328, >> in _get_pie_graph_stats >> cursor.execute(sql) >> File >> "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/db/util.py", >> line 66, in execute >> return self.cursor.execute(sql) >> ProgrammingError: column "milestone4" does not exist >> LINE 4: WHERE ((COALESCE(t.milestone,'')="milestone4")) >> ^ >> ProgrammingError: column "milestone4" does not exist >> > > > Thank You.
Hi ynoslenav, The plugin was performing string interpolation to prepare the SQL strings, which often causes cross-db compatibility issues. I tried quickly to fix that just now. Please try again with the latest source code. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/trac-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
