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