Database conversion get failed on Owncloud 10.0.2


#1

Hi,

I am getting the below error when I am doing database conversion from sqlite3 to mysql.

[Doctrine\DBAL\Exception\InvalidFieldNameException]
An exception occurred while executing 'INSERT INTO oc_jobs (id, class
, argument, last_run, last_checked, reserved_at, execution_duratio
n
) VALUES(?, ?, ?, ?, ?, ?, ?)' with params ["1", "OCA\Federation\SyncJo
b", "null", "1490665470", "1500936026", "1500936026", "-1"]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'execution_duration'
in 'field list'

[PDOException]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'execution_duration'
in 'field list'


#2

I think i have read somewhere that such a conversion is not working at all in owncloud 10


#3

So, there is no other way to convert database.


#4

Can anybody give some guidance in which files the conversion function is hiding? Would like to convert as well and as today is mid of April 2018 and this issue has been open for almost a year, I assume nobody wants to look at it.

Once I know where to look for it, I will gladly spend some time and share potential results with the community.


#5

I found that in the meantime but completely forgot to post it here: :confused:

To me it looks like some one is already working on it and from what i understand there are just some testers for this: