Hello,
First..I love the Galaxy Reports tool...thanks
so much for this.
I did however come across an error when
trying to few the Registered Users per month link. It would be really nice
to have this working :)
Thanks in advance,
Liisa
URL: http://domain:9001/users/registered_users_per_month
Module paste.exceptions.errormiddleware:144 in __call__
>>
app_iter
= self.application(environ,
sr_checker)
Module paste.debug.prints:106 in __call__
>>
environ,
self.app)
Module paste.wsgilib:543 in intercept_output
>>
app_iter
= application(environ,
replacement_start_response)
Module paste.lint:170 in lint_app
>>
iterator
= application(environ,
start_response_wrapper)
Module paste.recursive:84 in __call__
>>
return
self.application(environ,
start_response)
Module paste.httpexceptions:633 in __call__
>>
return
self.application(environ,
start_response)
Module galaxy.web.framework.base:132 in __call__
>>
return
self.handle_request(
environ,
start_response
)
Module galaxy.web.framework.base:190 in handle_request
>>
body
= method(
trans,
**kwargs
)
Module galaxy.webapps.reports.controllers.users:29 in registered_users_per_month
>>
for
row
in
q.execute():
Module sqlalchemy.sql.expression:2841 in execute
Module sqlalchemy.engine.base:2453 in _execute_clauseelement
Module sqlalchemy.engine.base:1584 in _execute_clauseelement
Module sqlalchemy.engine.base:1698 in _execute_context
Module sqlalchemy.engine.base:1691 in _execute_context
Module sqlalchemy.engine.default:331 in do_execute
Module MySQLdb.cursors:173 in execute
Module MySQLdb.connections:36 in defaulterrorhandler
OperationalError: (OperationalError) (1305, 'FUNCTION galaxy_production.date_trunc
does not exist') 'SELECT date_trunc(%s, date(galaxy_user.create_time))
AS date, count(galaxy_user.id) AS num_users \nFROM galaxy_user GROUP BY
date_trunc(%s, date(galaxy_user.create_time)) ORDER BY date DESC' ('month',
'month')