AFAIK, this is a mysql specific issue that I also see here - are you also running mysql? Postgresql has a date_trunc function but mysql does not. On Thu, Nov 18, 2010 at 10:01 AM, SHAUN WEBB <swebb1@staffmail.ed.ac.uk>wrote:
Hi, I am having a few issues when developing reports.
If I click on jobs per month I get an error
OperationalError: (OperationalError) (1305, 'FUNCTION galaxy_test.date_trunc does not exist')
Full traceback is below. There are similar errors when I click on links for a specific user or tool.
Any idea what the issue is.
Thanks in advance for any help.
Shaun Webb
URL: http://bifx3.bio.ed.ac.uk:9001/jobs/per_month_all File '/home/galaxy/galaxy_dist/eggs/Paste-1.6-py2.6.egg/paste/exceptions/errormiddleware.py', line 143 in __call__ app_iter = self.application(environ, start_response) File '/home/galaxy/galaxy_dist/eggs/Paste-1.6-py2.6.egg/paste/debug/prints.py', line 98 in __call__ environ, self.app) File '/home/galaxy/galaxy_dist/eggs/Paste-1.6-py2.6.egg/paste/wsgilib.py', line 539 in intercept_output app_iter = application(environ, replacement_start_response) File '/home/galaxy/galaxy_dist/eggs/Paste-1.6-py2.6.egg/paste/recursive.py', line 80 in __call__ return self.application(environ, start_response) File '/home/galaxy/galaxy_dist/eggs/Paste-1.6-py2.6.egg/paste/httpexceptions.py', line 632 in __call__ return self.application(environ, start_response) File '/home/galaxy/galaxy_dist/lib/galaxy/web/framework/base.py', line 145 in __call__ body = method( trans, **kwargs ) File '/home/galaxy/galaxy_dist/lib/galaxy/webapps/reports/controllers/jobs.py', line 251 in per_month_all for row in q.execute(): File '/home/galaxy/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/sql/expression.py', line 1121 in execute return e._execute_clauseelement(self, multiparams, params) File '/home/galaxy/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', line 1209 in _execute_clauseelement return connection._execute_clauseelement(elem, multiparams, params) File '/home/galaxy/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', line 874 in _execute_clauseelement return self.__execute_context(context) File '/home/galaxy/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', line 896 in __execute_context self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context) File '/home/galaxy/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', line 950 in _cursor_execute self._handle_dbapi_exception(e, statement, parameters, cursor, context) File '/home/galaxy/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', line 931 in _handle_dbapi_exception raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect) OperationalError: (OperationalError) (1305, 'FUNCTION galaxy_test.date_trunc does not exist') u'SELECT date_trunc(%s, date(job.create_time)) AS date, sum(CASE WHEN (galaxy_user.email = %s) THEN %s ELSE %s END) AS monitor_jobs, count(job.id) AS total_jobs \nFROM job LEFT OUTER JOIN galaxy_user ON galaxy_user.id = job.user_id GROUP BY date_trunc(%s, date(job.create_time)) ORDER BY date DESC' ['month', ' monitor@bx.psu.edu', 1, 0, 'month']
-- The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.
_______________________________________________ galaxy-dev mailing list galaxy-dev@lists.bx.psu.edu http://lists.bx.psu.edu/listinfo/galaxy-dev
-- Ross Lazarus MBBS MPH Associate Professor, Harvard Medical School Director of Bioinformatics, Channing Laboratory 181 Longwood Ave., Boston MA 02115, USA. Tel: +1 617 505 4850