how to create sql

[manuhack]

Hi,

I just follow the instruction and try a new project with
registration. After

tg-admin quickstart -t registration

it works well. Then I modify dev.cfg and run

tg-admin sql create

but then I run

tg-admin sql list, it shows

mysite.model.VisitIdentity
mysite.model.Visit
mysite.model.Group
mysite.model.User
mysite.model.Permission

and when I go to mysite/registration and fill in all the info and
click register, an error

ProgrammingError: Table 'mysite.registration_pending_user' doesn't
exist

appears. So what is the right way to create the sql table? Thanks.

[Patrick Lewis]

I think you are probably running into a bug that sometimes appeared in
the 0.3 release. The tables were supposed to be autogenerated, but it
doesn't always seem to work. Try these two commands (from tg-admin
shell):

import register_model as r
r.create_registration_tables()

[Manu Hack]

I can import but the second command doesn't work. I just tried running

r.RegistrationPendingUser.createTable()

and now I can submit the form in registration/new and move to
registration/create.

However, in tg-admin toolbox catwalk I still could find the
RegistrationPendingUser.

Thanks!

[Patrick Lewis]

On Nov 21, 8:58 am, "Manu Hack" <manuh...@gmail.com> wrote:

> On Nov 21, 2007 8:47 AM, Patrick Lewis <patrickhle...@gmail.com> wrote:
>
> > import register_model as r
> > r.create_registration_tables()
>
> I can import but the second command doesn't work. I just tried running
>
> r.RegistrationPendingUser.createTable()
>
> and now I can submit the form in registration/new and move to
> registration/create.
>
> However, in tg-admin toolbox catwalk I still could find the
> RegistrationPendingUser.
>
> Thanks!

I believe not seeing it in catwalk is expected. Catwalk can only pull
values from one model file. Or at least that was the case last time I
looked.