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/