On 10/14/05, Rod Morison <[EMAIL PROTECTED]> wrote: > > I was following the .mov tutorial: so, I went ahead and let tg-admin sql > create "repair". I got a python exception > > ... > File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line > 33, in defaulterrorhandler > raise errorclass, errorvalue > _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'pagename' > used in key specification without a key length") > > I noticed in the printed tutorial model.py was > > class Page(SQLObject): > pagename = StringCol(alternateID=True, length=30) > data = StringCol() > > instead of what's in the (otherwise spiffy) movie tutorial > > class Page(SQLObject): > pagename = StringCol(alternateID=True) > data = StringCol() > > That fixed things, and tg-admin sql create now does as advertised. > Caveat Emptor, I think I'll proceed with the printed version.
Actually, the .mov works as advertised even under 0.8 (with the exception of the turbogears-admin name change) *if* you're using sqlite as I was. The printed tutorial has had a number of fixes and improvements applied to it over time. Kevin
