Hi,
I saw in the old posts that there seems to be an extra line of code
required in both the tutorials on the TurboGears website. The posts
relating to this are one year old (and are closed) so I'm posting here.
If you are running the todo list tute with MySQL you get the folloowing
when you do the tg-admin sql create command:
[snipped]
File "C:\Python24\Lib\site-packages\MySQLdb\connections.py", line 35,
in defau
lterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'email'
used in key
specification without a key length")
What is the definitive version of the tutorial code to get it to work
with MySQL. The code in question being:
class User(SQLObject):
email = StringCol(alternateID=True)
lists = MultipleJoin('List')
class List(SQLObject):
title = UnicodeCol(notNone=True)
user = ForeignKey('User')
items = MultipleJoin('Item')
class Item(SQLObject):
value = UnicodeCol(notNone=True)
list = ForeignKey('List')
It would probably be worth updating the website examples accordingly if
possible, for the benefit of TG newbies like me. :)
Many thanks,
Tony
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
