Galaxy Reports link - registed users per month - does not work
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')
Hi Liisa This rings a bell.... I assume you use a MYSQL database? and I guess other pages are broken as well? We are also using MySQL and I had to fix several lines in several files in order to get all report pages to work. To do the fixes, have a look at this old (but still valid) e-mail from Assaf Gordon: http://lists.bx.psu.edu/pipermail/galaxy-dev/2009-August/000641.html I can send you all my fixed files next week Regards, Hans-Rudolf On 01/17/2014 05:38 PM, 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/
-----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/
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (GNU/Linux) iQIcBAEBAgAGBQJS2Wh7AAoJEMqDXdrsMcpVlZsP/0PtATKuyVA8Dt3U9NzEnSd3 oe2duZcCiIEqKrsllazdoH9l1uJja49d66FuOLcQag2/nNONVcNSSQXw4EbYqRe4 piZTf4bptsm1m44c615NCbfvUCg5XpGW6SniA5WWAbH2c4p+TRWiA5+N6AtD6GC0 +V5l8JScuPXyRt8Zq6Kt22mLYMeimRVOM2Y6PjSqqm/+kldvhzlwRWaQS7YCIH6v CBiHCA13XTvaJKl3NpSaJ4CpOMkVUOjZg1eKTlydUGespOUX5w1ZVZl6J/rvIAUd M7JRou1FtFeilCW/MiS6sgKFI4xl5IwZI4pxvq2s8dbOFSBKnz2p0/thcVjnPFzY x3yPM4A6lIehRrJHLOa3IiqEAjb/q0pmmla+Lh53dURhEWw6FISyktwng5Yaa/IS o/O6P+/paH/ujaOUFIMTEtb1hxoyUdkjDEaNLRwCpDlimqYOYhRG+XrAK9/8rbh5 8lntRnjN32Istkrq8Dk1p6ZRCceiYqfNZWdwHdvB65TYwcHfP7jmOAdLrObd3TN5 Fy+irjZALmCng8BBksJ5661xqXWICYwyW9U2XiVdPVBnb9DF2orCpsqQ2WRwWWFK mqJiGqpTSULy8FaPOsUQVc1n+ZafBaTgHs/XgM8PAfd8PlKUiZiaFhMkfuaUQ2so QGWlEJDCFNEwG6vPIwYv =7Tym -----END PGP SIGNATURE-----
Thank you Eric for the wiki page. I agree that Galaxy Reports are not visible enough and this might help. Martin, Galaxy Team On Fri, Jan 17, 2014 at 12:29 PM, Eric Rasche <rasche.eric@yandex.ru> wrote:
-----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/
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (GNU/Linux)
iQIcBAEBAgAGBQJS2Wh7AAoJEMqDXdrsMcpVlZsP/0PtATKuyVA8Dt3U9NzEnSd3 oe2duZcCiIEqKrsllazdoH9l1uJja49d66FuOLcQag2/nNONVcNSSQXw4EbYqRe4 piZTf4bptsm1m44c615NCbfvUCg5XpGW6SniA5WWAbH2c4p+TRWiA5+N6AtD6GC0 +V5l8JScuPXyRt8Zq6Kt22mLYMeimRVOM2Y6PjSqqm/+kldvhzlwRWaQS7YCIH6v CBiHCA13XTvaJKl3NpSaJ4CpOMkVUOjZg1eKTlydUGespOUX5w1ZVZl6J/rvIAUd M7JRou1FtFeilCW/MiS6sgKFI4xl5IwZI4pxvq2s8dbOFSBKnz2p0/thcVjnPFzY x3yPM4A6lIehRrJHLOa3IiqEAjb/q0pmmla+Lh53dURhEWw6FISyktwng5Yaa/IS o/O6P+/paH/ujaOUFIMTEtb1hxoyUdkjDEaNLRwCpDlimqYOYhRG+XrAK9/8rbh5 8lntRnjN32Istkrq8Dk1p6ZRCceiYqfNZWdwHdvB65TYwcHfP7jmOAdLrObd3TN5 Fy+irjZALmCng8BBksJ5661xqXWICYwyW9U2XiVdPVBnb9DF2orCpsqQ2WRwWWFK mqJiGqpTSULy8FaPOsUQVc1n+ZafBaTgHs/XgM8PAfd8PlKUiZiaFhMkfuaUQ2so QGWlEJDCFNEwG6vPIwYv =7Tym -----END PGP SIGNATURE----- ___________________________________________________________ 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/
participants (4)
-
Eric Rasche -
Hans-Rudolf Hotz -
Liisa Koski -
Martin Čech