{"id":12215,"date":"2021-05-28T08:13:58","date_gmt":"2021-05-28T08:13:58","guid":{"rendered":"http:\/\/blog.bachi.net\/?p=12215"},"modified":"2021-05-28T08:14:36","modified_gmt":"2021-05-28T08:14:36","slug":"ownclound-switchdrive","status":"publish","type":"post","link":"https:\/\/blog.bachi.net\/?p=12215","title":{"rendered":"ownClound \/ SWITCHdrive"},"content":{"rendered":"

CSync unspecified error<\/h1>\n
\r\nc:\\Program Files (x86)\\switchdrive>switchdrive.exe --logfile c:\\Users\\andreas\\switchdrive_2021_05_28_2.txt\r\n\r\n[...]\r\n05-28 09:44:50:164 [ warning sync.database.sql ]:\tSqlite step statement error: 11 "database disk image is malformed" in "SELECT path, inode, modtime, type, md5, fileid, remotePerm, filesize,  ignoredChildrenRemote, contentchecksumtype.name || ':' || contentChecksum FROM metadata  LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"\r\n05-28 09:44:50:164 [ warning sync.database ]:\tNo journal entry found for  "ZHAW_Assistent\/FotoFinder\/BA19_bmat_02_CoolingStation\/2.Recherche\/files\/104\/icon-instagram.svg" Error:  "database disk image is malformed"\r\n05-28 09:44:50:164 [ info sync.database ]:\tClosing DB "C:\/Users\/andreas\/switchdrive\/._sync_1f3ce89cbf1f.db"\r\n05-28 09:44:50:166 [ warning sync.engine ]:\tERROR during  csync_update :  "CSync unspecified error."\r\n05-28 09:44:50:182 [ info sync.database ]:\tClosing DB "C:\/Users\/andreas\/switchdrive\/._sync_1f3ce89cbf1f.db"\r\n05-28 09:44:50:182 [ info sync.engine ]:\tCSync run took  7183 ms\r\n05-28 09:44:50:182 [ info gui.socketapi ]:\tSending SocketAPI message --> "STATUS:OK:C:\\\\Users\\\\andreas\\\\switchdrive" to QLocalSocket(0x93bb298)\r\n05-28 09:44:50:182 [ info gui.folder ]:\tClient version 2.5.4daily20190604 (build 1865)  Qt 5.11.2  SSL  OpenSSL 1.1.1  11 Sep 2018\r\n05-28 09:44:50:182 [ warning gui.folder ]:\tSyncEngine finished with ERROR\r\n05-28 09:44:50:182 [ info gui.folder ]:\tFolder sync result:  2\r\n05-28 09:44:50:182 [ info gui.folder ]:\tthe last 3 syncs failed\r\n05-28 09:44:50:182 [ info gui.socketapi ]:\tSending SocketAPI message --> "STATUS:OK:C:\\\\Users\\\\andreas\\\\switchdrive" to QLocalSocket(0x93bb298)\r\n05-28 09:44:50:183 [ info gui.socketapi ]:\tSending SocketAPI message --> "UPDATE_VIEW:C:\\\\Users\\\\andreas\\\\switchdrive" to QLocalSocket(0x93bb298)\r\n<\/pre>\n
ownCloud Client Manual – Appendix C: Troubleshooting<\/a>
\nOwncloud Datenbank-Probleme<\/a><\/p>\n
Download sqlite3: SQLite Download Page<\/a>, sqlite-tools-win32-x86-3350500.zip<\/p>\n
SQLite Commands<\/a>
\nCommand Line Shell For SQLite<\/a><\/p>\n
\r\nC:\\Users\\andreas\\switchdrive>c:\\sqlite-tools-win32-x86-3350500\\sqlite3.exe C:\/Users\/andreas\/switchdrive\/._sync_1f3ce89cbf1f.db\r\nSQLite version 3.35.5 2021-04-19 18:32:05\r\nEnter ".help" for usage hints.\r\n\r\nsqlite> PRAGMA integrity_check;\r\nrow 39975 missing from index sqlite_autoindex_metadata_1\r\n\r\nsqlite> reindex;\r\n\r\nsqlite> PRAGMA integrity_check;\r\nok\r\n\r\nsqlite> .exit\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
CSync unspecified error c:\\Program Files (x86)\\switchdrive>switchdrive.exe –logfile c:\\Users\\andreas\\switchdrive_2021_05_28_2.txt […] 05-28 09:44:50:164 [ warning sync.database.sql ]: Sqlite step statement error: 11 "database disk image is malformed" in "SELECT path, inode, modtime, type, md5, fileid, remotePerm, filesize, ignoredChildrenRemote, contentchecksumtype.name || ‘:’ || contentChecksum FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1" 05-28 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-12215","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/12215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12215"}],"version-history":[{"count":2,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/12215\/revisions"}],"predecessor-version":[{"id":12217,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/12215\/revisions\/12217"}],"wp:attachment":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}