Hi Rjollos 1. Not raise an SQL exception, but does not render the graph.
2. The remaining errors continue. 3. Others: TicketChart(type = stacked_ > bars, key = owner, x_axis = status, query = milestone="MZOP1", title = > Tickets b > y status and owner for milestone1) > stacked_bar_max_y_value > for x_axis_stats in ticket_stats.itervalues()]) > ValueError: max() arg is an empty sequence File "/var/trac/projects/claudino/plugins/TicketCharts.py", line 232, in > _get_ > 2013/5/9 RjOllos <[email protected]> > 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<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. > > > -- 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.
