-
Type: Bug
-
Status: Resolved
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.6.0-HF25, 5.8
-
Component/s: Nuxeo Drive
-
Backlog priority:980
Since new columns have been added to the device_config table:
> lessmsi\lessmsi /x dist\nuxeo-drive-1.2013.0926-win32.msi nxdrive_msi 19:45:00 Extracting 'C:\Jenkins\workspace\IT-nuxeo-drive-5.6.0-windows\dist\nuxeo-drive-1.2013.0926-win32.msi' to 'C:\Jenkins\workspace\IT-nuxeo-drive-5.6.0-windows\nxdrive_msi'. 19:45:00 > nxdrive_msi\SourceDir\ndrive.exe test 19:45:00 Traceback (most recent call last): 19:45:00 File "C:\Python27\lib\site-packages\cx_Freeze\initscripts\Console.py", line 27, in <module> 19:45:00 exec code in m.__dict__ 19:45:00 File "nuxeo-drive-client/scripts/ndrive", line 6, in <module> 19:45:00 sys.exit(main()) 19:45:00 File "nuxeo-drive-client\nxdrive\commandline.py", line 489, in main 19:45:00 return CliHandler().handle(argv) 19:45:00 File "nuxeo-drive-client\nxdrive\commandline.py", line 309, in handle 19:45:00 timeout=options.timeout) 19:45:00 File "nuxeo-drive-client\nxdrive\controller.py", line 103, in __init__ 19:45:00 device_config = self.get_device_config() 19:45:00 File "nuxeo-drive-client\nxdrive\controller.py", line 129, in get_device_config 19:45:00 return session.query(DeviceConfig).one() 19:45:00 File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\orm\query.py", line 2184, in one 19:45:00 ret = list(self) 19:45:00 File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\orm\query.py", line 2227, in __iter__ 19:45:00 return self._execute_and_instances(context) 19:45:00 File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\orm\query.py", line 2242, in _execute_and_instances 19:45:00 result = conn.execute(querycontext.statement, self._params) 19:45:00 File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\base.py", line 1449, in execute 19:45:00 params) 19:45:00 File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\base.py", line 1584, in _execute_clauseelement 19:45:00 compiled_sql, distilled_params 19:45:00 File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\base.py", line 1698, in _execute_context 19:45:00 context) 19:45:00 File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\base.py", line 1691, in _execute_context 19:45:00 context) 19:45:00 File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\default.py", line 331, in do_execute 19:45:00 cursor.execute(statement, parameters) 19:45:00 sqlalchemy.exc.OperationalError: (OperationalError) no such column: device_config.proxy_config u'SELECT device_config.device_id AS device_config_device_id, device_config.proxy_config AS device_config_proxy_config, device_config.proxy_type AS device_config_proxy_type, device_config.proxy_server AS device_config_proxy_server, device_config.proxy_port AS device_config_proxy_port, device_config.proxy_authenticated AS device_config_proxy_authenticated, device_config.proxy_username AS device_config_proxy_username, device_config.proxy_password AS device_config_proxy_password, device_config.proxy_exceptions AS device_config_proxy_exceptions \nFROM device_config' () 19:45:00 Command nxdrive_msi\SourceDir\ndrive.exe test returned with code 1
- depends on
-
NXP-12694 Drive: handle SQLite DB auto upgrade
- Resolved