Moving the DB from SQLite to MySQL 5.0.19, and launching the
start-myprojectname.py i see an other error, but i'm not able to
understand if it is connected to the errors specified above:
C:\Documents and Settings\renzo\Desktop\ident>start-ident.py
10/Apr/2006:23:41:59 CONFIG INFO Server parameters:
10/Apr/2006:23:41:59 CONFIG INFO server.environment: development
10/Apr/2006:23:41:59 CONFIG INFO server.log_to_screen: True
10/Apr/2006:23:41:59 CONFIG INFO server.log_file:
10/Apr/2006:23:41:59 CONFIG INFO server.log_tracebacks: True
10/Apr/2006:23:41:59 CONFIG INFO server.log_request_headers: True
10/Apr/2006:23:41:59 CONFIG INFO server.protocol_version: HTTP/1.0
10/Apr/2006:23:41:59 CONFIG INFO server.socket_host:
10/Apr/2006:23:41:59 CONFIG INFO server.socket_port: 8080
10/Apr/2006:23:41:59 CONFIG INFO server.socket_file:
10/Apr/2006:23:41:59 CONFIG INFO server.reverse_dns: False
10/Apr/2006:23:41:59 CONFIG INFO server.socket_queue_size: 5
10/Apr/2006:23:41:59 CONFIG INFO server.thread_pool: 10
2006-04-10 23:41:59,828 turbogears.visit INFO Visit Tracking starting
2006-04-10 23:41:59,828 turbogears.visit DEBUG Loading visit manager
from plugin
: sqlobject
2006-04-10 23:41:59,905 turbogears.visit INFO Visit filter initialised
2006-04-10 23:42:00,312 turbogears.identity INFO Identity starting
2006-04-10 23:42:00,312 turbogears.identity DEBUG Loading provider from
plugin:
sqlobject
2006-04-10 23:42:00,312 turbogears.identity.soprovider INFO Succesfully
loaded "turbogears.identity.soprovider.TG_User"
2006-04-10 23:42:00,312 turbogears.identity.soprovider INFO Succesfully
loaded "turbogears.identity.soprovider.TG_Group"
2006-04-10 23:42:00,312 turbogears.identity.soprovider INFO Succesfully
loaded "turbogears.identity.soprovider.TG_Permission"
Unhandled exception in thread started by <bound method Server._start of
<cherrypy._cpserver.Server object at 0x00B9F610>>
Traceback (most recent call last):
File
"c:\python24\lib\site-packages\cherrypy-2.2.0-py2.4.egg\cherrypy\_cpserver.py",
line 78, in _start
Engine._start(self)
File
"c:\python24\lib\site-packages\cherrypy-2.2.0-py2.4.egg\cherrypy\_cpengine.py",
line 108, in _start
func()
File "c:\documents and
settings\renzo\documenti\sw\python\turbogears\svn\turbogears\startup.py",
line 204, in startTurboGears
ext.start_extension()
File "c:\documents and
settings\renzo\documenti\sw\python\turbogears\svn\turbogears\identity\visitor.py",
line 33, in start_extension
create_extension_model()
File "c:\documents and
settings\renzo\documenti\sw\python\turbogears\svn\turbogears\identity\visitor.py",
line 48, in create_extension_model
provider.create_provider_model()
File "c:\documents and
settings\renzo\documenti\sw\python\turbogears\svn\turbogears\identity\soprovider.py",
line 179, in create_provider_model
TG_VisitIdentity.createTable(ifNotExists=True)
File
"c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1684-py2.4.egg\sqlobject\main.py",
line 1322, in createTable
conn.createTable(cls)
File
"c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1684-py2.4.egg\sqlobject\dbconnection.py",
line 524, in createTable
self.query(self.createTableSQL(soClass))
File
"c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1684-py2.4.egg\sqlobject\dbconnection.py",
line 747, in query
return self._dbConnection._query(self._connection, s)
File
"c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1684-py2.4.egg\sqlobject\dbconnection.py",
line 302, in _query
self._executeRetry(conn, conn.cursor(), s)
File
"c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1684-py2.4.egg\sqlobject\mysql\mysqlconnection.py",
line 60, in _executeRetry
return cursor.execute(query)
File "C:\Python24\Lib\site-packages\MySQLdb\cursors.py", line 137, in
execute
self.errorhandler(self, exc, value)
File "C:\Python24\Lib\site-packages\MySQLdb\connections.py", line 33,
in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column
'visit_key' used in key specification without a key length")
Note that "turbogears.identity.soprovider.*" is imported into my model.
And looking at the MySQL database, after this error it contains:
tg_group, tg_group_permission, tg_permission, tg_user, tg_user_group,
tg_visit.
Thanks,
Renzo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears Trunk" 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-trunk
-~----------~----~----~----~------~----~------~--~---
