So, in theory, will the following process fix the issue?
1. Start web2py with old DAL definitions and migrate = True. This should
create the .table files as the old structure
2. Then change the DAL to reflect the new database structure, migrate still
= True
3. Restart web2py and my tables should get migrated?
On Sunday, September 29, 2013 7:45:32 AM UTC-4, Niphlod wrote:
>
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
