Nextcloud – prepare Sqlite prepare statement error: „unknown function: parent_hash()“

Chyba

Po spuštění nextcloud desktop zhavaruje. V logu se zobrazí chyba Sqlite: OCC::SqlQuery::prepare Sqlite prepare statement error: „unknown function: parent_hash()“.

Log

~$ nextcloud –logfile nextcloud.log –logdebug

~$ tail nextcloud.log
[_csync_merge_algorithm_visitor INSTRUCTION_REMOVE server file: Pub/file1.txt
[_csync_merge_algorithm_visitor INSTRUCTION_NEW server file: Pub/file2.txt
[csync_reconcile Reconciliation for remote replica took 0.004 seconds visiting 4341 files.
[OCC::SyncEngine::slotDiscoveryJobFinished #### Reconcile end #################################################### 5311 ms
[OCC::SyncJournalDb::setFileRecord Updating file record for path: „Photos/_blbosti/295325545_1714579932268475_1551043425739988477_n.jpg“ inode: 10229524 modtime: 1658725500 type: 0 etag: „d181993a5c938a3b2697520846c0e9ca“ fileId: „00034610ocpyssxlpzl5“ remotePerm: „WDNVR“ fileSize: 59189 checksum: „“ e2eMangledName: „“
[OCC::SqlQuery::prepare Sqlite prepare statement error: „unknown function: parent_hash()“ in „INSERT OR REPLACE INTO metadata (phash, pathlen, path, inode, uid, gid, mode, modtime, type, md5, fileid, remotePerm, filesize, ignoredChildrenRemote, contentChecksum, contentChecksumTypeId, e2eMangledName) VALUES (?1 , ?2, ?3 , ?4 , ?5 , ?6 , ?7, ?8 , ?9 , ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17);“
[OCC::SqlQuery::prepare ENFORCE: „allow_failure“ in file /build/nextcloud-desktop-uiwzX5/nextcloud-desktop-2.6.2/src/common/ownsql.cpp, line 269 with message: SQLITE Prepare error
~$

Řešení

~$
~$ cd ~/Nextcloud
~/Nextcloud$ ll .*.db
-rw-r–r– 1 posmura users 1912832 čec 13 15:36 .sync_2e00312fcdb7.db
~/Nextcloud$ sqlite3 .sync_2e00312fcdb7.db „DROP INDEX metadata_parent“
~/Nextcloud$