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.
