FastTrack and the latest SVN

[Mark Ramm]

I am trying to get the latest version of FastTrack working with the
latest TurboGears from SVN, and I suspect that some identity changes
between 0.9a2 and now are causing problems.

The database appears to be set up correctly, and I can see and edit
the database from Catwalk, but nothing about identity of tg_visit
seems to be working properly.

When I try the /login controller I get this error:

Traceback (most recent call last):
File "c:\python24\lib\site-packages\cherrypy-2.2.0-py2.4.egg\cherrypy\_cphttptools.py",
line 104, in _run
applyFilters('before_main')
File "c:\python24\lib\site-packages\cherrypy-2.2.0-py2.4.egg\cherrypy\filters\__init__.py",
line 151, in applyFilters
method()
File "c:\turbogears\tg.dev\trunk\turbogears\visit\api.py", line 154,
in before_main
plugin.record_request( visit )
File "c:\turbogears\tg.dev\trunk\turbogears\identity\visitor.py",
line 158, in record_request
identity= self.identity_from_request(visit.key)
File "c:\turbogears\tg.dev\trunk\turbogears\identity\visitor.py",
line 86, in identity_from_request
identity= source(visit_key)
File "c:\turbogears\tg.dev\trunk\turbogears\identity\visitor.py",
line 141, in identity_from_form
identity= self.provider.validate_identity( user_name, pw, visit_key )
File "c:\turbogears\tg.dev\trunk\turbogears\identity\soprovider.py",
line 199, in validate_identity
user= user_class.by_user_name( user_name )
AttributeError: type object 'Person' has no attribute 'by_user_name'

If on the other hand I go directly to localhost:8080/dashboard

I get this error:

Page handler: <function _wrapper at 0x015B62B0>
Traceback (most recent call last):
File "c:\python24\lib\site-packages\cherrypy-2.2.0-py2.4.egg\cherrypy\_cphttptools.py",
line 106, in _run
self.main()
File "c:\python24\lib\site-packages\cherrypy-2.2.0-py2.4.egg\cherrypy\_cphttptools.py",
line 255, in main
body = page_handler(*virtual_path, **self.params)
File "c:\turbogears\tg.dev\trunk\turbogears\identity\conditions.py",
line 273, in _wrapper
if predicate.eval_with_object( current, errors ):
File "c:\turbogears\tg.dev\trunk\turbogears\identity\conditions.py",
line 120, in eval_with_object
if current.anonymous:
File "c:\turbogears\tg.dev\trunk\turbogears\identity\__init__.py",
line 59, in __getattr__
return getattr(identity, name)
File "c:\turbogears\tg.dev\trunk\turbogears\identity\soprovider.py",
line 88, in _get_anonymous
return not self.user
File "c:\turbogears\tg.dev\trunk\turbogears\identity\soprovider.py",
line 67, in _get_user
visit= TG_VisitIdentity.by_visit_key( self.visit_key )
File "<string>", line 1, in <lambda>
File "c:\turbogears\tg.dev\trunk\thirdparty\sqlobject\sqlobject\main.py",
line 1266, in _SO_fetchAlternateID
result, obj = cls._findAlternateID(name, dbName, value, connection)
File "c:\turbogears\tg.dev\trunk\thirdparty\sqlobject\sqlobject\main.py",
line 1262, in _findAlternateID
value), None
File "c:\turbogears\tg.dev\trunk\thirdparty\sqlobject\sqlobject\dbconnection.py",
line 587, in _SO_selectOneAlt
return self.queryOne("SELECT %s FROM %s WHERE %s = %s" %
File "c:\turbogears\tg.dev\trunk\thirdparty\sqlobject\sqlobject\dbconnection.py",
line 755, in queryOne
return self._dbConnection._queryOne(self._connection, s)
File "c:\turbogears\tg.dev\trunk\thirdparty\sqlobject\sqlobject\dbconnection.py",
line 341, in _queryOne
self._executeRetry(conn, c, s)
File "c:\turbogears\tg.dev\trunk\thirdparty\sqlobject\sqlobject\dbconnection.py",
line 297, in _executeRetry
return cursor.execute(query)
ProgrammingError: column "visit_key" does not exist

The database definitely shows a tg_visit table with a visit_key column.

Any thoughts on this? I haven't had much time to look into it in
depth, and probably won't for a couple of days. But it sure would be
nice to have this working soon, as I am writing about some examples
from FastTrack for the TurboGears book this week ;)

--
Mark Ramm-Christensen
email: mark at compoundthinking dot com
blog: www.compoundthinking.com/blog

[Max Ischenko]

This is caused by identity refactoring by Jeff.

I'm not sure whether upgrade instructions has been published anywhere,
but you can find the thread with announcement in tg-trunk. To update
your db schema try patches from the #737.

[Mark Ramm]

Thanks, I'll check that out!

[Sebastian Silva]

How did you handle this? I'm having trouble with Fasttrack and TG
0.9a6...

I tried to use "identity-migrate-09a4-to-09a5.sql" from #737, tried
adapting it...

Getting this:

Traceback (most recent call last):
File

"/usr/local/lib/python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/cherrypy/_cphttptools.py",
line 103, in _run
applyFilters('before_main')
File
"/usr/local/lib/python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/cherrypy/filters/__init__.py",

line 151, in applyFilters
method()
File

"/usr/local/lib/python2.4/site-packages/TurboGears-0.9a6-py2.4.egg/turbogears/visit/api.py",

line 154, in before_main
plugin.record_request( visit )
File

"/usr/local/lib/python2.4/site-packages/TurboGears-0.9a6-py2.4.egg/turbogears/identity/visitor.py",
line 162, in record_request
identity= self.identity_from_request(visit.key)
File
"/usr/local/lib/python2.4/site-packages/TurboGears-0.9a6-py2.4.egg/turbogears/identity/visitor.py",

line 86, in identity_from_request
identity= source(visit_key)
File

"/usr/local/lib/python2.4/site-packages/TurboGears-0.9a6-py2.4.egg/turbogears/identity/visitor.py",
line 143, in identity_from_form

identity= self.provider.validate_identity( user_name, pw, visit_key
)
File

"/usr/local/lib/python2.4/site-packages/TurboGears-0.9a6-py2.4.egg/turbogears/identity/soprovider.py",
line 222, in validate_identity

user= user_class.by_user_name( user_name )
AttributeError: type object 'Person' has no attribute 'by_user_name'

Help is appreciated!