is this an SO problem??? consider downgrading to 0.7. This has worked for me in the past, or better yet, move to SA.
-chris On Jan 30, 11:06 am, Gerry Bayles <[EMAIL PROTECTED]> wrote: > I have Python version 2.5.1 installed on an XP machine. > I have installed (and re-installed) MySQL-python-1.2.2.win32-py2.5.exe > I get the same results with both MySQL 5.1.22-rc and 5.0.51a. > > I have followed the steps outlined in "http://docs.turbogears.org/1.0/ > DatabaseMySQL", which are, briefly: > Create db... > mysql> CREATE DATABASE test2; > Query OK, 1 row affected (0.03 sec) > mysql> GRANT ALL ON test2.* TO 'george'@'localhost'; > Query OK, 0 rows affected (0.11 sec) > > Set up dev.cfg... > sqlobject.dburi="mysql://[EMAIL PROTECTED]/test2" > > When I run "tg-admin sql create", I get the following: > Using database URI mysql://[EMAIL PROTECTED]/test2 > Traceback (most recent call last): > File "C:\Python25\Scripts\tg-admin-script.py", line 8, in <module> > load_entry_point('TurboGears==1.0.3.2', 'console_scripts', 'tg- > admin')() > File "c:\python25\lib\site-packages\TurboGears-1.0.3.2-py2.5.egg > \turbogears\command\base.py", line 389, in main > command.run() > File "c:\python25\lib\site-packages\TurboGears-1.0.3.2-py2.5.egg > \turbogears\command\base.py", line 144, in run > command.the_runner.run(sys.argv) > File "c:\python25\lib\site-packages\SQLObject-0.9.2-py2.5.egg > \sqlobject\manager\command.py", line 101, in run > runner.run() > File "c:\python25\lib\site-packages\SQLObject-0.9.2-py2.5.egg > \sqlobject\manager\command.py", line 307, in run > self.command() > File "c:\python25\lib\site-packages\SQLObject-0.9.2-py2.5.egg > \sqlobject\manager\command.py", line 666, in command > tableConstraints = soClass.createTable(applyConstraints=False) > File "c:\python25\lib\site-packages\SQLObject-0.9.2-py2.5.egg > \sqlobject\main.py", line 1378, in createTable > constraints = conn.createTable(cls) > File "c:\python25\lib\site-packages\SQLObject-0.9.2-py2.5.egg > \sqlobject\dbconnection.py", line 569, in createTable > self.query(createSql) > File "c:\python25\lib\site-packages\SQLObject-0.9.2-py2.5.egg > \sqlobject\dbconnection.py", line 342, in query > return self._runWithConnection(self._query, s) > File "c:\python25\lib\site-packages\SQLObject-0.9.2-py2.5.egg > \sqlobject\dbconnection.py", line 255, in _runWithConnection > val = meth(conn, *args) > File "c:\python25\lib\site-packages\SQLObject-0.9.2-py2.5.egg > \sqlobject\dbconnection.py", line 339, in _query > self._executeRetry(conn, conn.cursor(), s) > File "c:\python25\lib\site-packages\SQLObject-0.9.2-py2.5.egg > \sqlobject\mysql\mysqlconnection.py", line 125, in _executeRetry > raise OperationalError(ErrorMessage(e)) > sqlobject.dberrors.OperationalError: BLOB/TEXT column 'username' used > in key specification without a key length --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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?hl=en -~----------~----~----~----~------~----~------~--~---
