Project HQ

Configuration:

sqlalchemy.url = mysql://projecthq@localhost:3306/projecthq
sqlalchemy.pool_recycle = 3600
sqlalchemy.convert_unicode = True

Ubuntu 9.10 i686

Python 2.6.4 (r264:75706, Dec  7 2009, 18:45:15)
[GCC 4.4.1] on linux2

When I try to create a task list, I get the following error in the apache logs:

[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1] mod_wsgi (pid=31794): Exception occurred processing WSGI script '/opt/projecthq/index.wsgi'., referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1] Traceback (most recent call last):, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/opt/projecthq/index.wsgi", line 17, in application, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return _application(environ, start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/paste/cascade.py", line 130, in __call__, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return self.apps[-1](environ, start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/paste/registry.py", line 350, in __call__, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     app_iter = self.application(environ, start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/Beaker-1.5.3-py2.6.egg/beaker/middleware.py", line 73, in __call__, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return self.app(environ, start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/Beaker-1.5.3-py2.6.egg/beaker/middleware.py", line 152, in __call__, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return self.wrap_app(environ, session_start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/Routes-1.10.3-py2.6.egg/routes/middleware.py", line 130, in __call__, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     response = self.app(environ, start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/paste/httpexceptions.py", line 636, in __call__, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return self.application(environ, start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/Pylons-0.10rc1-py2.6.egg/pylons/wsgiapp.py", line 124, in __call__, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     response = self.dispatch(controller, environ, start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/Pylons-0.10rc1-py2.6.egg/pylons/wsgiapp.py", line 327, in dispatch, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return controller(environ, start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/ProjectHQ-0.1.3dev_r149-py2.6.egg/projecthq/lib/base.py", line 81, in __call__, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return WSGIController.__call__(self, environ, start_response), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/Pylons-0.10rc1-py2.6.egg/pylons/controllers/core.py", line 225, in __call__, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     response = self._dispatch_call(), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/Pylons-0.10rc1-py2.6.egg/pylons/controllers/core.py", line 176, in _dispatch_call, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     response = self._inspect_call(func), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/Pylons-0.10rc1-py2.6.egg/pylons/controllers/core.py", line 108, in _inspect_call, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     result = self._perform_call(func, args), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/Pylons-0.10rc1-py2.6.egg/pylons/controllers/core.py", line 60, in _perform_call, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return func(**args), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/local/lib/python2.6/dist-packages/ProjectHQ-0.1.3dev_r149-py2.6.egg/projecthq/controllers/task_list.py", line 150, in save, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     Session.commit(), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/scoping.py", line 123, in do, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return getattr(self.registry(), name)(*args, **kwargs), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 673, in commit, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     self.transaction.commit(), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 378, in commit, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     self._prepare_impl(), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 362, in _prepare_impl, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     self.session.flush(), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 1354, in flush, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     self._flush(objects), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 1432, in _flush, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     flush_context.execute(), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 257, in execute, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     UOWExecutor().execute(self, tasks), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 720, in execute, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     self.execute_save_steps(trans, task), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 735, in execute_save_steps, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     self.save_objects(trans, task), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 726, in save_objects, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     task.mapper._save_obj(task.polymorphic_tosave_objects, trans), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/mapper.py", line 1387, in _save_obj, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     c = connection.execute(statement.values(value_params), params), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 824, in execute, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return Connection.executors[c](self, object, multiparams, params), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 874, in _execute_clauseelement, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     return self.__execute_context(context), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 896, in __execute_context, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 950, in _cursor_execute, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     self._handle_dbapi_exception(e, statement, parameters, cursor, context), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]   File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 931, in _handle_dbapi_exception, referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1]     raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect), referer: http://projecthq.abacus/task_list/add/
[Sun Apr 18 15:11:41 2010] [error] [client 127.0.1.1] OperationalError: (OperationalError) (1048, "Column 'project_id' cannot be null") u'INSERT INTO task_lists (project_id, milestone_id, member_id, created, modified, name, description, closed, priority, private) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' [None, u'1', u'0', datetime.datetime(2010, 4, 18, 14, 45, 43, 852904), datetime.datetime(2010, 4, 18, 14, 45, 43, 852937), 'test task list', '', 0, 1, True], referer: http://projecthq.abacus/task_list/add/