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

-- 



Reply via email to