The basic problem was solved once I understood more about the .table
files. Thanks all.
On Oct 17, 5:21 pm, mdipierro <[EMAIL PROTECTED]> wrote:
> If you comment everything else, does this
>
> db=SQLDB('mysql://blah:[EMAIL PROTECTED]:3306/onestepbeyond')
> from applications.plugin_t2.modules.t2 import T2
> t2=T2(request,response,session,cache,T,db)
>
> work?
>
> Did you try sqlite first?
>
> Nothing to do with your error but change author_id with created_by and
> it will be handled automatically.
>
> Massimo
>
> On Oct 17, 11:08 am, billf <[EMAIL PROTECTED]> wrote:
>
> > I installed t2 and got some basic examples up and running ok using a
> > MySQL database. I want to test out some of the in-built columns, e.g.
> > created_on and modified_on so I added these to my tables and got the
> > "person table already exists" raised in my previous post.
>
> > So I deleted all the tables and ran my example again. This time it
> > failed in t2.py with
> > "Table 'onestepbeyond.t2_membership' doesn't exist"
>
> > It fails the same if I try "database administration". It is the same
> > even if I stop and start the server.
>
> > My db.py is as follows (note t2 def is up front compared to the
> > examples as I ref t2_person in 'newsitem' table):
> > -------------------------------------------------------------------------------------------------------
> > db=SQLDB('mysql://blah:[EMAIL PROTECTED]:3306/onestepbeyond')
>
> > from applications.plugin_t2.modules.t2 import T2
> > t2=T2(request,response,session,cache,T,db)
>
> > import datetime
> > now=datetime.datetime.now()
>
> > db.define_table('newsitem',
> > SQLField('created_on','datetime'),
> > SQLField('modified_on','datetime'),
> > SQLField('author_id',db.t2_person),
> > SQLField('title',length=50,required=True),
> > SQLField('summary',length=255,required=True),
> > SQLField('content','text',required=True),
>
> > SQLField('more_link',length=255,required=True,default=''),
> > SQLField('type',length=1,required=True,default=''),
>
> > SQLField('from_ts','datetime',required=True,default=now),
> > SQLField('to_ts','datetime',required=True))
>
> > db.define_table('lookup',
> > SQLField('created_on','datetime'),
> > SQLField('modified_on','datetime'),
>
> > SQLField('other','string',length=255,required=True,default=''),
> > SQLField('type','string',length=20,required=True),
> > SQLField('value','string',length=30,required=True))
>
> > db.lookup.type.requires=IS_IN_SET(['LookupType','Country','CustomTerm',
> > \
> > 'GroupPreference','GroupShopping'])
> > db.lookup.value.requires=IS_NOT_EMPTY()
> > db.lookup.represent=lambda row:
> > A(row.value,_href=t2.action('update_lookup',[row.id]))
> > -------------------------------------------------------------------------------------------------------------------------------
>
> > If I replace the t2_person ref with 'integer' and move t2=T2(etc) to
> > the end, it fails because table 'newsitem' does NOT exist.
>
> > If I create a 'newsitem' table with just a 'author_id' column in it,
> > it fails in sql.py with "Commands out of sync."
>
> > Any ideas? Am I missing something obvious?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
