Hello guys,

So I’ve been working on the Galaxy report page.

It works fine however I’m using MySQL and I’m getting some server errors on some webpages.

I found the solution: https://lists.galaxyproject.org/pipermail/galaxy-dev/2009-August/000641.html

But can some please confirm the following:

1. The location of the files users.py and jobs.py is /home/galaxy/galaxy-prod/lib/galaxy/webapps/reports/controllers

2. There is three (3) "select closes" using five (5) "date_trunc" functions in users.py.

3. There is eight (8) "select closes" using fourteen (4) "date_trunc" functions in jobs.py.

4. Here is an example of what I can come up with. Is it correct?

· WRONG:

jobs_in_error_by_month = sa.select( ( sa.func.date_trunc( 'month', sa.func.date( model.Job.table.c.create_time ) ).label( 'date' ), sa.func.count( model.Job.table.c.id ).label('total_jobs' ) ),

whereclause=sa.and_ ( model.Job.table.c.state == 'error',

model.Job.table.c.user_id != monitor_user_id ),

from_obj=[ model.Job.table ],

group_by=[ sa.func.date_trunc( 'month', sa.func.date( model.Job.table.c.create_time ) ) ],

order_by=[ sa.desc( 'date' ) ] )

· RIGHT:

jobs_in_error_by_month = sa.select( ( sa.func.count( model.Job.table.c.id ).label('total_jobs' ) ),

whereclause=sa.and_ ( model.Job.table.c.state == 'error',

model.Job.table.c.user_id != monitor_user_id ),

from_obj=[ model.Job.table ],

group_by=[ day(model.Job.table.c.create_time), month(model.Job.table.c.create_time), year(model.Job.table.c.create_time) ],

order_by=[ sa.desc( 'date' ) ] )

Cordialement / Regards,

Edgar Fernandez

System Administrator (Linux)

Direction Générale des Technologies de l'Information et de la Communication

(  Bur. : 1-514-343-6111 poste 16568

Université de Montréal

PAVILLON ROGER-GAUDRY, bureau X-218