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
-~----------~----~----~----~------~----~------~--~---
