Confirmed, what i just read from "Rolling with web2py". Thanks.
On Nov 14, 7:36 pm, mdipierro <[EMAIL PROTECTED]> wrote:
> in define_table(....) you need to set define_table(....,migrate=False)
> and it will not try to recreate the table if it exist.
> web2py only known is a table exist if web2py created it.
>
> Massimo
>
> On Nov 14, 2:24 am, mmstud <[EMAIL PROTECTED]> wrote:
>
> > I dont know how this should be, but in my case, i have a table
> > 'Members' already created on database having inserted rows and data to
> > use in my application. But when i try 'database administration' it
> > seems web2py tries to create a new table, although i think it should
> > just see, if table definition matches table in db.
>
> > I countered this problem again, when changed mysql://user:pass to
> > db.py... when i changed back to previous connection string, everything
> > worked again.
>
> > -Marko
>
> > Traceback (most recent call last):
> > File "/home/.../tmp/web2py/gluon/restricted.py", line 62, in
> > restricted
> > exec ccode in environment
> > File "/home/.../tmp/web2py/applications/app/models/db.py", line 49,
> > in <module>
> > SQLField('Memo','text')
> > File "/home/.../tmp/web2py/gluon/sql.py", line 540, in define_table
> > raise e
> > OperationalError: (1050, "Table 'Members' already exists")
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
