probably your .table files weren't in sync with your model. web2py issues a
CREATE statement only if the corresponding .table file is not found into
the databases/ folder (implicating that that table doesn't exist on the
backend)
On Sunday, September 29, 2013 2:06:50 AM UTC+2, PN wrote:
>
> Version: Using web2py 2.6.4
>
> Steps:
> ====
> 1. I used web2py DAL to create a table in ms sql. This ran in production
> for a while.
>
> 2. I downloaded the web2py app to my development machine, and added a
> column to the table in DAL.
>
> 3. When I try to go to the table in web2py admin (database administration)
> with migrate=True, I get an error message "<class
> 'pyodbc.ProgrammingError'> ('42S01', "[42S01] [Microsoft][ODBC SQL Server
> Driver][SQL Server]There is already an object named 'BIG_Mapping' in the
> database. (2714) (SQLExecDirectW)")
>
> 4. The error message shows that web2py is issuing a CREATE command, not
> the ALTER command (in the error log)
>
> Any suggestions on further troubleshooting? I can alter the table manually
> but wanted to test migrations through DAL so I understand them for future
> reference.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
