#2382: Quickstarted TG 1.1 project with SO and identity throws OperationalError
------------------------+---------------------------------------------------
Reporter: chrisz | Owner:
Type: defect | Status: new
Priority: high | Milestone: 1.1
Component: TurboGears | Version: 1.1rc1
Severity: blocker | Keywords: sqlobject identity
------------------------+---------------------------------------------------
Quickstarted a TG 1.1rc1 project with SQLObject (0.11.2, but the same
happened with 0.10.1 and 0.10.2) and Identity. Created tables and added a
user. Tried to log in as the user. Got the following error:
{{{
Traceback (most recent call last):
File "...\cherrypy\_cphttptools.py", line 119, in _run
applyFilters('before_main')
File "...\cherrypy\filters\__init__.py", line 151, in applyFilters
method()
File "...\branches\1.1\turbogears\visit\api.py", line 256, in
before_main
plugin.record_request(visit)
File "...\branches\1.1\turbogears\identity\visitor.py", line 183, in
record_request
identity = self.identity_from_request(visit.key)
File "...\branches\1.1\turbogears\identity\visitor.py", line 94, in
identity_from_request
identity = source(visit_key)
File "...\1.1\turbogears\identity\visitor.py", line 164, in
identity_from_form
identity = self.provider.validate_identity(user_name, pw, visit_key)
File "...\branches\1.1\turbogears\identity\soprovider.py", line 223, in
validate_identity
user = user_class.by_user_name(user_name)
File "<string>", line 1, in <lambda>
File "...\sqlobject\main.py", line 1329, in _SO_fetchAlternateID
result, obj = cls._findAlternateID(name, dbName, value, connection)
File "...\sqlobject\inheritance\__init__.py", line 390, in
_findAlternateID
result = list(cls.selectBy(connection, **{name: value}))
File "...\sqlobject\sresults.py", line 179, in __iter__
return iter(list(self.lazyIter()))
File "...\sqlobject\sresults.py", line 187, in lazyIter
return conn.iterSelect(self)
File "...\sqlobject\dbconnection.py", line 717, in iterSelect
select, keepConnection=True)))
File "...\sqlobject\inheritance\iteration.py", line 10, in __init__
super(InheritableIteration, self).__init__(dbconn, rawconn, select,
keepConnection)
File "...\sqlobject\dbconnection.py", line 646, in __init__
self.dbconn._executeRetry(self.rawconn, self.cursor, self.query)
File "...\sqlobject\sqlite\sqliteconnection.py", line 183, in
_executeRetry
raise OperationalError(ErrorMessage(e))
OperationalError: no such column: tg_user.child_name
}}}
Did nobody try TG 1.1 with SQLObject? Why does our test suite not catch
this?
--
Ticket URL: <http://trac.turbogears.org/ticket/2382>
TurboGears <http://www.turbogears.org/>
TurboGears front-to-back web development
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "TurboGears Tickets" group.
This group is read-only. No posting by normal members allowed.
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/turbogears-tickets?hl=en?hl=en
-~----------~----~----~----~------~----~------~--~---
