I don't know why, but if you turn off transactions in your database connection string (the method for this is described in the config file), you'll be able to run tg-admin sql create without getting this error.
Then if you want transactions, just remove it from the URI, and continue on with development. I think there's something strange about SQLite 2 and transactions on table commits, but I haven't had time to look into it. On 8/17/06, Glenn Davy <[EMAIL PROTECTED]> wrote: > > tg-admin info: > TurboGears Complete Version Information > > TurboGears requires: > > * TurboGears 1.1a0 > * nose 0.8.6 > * ConfigObj 4.3.1 > * RuleDispatch 0.5a0.dev-r2115 > * setuptools 0.6a11 > * FormEncode 0.5.1 > * cElementTree 1.0.5-20051216 > * PasteScript 0.5.1 > * elementtree 1.2.6 > * simplejson 1.3 > * SQLObject 0.7.1dev-r1675 > * CherryPy 2.2.1 > * TurboKid 0.9.5 > * TurboCheetah 0.9.5 > * TurboJson 0.9.2 > * PyProtocols 1.0a0 > * Cheetah 1.0 > * PasteDeploy 0.5 > * Paste 0.5 > * FormEncode 0.5.1 > * kid 0.9.1 > * Cheetah 1.0 > * elementtree 1.2.6 > > Identity Providers > > * sqlobject (TurboGears 1.1a0) > * sqlalchemy (TurboGears 1.1a0) > > tg-admin Commands > > * info (TurboGears 1.1a0) > * shell (TurboGears 1.1a0) > * quickstart (TurboGears 1.1a0) > * update (TurboGears 1.1a0) > * sql (TurboGears 1.1a0) > * i18n (TurboGears 1.1a0) > * toolbox (TurboGears 1.1a0) > > Visit Managers > > * sqlobject (TurboGears 1.1a0) > * sqlalchemy (TurboGears 1.1a0) > > Template Engines > > * kid (TurboKid 0.9.5) > * cheetah (TurboCheetah 0.9.5) > * json (TurboJson 0.9.2) > > Widget Packages > > > TurboGears Extensions > > * visit (TurboGears 1.1a0) > * identity (TurboGears 1.1a0) > > sqlite -version: > 2.8.17 > > > > On Thu, 2006-08-17 at 16:42 -0400, Karl Guertin wrote: > > On 8/17/06, glenn <[EMAIL PROTECTED]> wrote: > > > My first show stopper is, having greated some models when I run > > > tg-admin sql create I get this error (for sqlite): > > > > I'm not sure what the state of the trunk is, so you'll probably be > > better off on the 1.0 branch if you aren't already. In order to help > > diagnose easy stuff, what's the output of tg-admin info and sqlite > > -version? > > > > For reference, here's mine: > > TurboGears Complete Version Information > > > > TurboGears requires: > > > > * TurboGears 0.9a9dev-r1738 > > * nose 0.8.6 > > * ConfigObj 4.3.1 > > * RuleDispatch 0.5a0.dev > > * setuptools 0.6c1 > > * FormEncode 0.5.1 > > * cElementTree 1.0.5-20051216 > > * PasteScript 0.5.1 > > * elementtree 1.2.6 > > * simplejson 1.3 > > * SQLObject 0.8dev-r1814 > > * CherryPy 2.2.1 > > * TurboKid 0.9.8 > > * TurboCheetah 0.9.5 > > * TurboJson 0.9.4 > > * PyProtocols 1.0a0 > > * Cheetah 1.0 > > * PasteDeploy 0.3 > > * Paste 0.3 > > * FormEncode 0.5.1 > > * kid 0.9.3 > > * Cheetah 1.0 > > * elementtree 1.2.6 > > > > Identity Providers > > > > * sqlobject (TurboGears 0.9a9dev-r1738) > > * sqlalchemy (TurboGears 0.9a9dev-r1738) > > > > tg-admin Commands > > > > * info (TurboGears 0.9a9dev-r1738) > > * shell (TurboGears 0.9a9dev-r1738) > > * quickstart (TurboGears 0.9a9dev-r1738) > > * update (TurboGears 0.9a9dev-r1738) > > * sql (TurboGears 0.9a9dev-r1738) > > * i18n (TurboGears 0.9a9dev-r1738) > > * toolbox (TurboGears 0.9a9dev-r1738) > > > > Visit Managers > > > > * sqlobject (TurboGears 0.9a9dev-r1738) > > * sqlalchemy (TurboGears 0.9a9dev-r1738) > > > > Template Engines > > > > * json (TurboJson 0.9.4) > > * kid (TurboKid 0.9.8) > > * cheetah (TurboCheetah 0.9.5) > > > > Widget Packages > > > > > > TurboGears Extensions > > > > * visit (TurboGears 0.9a9dev-r1738) > > * identity (TurboGears 0.9a9dev-r1738) > > > > sqlite -version > > 2.8.16 > > > > > > > > > -- Mark Ramm-Christensen email: mark at compoundthinking dot com blog: www.compoundthinking.com/blog --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
