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 <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month> Module paste.exceptions.errormiddleware:*144* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month#>a... self*.*application*(*environ*,* sr_checker*)* Module paste.debug.prints:*106* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month#>e... self*.*app*)* Module paste.wsgilib:*543* in intercept_output_ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month#>a... application*(*environ*,* replacement_start_response*)* Module paste.lint:*170* in lint_app_ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month#>i... application*(*environ*,* start_response_wrapper*)* Module paste.recursive:*84* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month#>*... start_response*)* Module paste.httpexceptions:*633* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month#>*... start_response*)* Module galaxy.web.framework.base:*132* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month#>*... environ*,* start_response*)* Module galaxy.web.framework.base:*190* in handle_request_ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month#>b... method*(* trans*,* ****kwargs*)* Module galaxy.webapps.reports.controllers.users:*29* in registered_users_per_month_ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month#>*... 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')* ___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/ To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Well! This is the first I've heard of a Galaxy Reports page. Too bad I already re-invented the wheel because I hadn't ever heard of this tool... Anyway, since "run_reports.sh" was only mentioned once anywhere in the wiki (according to search, in a DevNewsBrief from 2008), I've added a wiki page for the report tool. Please add whatever information you all feel I've left out. https://wiki.galaxyproject.org/Admin/Usage%20Reports Cheers, Eric Rasche On 01/17/2014 10:38 AM, Liisa Koski wrote: > 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 > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month> > Module paste.exceptions.errormiddleware:*144* in __call___ > __>> _ > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# >app_iter*=* > self*.*application*(*environ*,* sr_checker*)* > Module paste.debug.prints:*106* in __call___ > __>> _ > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# >environ*,* > self*.*app*)* > Module paste.wsgilib:*543* in intercept_output_ > __>> _ > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# >app_iter*=* > application*(*environ*,* replacement_start_response*)* > Module paste.lint:*170* in lint_app_ > __>> _ > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# >iterator*=* > application*(*environ*,* start_response_wrapper*)* > Module paste.recursive:*84* in __call___ > __>> _ > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# >*return*self*.*application*(*environ*,* > start_response*)* > Module paste.httpexceptions:*633* in __call___ > __>> _ > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# >*return*self*.*application*(*environ*,* > start_response*)* > Module galaxy.web.framework.base:*132* in __call___ > __>> _ > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# >*return*self*.*handle_request*(* > environ*,* start_response*)* > Module galaxy.web.framework.base:*190* in handle_request_ > __>> _ > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# >body*=* > method*(* trans*,* ****kwargs*)* > Module galaxy.webapps.reports.controllers.users:*29* in > registered_users_per_month_ > __>> _ > <http://martin.dnalandmarks.ca:9001/users/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')* > > > > ___________________________________________________________ > Please keep all replies on the list by using "reply all" > in your mail client. To manage your subscriptions to this > and other Galaxy lists, please use the interface at: > http://lists.bx.psu.edu/ > > To search Galaxy mailing lists use the unified search at: > http://galaxyproject.org/search/mailinglists/ > ___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/ To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/