Yey? :D A bug! I got this when trying to add a group with.
Name: acapur-test1a
Display: acapur-test1a
Owner: acapur
Type: tracking
Needs Sponsor: no
Self-Removal: no
Must Belong To: (Blank)
Join Message: Testing No Sponsor, No Self Removal No Must Belong To
Page handler: <bound method Group.create of <fas.group.Group object at 0x154cc90>>
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/cherrypy/_cphttptools.py", line 121, in _run
self.main()
File "/usr/lib/python2.4/site-packages/cherrypy/_cphttptools.py", line 264, in main
body = page_handler(*virtual_path, **self.params)
File "<string>", line 3, in create
File "/usr/lib/python2.4/site-packages/turbogears/identity/conditions.py", line 242, in require
return fn(self, *args, **kwargs)
File "<string>", line 3, in create
File "/usr/lib/python2.4/site-packages/turbogears/controllers.py", line 200, in validate
return errorhandling.run_with_errors(errors, func, *args, **kw)
File "/usr/lib/python2.4/site-packages/turbogears/errorhandling.py", line 110, in run_with_errors
return func(self, *args, **kw)
File "<string>", line 3, in create
File "/usr/lib/python2.4/site-packages/turbogears/controllers.py", line 361, in expose
output = database.run_with_transaction(
File "<string>", line 5, in run_with_transaction
File "/usr/lib/python2.4/site-packages/turbogears/database.py", line 405, in sa_rwt
retval = func(*args, **kw)
File "<string>", line 5, in _expose
File "/usr/lib/python2.4/site-packages/turbogears/controllers.py", line 378, in <lambda>
mapping, fragment, args, kw)))
File "/usr/lib/python2.4/site-packages/turbogears/controllers.py", line 405, in _execute_func
output = errorhandling.try_call(func, *args, **kw)
File "/usr/lib/python2.4/site-packages/turbogears/errorhandling.py", line 72, in try_call
return func(self, *args, **kw)
File "/srv/fedora-infrastructure/fas/fas/group.py", line 175, in create
session.flush()
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/scoping.py", line 98, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/session.py", line 764, in flush
self.uow.flush(self, objects)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 215, in flush
flush_context.execute()
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 437, in execute
UOWExecutor().execute(self, tasks)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 927, in execute
self.execute_save_steps(trans, task)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 944, in execute_save_steps
self.execute_per_element_childtasks(trans, task, False)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 967, in execute_per_element_childtasks
self.execute_element_childtasks(trans, element, isdelete)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 971, in execute_element_childtasks
self.execute(trans, [child], isdelete)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 927, in execute
self.execute_save_steps(trans, task)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 942, in execute_save_steps
self.save_objects(trans, task)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 933, in save_objects
task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/mapper.py", line 1106, in _save_obj
c = connection.execute(statement.values(value_params), params)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 846, in execute
return Connection.executors[c](self, object, multiparams, params)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 897, in execute_clauseelement
return self._execute_compiled(elem.compile(dialect=self.dialect, column_keys=keys, inline=len(params) > 1), distilled_params=params)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 909, in _execute_compiled
self.__execute_raw(context)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 918, in __execute_raw
self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 962, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 944, in _handle_dbapi_exception
raise exceptions.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect)
ProgrammingError: (ProgrammingError) column "needs_sponsor" is of type boolean but expression is of type integer
HINT: You will need to rewrite or cast the expression.
'INSERT INTO groups (id, name, display_name, owner_id, group_type, needs_sponsor, user_can_remove, prerequisite_id, joinmsg) VALUES (%(id)s, %(name)s, %(display_name)s, %(owner_id)s, %(group_type)s, %(needs_sponsor)s, %(user_can_remove)s, %(prerequisite_id)s, %(joinmsg)s)' {'display_name': 'acapur-test1a', 'name': 'acapur-test1a', 'needs_sponsor': 0, 'prerequisite_id': None, 'user_can_remove': 1, 'joinmsg': 'Testing No Sponsor, No Self Removal, No "Must Belong To"', 'id': 1145L, 'group_type': 'tracking', 'owner_id': 1122}