Galeria systemowa nagle przestała działać

[taki_jeden]

Galeria uruchamia się i po sekundzie wyłącza. 

Telefon Mi 9 SE

System miuipolska stable V12.0.3.0.QFBCNXM

Próbowałem czyścić dane aplikacji, restart systemu i nic nie pomaga. 

Kod błędu:

Spoiler

java.lang.RuntimeException: An error occurred while executing doInBackground()
    at android.os.AsyncTask$4.done(Unknown Source:27)
    at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:383)
    at java.util.concurrent.FutureTask.setException(FutureTask.java:252)
    at java.util.concurrent.FutureTask.run(FutureTask.java:271)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
    at java.lang.Thread.run(Thread.java:919)
Caused by: org.sqlite.database.sqlite.SQLiteException: no such table: extended_cloud (code 1): , while compiling: SELECT _id, name, cover_id, cover_path, cover_sha1, cover_sync_state, media_count, face_people_id, baby_info, thumbnail_info, serverId, attributes, immutable, top_time, sortBy, baby_sharer_info, local_path, cover_size, sort_position, datemodified FROM (SELECT * FROM (SELECT _id AS _id, attributes AS attributes, fileName AS name, localFile AS local_path, localFlag AS flag, dateTaken AS top_time, peopleId AS face_people_id, babyInfoJson AS baby_info, NULL AS baby_sharer_info, serverId AS serverId, thumbnailInfo AS thumbnail_info, sort_position AS sort_position, CASE WHEN sortBy IS NULL THEN CASE WHEN dateTaken >0 THEN 9223372036854775807 - dateTaken ELSE dateTaken END ELSE sortBy END AS sortBy, CASE WHEN localFile LIKE '/%' THEN 1 ELSE 0 END AS immutable, datemodified FROM cloud WHERE (serverType=0) AND (localFlag IS NULL OR localFlag NOT IN (11, 0, -1, 2, 15) OR (localFlag=0 AND (serverStatus='custom' OR serverStatus = 'recovery'))) AND (attributes & 16 = 0) AND (attributes & 2048 = 0)) LEFT JOIN (SELECT localGroupId AS _id, count(_id) AS media_count, _id AS cover_id, ( CASE WHEN (microthumbfile NOT NULL and microthumbfile != '') THEN microthumbfile WHEN (thumbnailFile NOT NULL and thumbnailFile != '') THEN thumbnailFile ELSE localFile END ) AS cover_path, sha1 AS cover_sha1,  CASE WHEN localFlag = 0  THEN 0 WHEN localFlag IN (5, 6, 9) THEN 1 ELSE 3 END  AS cover_sync_state, size AS cover_size, max(CASE WHEN localGroupId IN (SELECT _id FROM cloud WHERE localFile COLLATE NOCASE IN ('pictures/screenshots', 'dcim/camera', 'dcim/screenrecorder') AND (serverType=0)) THEN  CASE WHEN mixedDateTime NOT NULL THEN mixedDateTime ELSE dateTaken END  ELSE (dateModified) END) AS latest_photo , 0 AS size FROM (SELECT * FROM cloud ORDER BY mixedDateTime DESC,dateModified DESC,_id DESC ) cloud WHERE (localFlag IS NULL OR localFlag NOT IN (11, 0, -1, 2, 15) OR (localFlag=0 AND (serverStatus='custom' OR serverStatus = 'recovery'))) GROUP BY localGroupId) USING (_id) UNION SELECT * FROM (SELECT 2147383647+_id AS _id, attributes AS attributes, sharealbum.fileName AS name, NULL AS local_path, localFlag AS flag, dateTaken AS top_time, peopleId AS face_people_id, babyInfoJson AS baby_info, sharerInfo AS baby_sharer_info, serverId AS serverId, NULL AS thumbnail_info, sort_position AS sort_position, CASE WHEN sortBy IS NULL THEN CASE WHEN dateTaken >0 THEN 9223372036854775807 - dateTaken ELSE dateTaken END ELSE sortBy END AS sortBy, 0 AS immutable, datemodified AS datemodified FROM shareAlbum WHERE serverId IS NOT NULL AND (attributes & 16 = 0)) LEFT JOIN (SELECT 2147383647+localGroupId AS _id, count(_id) AS media_count, 33554431+_id AS cover_id, ( CASE WHEN (microthumbfile NOT NULL and microthumbfile != '') THEN microthumbfile WHEN (thumbnailFile NOT NULL and thumbnailFile != '') THEN thumbnailFile ELSE localFile END ) AS cover_path, sha1 AS cover_sha1,  CASE WHEN localFlag = 0  THEN 0 WHEN localFlag IN (5, 6, 9) THEN 1 ELSE 3 END  AS cover_sync_state, size AS cover_size, max(dateModified) AS latest_photo , 0 AS size FROM shareImage WHERE (localFlag IS NULL OR localFlag NOT IN (11, 0, -1, 2, 15) OR (localFlag=0 AND (serverStatus='custom' OR serverStatus = 'recovery'))) GROUP BY localGroupId) USING (_id)  UNION SELECT 2147483647 AS _id, 0 AS attributes, 'VIDEO' AS name, NULL AS local_path, 0 AS flag, -998 AS top_time, NULL AS face_people_id, NULL AS baby_info, NULL AS baby_sharer_info, '-2147483647' AS serverId, NULL AS thumbnail_info, -998 AS sort_position , -998 AS sortBy, 0 AS immutable,  -998 AS datemodified  , count(_id) AS media_count , _id AS cover_id, ( CASE WHEN (microthumbfile NOT NULL and microthumbfile != '') THEN microthumbfile WHEN (thumbnailFile NOT NULL and thumbnailFile != '') THEN thumbnailFile ELSE localFile END ) AS cover_path, sha1 AS cover_sha1,  CASE WHEN localFlag = 0  THEN 0 WHEN localFlag IN (5, 6, 9) THEN 1 ELSE 3 END  AS cover_sync_state, size AS cover_size, max(dateModified) AS latest_photo  , 0 AS size FROM (SELECT * FROM cloud ORDER BY mixedDateTime DESC,dateModified DESC,_id DESC ) cloud WHERE serverType=2 AND (localFlag IS NULL OR localFlag NOT IN (11, 0, -1, 2, 15) OR (localFlag=0 AND (serverStatus='custom' OR serverStatus = 'recovery'))) AND (localGroupId!=-1000) AND (localGroupId in (SELECT _id FROM cloud WHERE (attributes & 16 = 0 ) AND  NOT (  ( attributes & 2048 <> 0)) ))   UNION SELECT 2147483644 AS _id, 0 AS attributes, 'ALL_PHOTOS' AS name, NULL AS local_path, 0 AS flag, -1001 AS top_time, NULL AS face_people_id, NULL AS baby_info, NULL AS baby_sharer_info, '-2147483644' AS serverId, NULL AS thumbnail_info, -1001 AS sort_position, -1001 AS sortBy, 0 AS immutable, -1001 AS datemodified  , count(_id) AS media_count , _id AS cover_id, ( CASE WHEN (microthumbfile NOT NULL and microthumbfile != '') THEN microthumbfile WHEN (thumbnailFile NOT NULL and thumbnailFile != '') THEN thumbnailFile ELSE localFile END ) AS cover_path, sha1 AS cover_sha1,  CASE WHEN localFlag = 0  THEN 0 WHEN localFlag IN (5, 6, 9) THEN 1 ELSE 3 END  AS cover_sync_state, size AS cover_size, max(dateModified) AS latest_photo  , 0 AS size FROM (SELECT _id AS _id, sha1, localFlag, dateModified, serverStatus, localGroupId, thumbnailFile, microthumbfile, localFile, serverType, size, babyInfoJson FROM (SELECT * FROM cloud ORDER BY dateModified DESC,mixedDateTime DESC,_id DESC ) cloud) WHERE (localFlag IS NULL OR localFlag NOT IN (11, 0, -1, 2, 15) OR (localFlag=0 AND (serverStatus='custom' OR serverStatus = 'recovery'))) AND (localGroupId!=-1000) AND ( localGroupId NOT IN  ( select _id from cloud where  ( attributes & 2048 <> 0))) AND (localGroupId in (SELECT _id FROM cloud WHERE (attributes & 16 = 0 ) AND  NOT (  ( attributes & 2048 <> 0)) ))  UNION SELECT 2147483642 AS _id, 0 AS attributes, 'FAVORITES' AS name, NULL AS local_path, 0 AS flag, -1000 AS top_time, NULL AS face_people_id, NULL AS baby_info, NULL AS baby_sharer_info, '-2147483642' AS serverId, NULL AS thumbnail_info, -1000 AS sort_position, -1000 AS sortBy, 0 AS immutable, -1000 AS datemodified  , count(_id) AS media_count , _id AS cover_id, ( CASE WHEN (microthumbfile NOT NULL and microthumbfile != '') THEN microthumbfile WHEN (thumbnailFile NOT NULL and thumbnailFile != '') THEN thumbnailFile ELSE localFile END ) AS cover_path, sha1 AS cover_sha1,  CASE WHEN localFlag = 0  THEN 0 WHEN localFlag IN (5, 6, 9) THEN 1 ELSE 3 END  AS cover_sync_state, size AS cover_size, max(dateModified) AS latest_photo  , 0 AS size FROM extended_cloud WHERE (localFlag IS NULL OR localFlag NOT IN (11, 0, -1, 2, 15) OR (localFlag=0 AND (serverStatus='custom' OR serverStatus = 'recovery'))) AND (localGroupId!=-1000) AND (serverType IN (1,2) AND isFavorite NOT NULL AND isFavorite > 0)  AND (localGroupId in (SELECT _id FROM cloud WHERE (attributes & 16 = 0 ) AND  NOT (  ( attributes & 2048 <> 0)) )) ) WHERE (media_count > 0 OR serverId IS NULL OR serverId NOT IN (-2147483647,-2147483645,-2147483644,-2147483646,1,2,-2147483642,-2147483643,1000,4,2147483647,2147483646,2147483645,2147483644,2147483643,2147483642)) AND ( NOT (  ( attributes & 2048 <> 0)) AND (attributes & 16 = 0 ) AND (attributes & 64 = 0))
    at org.sqlite.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    at org.sqlite.database.sqlite.SQLiteConnection.acquirePreparedStatement(Unknown Source:21)
    at org.sqlite.database.sqlite.SQLiteConnection.prepare(Unknown Source:11)
    at org.sqlite.database.sqlite.SQLiteSession.prepare(Unknown Source:12)
    at org.sqlite.database.sqlite.SQLiteProgram.<init>(Unknown Source:47)
    at org.sqlite.database.sqlite.SQLiteQuery.<init>(Unknown Source:1)
    at org.sqlite.database.sqlite.SQLiteDirectCursorDriver.query(Unknown Source:8)
    at org.sqlite.database.sqlite.SQLiteDatabase.rawQueryWithFactory(Unknown Source:13)
    at org.sqlite.database.sqlite.SQLiteDatabase.queryWithFactory(Unknown Source:28)
    at org.sqlite.database.sqlite.SQLiteDatabase.query(Unknown Source:19)
    at com.miui.gallery.provider.AlbumManager.query(Unknown Source:431)
    at com.miui.gallery.provider.GalleryProvider.query(Unknown Source:859)
    at android.content.ContentProvider.query(Unknown Source:45)
    at android.content.ContentProvider$Transport.query(Unknown Source:98)
    at android.content.ContentResolver.query(Unknown Source:77)
    at android.content.ContentResolver.query(Unknown Source:4)
    at android.content.CursorLoader.loadInBackground(Unknown Source:36)
    at android.content.CursorLoader.loadInBackground(Unknown Source:0)
    at android.content.AsyncTaskLoader.onLoadInBackground(Unknown Source:0)
    at android.content.AsyncTaskLoader$LoadTask.doInBackground(Unknown Source:2)
    at android.content.AsyncTaskLoader$LoadTask.doInBackground(Unknown Source:2)
    at android.os.AsyncTask$3.call(Unknown Source:20)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    ... 3 more

 

Edytowane 20 Marca 2021 przez taki_jeden