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/