#1089: Login seems to cause toolbox to die
----------------------+-----------------------------------------------------
Reporter: jbarrett | Owner: anonymous
Type: defect | Status: new
Priority: normal | Milestone:
Component: Identity | Version: 0.9a6
Severity: normal | Keywords:
----------------------+-----------------------------------------------------
Using the quickstart with identity management enabled, when i login
something seems to break in the toolbox.
process to replicate:
1. use quickstart to create a project with identity management
1. start toolbox
1. go to catwalk create a user
1. go to http://localhost:8080
1. login as the user
* note that login works and the site seems unaffected
1. refresh the toolbox page
you should get the error message given at the bottom of the ticket.
From a brief examination of the database it appears that a couple of extra
tables have been created (tg_visit and tg_visit_identity) however simply
deleting them doesn't cause toolbox to start working, only using a tg-
admin sql create after deleting. Also note that this doesn't directly
effect the site itself, the site is still just as functional as it was, it
just prevents you using the toolbox.
If it's important i'm using mysql as a backend.
Also i'm using TG 0.9a9 but that isn't an option in your version drop box.
----
500 Internal error
The server encountered an unexpected condition which prevented it from
fulfilling the request.
Page handler: "Unknown column 'child_name' in 'field list'"
Traceback (most recent call last):
File "c:\python24\lib\site-
packages\CherryPy-2.2.1-py2.4.egg\cherrypy\_cphttptools.py", line 103, in
_run
applyFilters('before_main')
File "c:\python24\lib\site-
packages\CherryPy-2.2.1-py2.4.egg\cherrypy\filters\__init__.py", line 151,
in applyFilters
method()
File "c:\python24\lib\site-packages\TurboGears-0.9a9-
py2.4.egg\turbogears\visit\api.py", line 154, in before_main
plugin.record_request( visit )
File "c:\python24\lib\site-packages\TurboGears-0.9a9-
py2.4.egg\turbogears\identity\visitor.py", line 170, in record_request
set_current_identity( identity )
File "c:\python24\lib\site-packages\TurboGears-0.9a9-
py2.4.egg\turbogears\identity\__init__.py", line 102, in
set_current_identity
cherrypy.request.user_name = identity.user_name
File "c:\python24\lib\site-packages\TurboGears-0.9a9-
py2.4.egg\turbogears\identity\soprovider.py", line 91, in _get_user_name
if not self.user:
File "c:\python24\lib\site-packages\TurboGears-0.9a9-
py2.4.egg\turbogears\identity\soprovider.py", line 82, in _get_user
self._user= user_class.get( visit.user_id )
File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1860-
py2.4.egg\sqlobject\inheritance\__init__.py", line 161, in get
val = super(InheritableSQLObject, cls).get(id, connection,
selectResults)
File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1860-
py2.4.egg\sqlobject\main.py", line 912, in get
val._init(id, connection, selectResults)
File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1860-
py2.4.egg\sqlobject\main.py", line 955, in _init
selectResults = self._connection._SO_selectOne(self, dbNames)
File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1860-
py2.4.egg\sqlobject\dbconnection.py", line 576, in _SO_selectOne
return self.queryOne(
File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1860-
py2.4.egg\sqlobject\dbconnection.py", line 349, in queryOne
return self._runWithConnection(self._queryOne, s)
File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1860-
py2.4.egg\sqlobject\dbconnection.py", line 220, in _runWithConnection
val = meth(conn, *args)
File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1860-
py2.4.egg\sqlobject\dbconnection.py", line 342, in _queryOne
self._executeRetry(conn, c, s)
File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1860-
py2.4.egg\sqlobject\mysql\mysqlconnection.py", line 74, in _executeRetry
return cursor.execute(myquery)
File "C:\Python24\Lib\site-packages\MySQLdb\cursors.py", line 163, in
execute
self.errorhandler(self, exc, value)
File "C:\Python24\Lib\site-packages\MySQLdb\connections.py", line 35, in
defaulterrorhandler
raise errorclass, errorvalue
OperationalError: 1054
Powered by CherryPy 2.2.1
--
Ticket URL: <http://trac.turbogears.org/turbogears/ticket/1089>
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.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears-tickets
-~----------~----~----~----~------~----~------~--~---
