The most important part of the traceback is often the last line: >sqlobject.dberrors.OperationalError: BLOB/TEXT column 'username' used > in key specification without a key length
That exception is pretty explicit. MySQL needs to have a length defined for text columns that are part of a key (e.g. primary or alternate). So try adding that to your column definition. (with a length < 1000). btw, I confirmed this by searching for the exception above on google (removing your specific column name from the search). It returned exactly one hit [1]. also, since SQLObject is just passing along the error from the mqsql dbapi backend, you could also just google for the error text (ie, the stuff after the exception name). That'll give you ideas on other workarounds. (Not that you need it, since simply setting the length to a reasonable value should fix your problem. (but, hey, some future searcher might)). hth, -ken ps: (i guess i must be in a parenthetical mood tonight). :-) [1] http://www.mail-archive.com/[EMAIL PROTECTED]/msg03252.html --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
