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/

___________________________________________________________
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/

Reply via email to