Restore backup problem about nextbackup HOT 9 CLOSED

It worked. That was a lifesaver. Thanks so much!
For anyone with the same problem: Changing <field><name>calendardata</name></field> to <field><name>calendardata</name><type>clob</type><notnull>false</notnull></field> fixed the restore problem for me.

from nextbackup.

It took me several hours to reverse engineer that back then, I'm glad my findings were of use to you. 😄

from nextbackup.

Doesn't ring any bell for me... ownbackup uses the internal ownCloud api to store and restore tables, maybe the api doesn't recognises some data.

from nextbackup.

Thanks for the quick response. So - no hints on where to go from here?

from nextbackup.

Once someone had troubles with longblob fields, I posted that as ownCloud issue at owncloud/core#25316.

from nextbackup.

Hm, that looks a lot like my error. That means I'm out of luck for now. Is there a way to extract the backup to a format I can work with manually?

from nextbackup.

If you had the problem from the issue you could try to edit your data/ownbackup/1489393802/oc_calendarobjects/structure.xml (use your timestamp instead of 1489393802) and set the longblob field to something like <type>clob</type><notnull>false</notnull>.

Other than that you would have to consult ownCloud for their (private) api...

from nextbackup.

Not that I can really break more at this point, but could you tell me exactly which tag to change, please?
Here's the full error:

Table(s) could not be restored: Inserting data row failed: An exception occurred while executing 'INSERT INTO oc_calendarobjects (id,calendardata,uri,calendarid,lastmodified,etag,size,componenttype,firstoccurence,lastoccurence,uid) SELECT ?,?,?,?,?,?,?,?,?,?,? FROM oc_calendarobjectsWHEREid= ? ANDcalendardata= ? ANDuri= ? ANDcalendarid= ? ANDlastmodified= ? ANDetag= ? ANDsize= ? ANDcomponenttype= ? ANDfirstoccurence= ? ANDlastoccurence= ? ANDuid = ? HAVING COUNT(*) = 0' with params [...CALENDAR ENTRY HERE...]: Column not found: 1054 Unknown column 'calendardata' in 'where clause'

Thanks for all your help and best regards from Vienna to Graz.

from nextbackup.

Ah, sorry. I didn't read carefully enough. I'll report back.

from nextbackup.