I've made an app using the scheduler on version 1.99.7 under windows (source distribution). In another directory I have 2.0.9 I copied the folder containing my applicatoin into the 2.0.9 folder hierarchy, also in the applications folder. I start a new server for 2.0.9 on its own port. When I go to the URL for my application under 2.0.9 I immediately get a ticket Is this approach to upgrading wrong?
----------- <class 'sqlite3.OperationalError'> Cannot add a UNIQUE column Version web2py™ (2, 0, 9, datetime.datetime(2012, 9, 13, 23, 51, 30), 'stable') Traceback (most recent call last): File "D:\web2py2X\gluon\restricted.py", line 209, in restricted exec ccode in environment File "D:/web2py2X/applications/accpac_web_orders/models/my_scheduler.py", line 79, in <module> myscheduler = Scheduler(db,dict(import_task_add=import_task_add)) File "D:\web2py2X\gluon\scheduler.py", line 431, in __init__ self.define_tables(db,migrate=migrate) File "D:\web2py2X\gluon\scheduler.py", line 475, in define_tables migrate=migrate,format='%(task_name)s') File "D:\web2py2X\gluon\dal.py", line 7095, in define_table table = self.lazy_define_table(tablename,*fields,**args) File "D:\web2py2X\gluon\dal.py", line 7126, in lazy_define_table polymodel=polymodel) File "D:\web2py2X\gluon\dal.py", line 933, in create_table fake_migrate=fake_migrate) File "D:\web2py2X\gluon\dal.py", line 1039, in migrate_table self.execute(sub_query) File "D:\web2py2X\gluon\dal.py", line 1671, in execute return self.log_execute(*a, **b) File "D:\web2py2X\gluon\dal.py", line 1665, in log_execute ret = self.cursor.execute(*a, **b) OperationalError: Cannot add a UNIQUE column --