logilab-database #78890 help cw do its 3.18 migration [rejected]

Upgrading the instance PYRENE_LAB
---------------------------------
-> migration needed from 0.13.0 to 0.13.1 for pylos
-> migration needed from 3.13.7 to 3.13.8 for cubicweb
Backup PYRENE_LAB database? [Y/n/a(bort)/s(hell)]: n
-> no backup done.
Execute '\\\\NL1GRP1.melinda.local\\PYL001A\\Labo\\Pyrene\\cubicweb\\misc\\migra
tion\\bootstrapmigration_repository.py' ? [Y/n/s(how)/a(bort)]:
Execute '\\\\NL1GRP1.melinda.local\\PYL001A\\Labo\\Pyrene\\cubicweb\\misc\\migra
tion\\3.13.8_Any.py' ? [Y/n/s(how)/a(bort)]:
Execute command: change_attribute_type('CWCache', 'timestamp', 'TZDatetime') ? [
Y/n/a(bort)/s(hell)]:
Error: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]
Incorrect syntax near 'datetime'. (102) (SQLExecDirectW)")
abort? [Y/n/a(bort)/p(db)/s(hell)]:
Traceback (most recent call last):
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\cwctl.py", line 165
, in run_arg
status = cmdmeth(appid)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\cwctl.py", line 766
, in upgrade_instance
mih.migrate(vcconf, reversed(toupgrade), self.config)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\server\migractions.
py", line 148, in migrate
super(ServerMigrationHelper, self).migrate(vcconf, toupgrade, options)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\migration.py", line
180, in migrate
self.cmd_process_script(script)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\server\migractions.
py", line 153, in cmd_process_script
migrscript, funcname, *args, **kwargs)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\migration.py", line
346, in cmd_process_script
execfile(migrscript, scriptlocals)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\misc\migration\3.13
.8_Any.py", line 1, in <module>
change_attribute_type('CWCache', 'timestamp', 'TZDatetime')
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\migration.py", line
136, in <lambda>
meth=meth)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\migration.py", line
202, in interact
return meth(*args, **kwargs)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\server\migractions.
py", line 1556, in cmd_change_attribute_type
self.sqlexec(sql, ask_confirm=False)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\server\migractions.
py", line 1499, in sqlexec
cu = self.session.system_sql(sql, args)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\server\session.py",
line 445, in system_sql
return source.doexec(self, sql, args, rollback=rollback_on_failure)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\cubicweb\server\sources\nati
ve.py", line 744, in doexec
cursor.execute(str(query), args)
File "\\NL1GRP1.melinda.local\PYL001A\Labo\Pyrene\logilab\database\sqlserver.p
y", line 109, in execute
self._cursor.execute(sql)
ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][
SQL Server]Incorrect syntax near 'datetime'. (102) (SQLExecDirectW)")
instance PYRENE_LAB not upgraded: ('42000', "[42000] [Microsoft][SQL Server Nati
ve Client 10.0][SQL Server]Incorrect syntax near 'datetime'. (102) (SQLExecDirec
tW)")

prioritynormal
typebug
done in1.7.0
load0.000
load left0.000
closed by<not specified>