#1089: Login seems to cause toolbox to die
-----------------------------+----------------------------------------------
Reporter: jbarrett | Owner: anonymous
Type: defect | Status: new
Priority: high | Milestone: 1.0b2
Component: Toolbox.Catwalk | Version: 0.9a6
Severity: normal | Resolution:
Keywords: |
-----------------------------+----------------------------------------------
Changes (by jorge.vargas):
* priority: normal => high
* component: Identity => Toolbox.Catwalk
Old description:
> 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
New description:
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. start the app
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
Comment:
with 1.0b1 I'm getting a big traceback and Catwalk is frozen.
this is certainly an ugly bug
--
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
-~----------~----~----~----~------~----~------~--~---
