Android 2.2.32 camera upload failed

2021-05-14 11:17:30 d Utils phoneModelInfo-------POCO/M2007J20CG/10
2021-05-14 11:19:40 d Utils ==========start
2021-05-14 11:19:40 d Utils ========Starting to upload images…
2021-05-14 11:19:41 d Utils ==========end

I used the auto select to upload.

If I try to select some folders I see:

2021-05-14 11:32:15 d Utils phoneModelInfo-------POCO/M2007J20CG/10
2021-05-14 11:32:16 d Utils ========Starting to upload images…
2021-05-14 11:32:53 d Utils ==========start
2021-05-14 11:32:53 d Utils ========Starting to upload images…
2021-05-14 11:32:53 d Utils ===i see 1773 images.

And some minutes later:

2021-05-14 11:17:30 d Utils phoneModelInfo-------POCO/M2007J20CG/10
2021-05-14 11:19:40 d Utils ==========start
2021-05-14 11:19:40 d Utils ========Starting to upload images…
2021-05-14 11:19:41 d Utils ==========end
2021-05-14 11:27:12 d Utils ========Starting to upload images…
2021-05-14 11:28:16 d Utils ==========start
2021-05-14 11:28:16 d Utils ========Starting to upload images…
2021-05-14 11:28:16 d Utils ==========end
2021-05-14 11:32:15 d Utils phoneModelInfo-------POCO/M2007J20CG/10
2021-05-14 11:32:16 d Utils ========Starting to upload images…
2021-05-14 11:32:53 d Utils ==========start
2021-05-14 11:32:53 d Utils ========Starting to upload images…
2021-05-14 11:32:53 d Utils ===i see 1773 images.
2021-05-14 11:41:47 d Utils =======uploadFile===
2021-05-14 11:41:47 d Utils ====File IMG_20210426_092304.jpg in bucket Camera already exists on the server. Skipping.
2021-05-14 11:41:47 d Utils =======uploadFile===
2021-05-14 11:41:47 d Utils ====File IMG_20210427_221736.jpg in bucket Camera already exists on the server. Skipping.
2021-05-14 11:41:47 d Utils =======uploadFile===
2021-05-14 11:41:47 d Utils ====File IMG_20210507_201011.jpg in bucket Camera already exists on the server. Skipping.
2021-05-14 11:41:47 d Utils =======waitForUploads===
2021-05-14 11:41:47 d Utils Starting to upload videos…
2021-05-14 11:41:47 d Utils =====i see 40 videos.
2021-05-14 11:42:53 d Utils ==========end
2021-05-14 11:42:53 d Utils ==========start
2021-05-14 11:42:53 d Utils ========Starting to upload images…
2021-05-14 11:42:53 d Utils ===i see 3054 images.
2021-05-14 11:46:30 d Utils ==========end
2021-05-14 11:46:30 d Utils ==========start
2021-05-14 11:46:30 d Utils ========Starting to upload images…
2021-05-14 11:46:30 d Utils ===i see 3054 images.
2021-05-14 11:49:20 d Utils ==========end
2021-05-14 11:49:26 d Utils ==========start
2021-05-14 11:49:27 d Utils ========Starting to upload images…
2021-05-14 11:49:27 d Utils ===i see 3054 images.
2021-05-14 11:56:12 d Utils ==========end
2021-05-14 11:56:36 d Utils ==========start
2021-05-14 11:56:36 d Utils ========Starting to upload images…
2021-05-14 11:56:36 d Utils ===i see 3054 images.

Thanks in advance

oh, sorry, i totally missed this.

my log looks almost the same, i.e. it’s a long repeating list of blocks like these:

2021-05-30 05:04:50 d Utils ========Starting to upload images…
2021-05-30 05:04:50 d Utils ===i see 2298 images.
2021-05-30 06:11:10 d Utils ========Starting to upload images…
2021-05-30 06:11:10 d Utils ===i see 2298 images.
2021-05-30 07:27:44 d Utils ========Starting to upload images…
2021-05-30 07:27:44 d Utils ===i see 2298 images.

there’s no start or end messages, though. but also no errors, just occasional messages announcing the phone model.

@daniel.pan welp, it doesn’t work on mine

2021-06-01 21:07:46    d    Utils    phoneModelInfo-------Xiaomi/Mi 9 Lite/10
2021-06-01 21:07:47    d    Utils    ========Starting to upload images...
2021-06-01 21:07:47    d    Utils    ===i see 18365 images.
2021-06-01 21:10:25    d    Utils    ==========end
2021-06-01 21:12:56    d    Utils    ==========start
2021-06-01 21:12:57    d    Utils    ========Starting to upload images...
2021-06-01 21:12:57    d    Utils    ===i see 18365 images.
2021-06-01 21:14:48    d    Utils    ==========end
2021-06-01 21:14:48    d    Utils    ==========start
2021-06-01 21:14:49    d    Utils    ========Starting to upload images...
2021-06-01 21:14:49    d    Utils    ===i see 18365 images.

I’m seeing the same problem. I started on 2.2.34, then upgraded to 2.2.36 from GitHub releases. Either way things seem stuck in a loop of scanning and claiming the sync finished even though I have plenty of new pictures. Here are my logs:

2021-06-02 10:43:18    d    Utils    phoneModelInfo-------OnePlus/IN2013/11
2021-06-02 10:43:28    d    Utils    phoneModelInfo-------OnePlus/IN2013/11
2021-06-02 10:45:24    d    Utils    ==========start
2021-06-02 10:45:24    d    Utils    ========Starting to upload images...
2021-06-02 10:45:25    d    Utils    ===i see 8927 images.
2021-06-02 10:55:24    d    Utils    ==========end
2021-06-02 10:56:29    d    Utils    ==========start
2021-06-02 10:56:30    d    Utils    ========Starting to upload images...
2021-06-02 10:56:30    d    Utils    ===i see 8927 images.
2021-06-02 11:00:50    d    Utils    ==========end
2021-06-02 11:08:11    d    Utils    ==========start
2021-06-02 11:08:12    d    Utils    ========Starting to upload images...
2021-06-02 11:08:12    d    Utils    ===i see 8927 images.
2021-06-02 11:08:16    d    Utils    ==========end
2021-06-02 11:13:01    d    Utils    ==========start
2021-06-02 11:13:02    d    Utils    ========Starting to upload images...
2021-06-02 11:13:02    d    Utils    ===i see 8927 images.
2021-06-02 11:17:02    d    Utils    ==========end
2021-06-02 11:25:14    d    Utils    ==========start
2021-06-02 11:25:15    d    Utils    ========Starting to upload images...
2021-06-02 11:25:15    d    Utils    ===i see 8927 images.
2021-06-02 11:25:19    d    Utils    ==========end
2021-06-02 11:35:21    d    Utils    ==========start
2021-06-02 11:35:22    d    Utils    ========Starting to upload images...
2021-06-02 11:35:22    d    Utils    ===i see 8927 images.

I’ve also disabled and then re-run setup for camera upload, but that didn’t seem to help. I’m still able to upload individual files inside seafile, just camera upload is broken for me (I think since 2.2.34)

I have the same issue on my phone running Android 8.
The log looks like the other posted before.

On my tablet with Android 7 everything working fine.

Hi,
The autoupload on my phone (android 9) doesn’t work anymore. In the logs this error:

phoneModelInfo-------Sony/G8441/9
2021-06-07 22:10:51 d Utils ========Starting to upload images…
2021-06-07 22:10:51 d Utils ======sync aborted because an unknown error—android.database.sqlite.SQLiteException: too many SQL variables (code 1 SQLITE_ERROR): , while compiling: SELECT _id, _data, bucket_display_name FROM images WHERE (bucket_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

The server runs on debian 9, therefore i’ve running ver. 7.0.5.

Any news?

Thanks

We have added a new version with more debug information Release Seafile-2.2.38_debug · haiwen/seadroid · GitHub . Can you give it a check?

Can you also try to disable the camera upload feature and turn it on again and select one or two albums to upload?

done

2021-06-08 16:04:16 d Utils phoneModelInfo-------samsung/SM-G930F/8.0.0
2021-06-08 16:05:17 d Utils ==========start
2021-06-08 16:05:17 d Utils ========Starting to upload images…
2021-06-08 16:05:17 d Utils ===i see 1802 images.
2021-06-08 16:05:18 d Utils ========createDirectories====buckets.size()—17163
2021-06-08 16:06:58 d Utils phoneModelInfo-------samsung/SM-G930F/8.0.0
2021-06-08 16:06:59 d Utils ========Starting to upload images…
2021-06-08 16:06:59 d Utils ===i see 1803 images.
2021-06-08 16:07:03 d Utils ========createDirectories====buckets.size()—17164
2021-06-08 16:08:19 d Utils ===createDirectories–iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 16:08:19 d Utils ========sync was cancelled.
2021-06-08 16:08:20 d Utils ==========end
2021-06-08 16:09:11 d Utils ==========start
2021-06-08 16:09:11 d Utils ========Starting to upload images…
2021-06-08 16:09:11 d Utils ===i see 1803 images.
2021-06-08 16:09:12 d Utils ========createDirectories====buckets.size()—17164
2021-06-08 16:12:17 d Utils phoneModelInfo-------samsung/SM-G930F/8.0.0
2021-06-08 16:12:49 d Utils ========Starting to upload images…
2021-06-08 16:12:49 d Utils ===i see 1804 images.
2021-06-08 16:12:53 d Utils ========createDirectories====buckets.size()—17165

We have added a new version with more debug information Release Seafile-2.2.38_debug. Can you give it a check?

my phone won’t install the package.

i tried, but it didn’t help. i also selected a folder created by another app, seafile immediately synced those images, but it still does not detect any new files in DCIM/Camera.

I just upgraded to the debug release and then just used my phone like normal for a few hours. Here’s the result:

2021-06-08 17:39:05    d    Utils    phoneModelInfo-------OnePlus/IN2013/11
2021-06-08 17:39:06    d    Utils    ========Starting to upload images...
2021-06-08 17:39:06    d    Utils    ===i see 2581 images.
2021-06-08 17:39:06    d    Utils    ========createDirectories====buckets.size()---9374
2021-06-08 17:39:57    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 17:39:57    d    Utils    Starting to upload videos...
2021-06-08 17:39:57    d    Utils    ========sync was cancelled.
2021-06-08 17:39:57    d    Utils    ==========end
2021-06-08 17:40:05    d    Utils    ==========start
2021-06-08 17:40:05    d    Utils    ========Starting to upload images...
2021-06-08 17:40:05    d    Utils    ===i see 2581 images.
2021-06-08 17:40:05    d    Utils    ========createDirectories====buckets.size()---9374
2021-06-08 17:45:06    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 17:45:06    d    Utils    Starting to upload videos...
2021-06-08 17:45:06    d    Utils    ========sync was cancelled.
2021-06-08 17:45:06    d    Utils    ==========end
2021-06-08 17:52:16    d    Utils    ==========start
2021-06-08 17:52:18    d    Utils    ========Starting to upload images...
2021-06-08 17:52:18    d    Utils    ===i see 2581 images.
2021-06-08 17:52:18    d    Utils    ========createDirectories====buckets.size()---9374
2021-06-08 17:59:18    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 17:59:18    d    Utils    Starting to upload videos...
2021-06-08 17:59:18    d    Utils    ========sync was cancelled.
2021-06-08 17:59:18    d    Utils    ==========end
2021-06-08 18:06:06    d    Utils    ==========start
2021-06-08 18:06:06    d    Utils    ========Starting to upload images...
2021-06-08 18:06:06    d    Utils    ===i see 2581 images.
2021-06-08 18:06:06    d    Utils    ========createDirectories====buckets.size()---9374
2021-06-08 18:06:11    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 18:06:11    d    Utils    Starting to upload videos...
2021-06-08 18:06:11    d    Utils    ========sync was cancelled.
2021-06-08 18:06:11    d    Utils    ==========end
2021-06-08 18:11:52    d    Utils    ==========start
2021-06-08 18:11:53    d    Utils    ========Starting to upload images...
2021-06-08 18:11:53    d    Utils    ===i see 2581 images.
2021-06-08 18:11:53    d    Utils    ========createDirectories====buckets.size()---9374
2021-06-08 18:21:52    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 18:21:52    d    Utils    Starting to upload videos...
2021-06-08 18:21:52    d    Utils    ========sync was cancelled.
2021-06-08 18:21:52    d    Utils    ==========end
2021-06-08 19:25:37    d    Utils    ==========start
2021-06-08 19:25:37    d    Utils    ========Starting to upload images...
2021-06-08 19:25:37    d    Utils    ===i see 2581 images.
2021-06-08 19:25:38    d    Utils    ========createDirectories====buckets.size()---9375
2021-06-08 19:25:45    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 19:25:45    d    Utils    Starting to upload videos...
2021-06-08 19:25:45    d    Utils    ========sync was cancelled.
2021-06-08 19:25:45    d    Utils    ==========end
2021-06-08 19:45:25    d    Utils    ==========start
2021-06-08 19:45:25    d    Utils    ========Starting to upload images...
2021-06-08 19:45:25    d    Utils    ===i see 2581 images.
2021-06-08 19:45:25    d    Utils    ========createDirectories====buckets.size()---9375
2021-06-08 19:52:17    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 19:52:17    d    Utils    Starting to upload videos...
2021-06-08 19:52:17    d    Utils    ========sync was cancelled.
2021-06-08 19:52:17    d    Utils    ==========end
2021-06-08 19:55:53    d    Utils    ==========start
2021-06-08 19:55:54    d    Utils    ========Starting to upload images...
2021-06-08 19:55:54    d    Utils    ===i see 2581 images.
2021-06-08 19:55:55    d    Utils    ========createDirectories====buckets.size()---9375
2021-06-08 20:00:20    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 20:00:20    d    Utils    Starting to upload videos...
2021-06-08 20:00:20    d    Utils    ========sync was cancelled.
2021-06-08 20:00:20    d    Utils    ==========end
2021-06-08 20:02:47    d    Utils    ==========start
2021-06-08 20:02:48    d    Utils    ========Starting to upload images...
2021-06-08 20:02:48    d    Utils    ===i see 2581 images.
2021-06-08 20:02:48    d    Utils    ========createDirectories====buckets.size()---9375
2021-06-08 20:08:06    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 20:08:06    d    Utils    Starting to upload videos...
2021-06-08 20:08:06    d    Utils    ========sync was cancelled.
2021-06-08 20:08:06    d    Utils    ==========end
2021-06-08 20:11:22    d    Utils    ==========start
2021-06-08 20:11:23    d    Utils    ========Starting to upload images...
2021-06-08 20:11:23    d    Utils    ===i see 2581 images.
2021-06-08 20:11:23    d    Utils    ========createDirectories====buckets.size()---9375
2021-06-08 20:12:10    d    Utils    ===createDirectories--iterateCursor==ExceptionSeafException{code=2, msg=Network Error}
2021-06-08 20:12:10    d    Utils    Starting to upload videos...
2021-06-08 20:12:10    d    Utils    ========sync was cancelled.
2021-06-08 20:12:10    d    Utils    ==========end
2021-06-08 20:12:15    d    Utils    ==========start
2021-06-08 20:12:15    d    Utils    ==========noNetwork
2021-06-08 20:12:59    d    Utils    ==========start
2021-06-08 20:12:59    d    Utils    ==========noNetwork
2021-06-08 20:14:03    d    Utils    ==========start
2021-06-08 20:14:03    d    Utils    ========Starting to upload images...
2021-06-08 20:14:03    d    Utils    ===i see 2581 images.
2021-06-08 20:14:03    d    Utils    ========createDirectories====buckets.size()---9375

After looking at the log, I also disabled and re-enabled camera upload, going through the little wizard to set things up. Sadly, the log messages are identical to the above.

I’ve also installed the version 2.2.38. Deactivated/activated camera-upload, uninstalled & deleted cache-files and all other files/folder that I’ve found and then reinstalled the app - always the same. “Normal” upload via “send to” works. On the notebook (win 10) it works fine.

Log:

2021-06-08 18:37:07 d Utils phoneModelInfo-------Sony/G8441/9
2021-06-08 18:37:08 d Utils ========Starting to upload images…
2021-06-08 18:37:09 d Utils ======sync aborted because an unknown error—android.database.sqlite.SQLiteException: too many SQL variables (code 1 SQLITE_ERROR): , while compiling: SELECT _id, _data, bucket_display_name FROM images WHERE (bucket_id IN ( ?, …?, ? )) ORDER BY date_added ASC
2021-06-08 18:37:42 d Utils ========Starting to upload images…
2021-06-08 18:37:43 d Utils ======sync aborted because an unknown error—android.database.sqlite.SQLiteException: too many SQL variables (code 1 SQLITE_ERROR): , while compiling: SELECT _id, _data, bucket_display_name FROM images WHERE (bucket_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?

?, ?, ?, ?, ? )) ORDER BY date_added ASC
2021-06-08 22:36:49 d Utils phoneModelInfo-------Sony/G8441/9
2021-06-08 22:36:50 d Utils ========Starting to upload images…
2021-06-08 22:36:50 d Utils ======sync aborted because an unknown error—android.database.sqlite.SQLiteException: too many SQL variables (code 1 SQLITE_ERROR): , while compiling: SELECT _id, _data, bucket_display_name FROM images WHERE (bucket_id IN ( ?, ?, ?, …, ?, ?, ? )) ORDER BY date_added ASC
2021-06-08 22:37:25 d Utils ==========start
2021-06-08 22:37:26 d Utils ========Starting to upload images…
2021-06-08 22:37:26 d Utils ======sync aborted because an unknown error—android.database.sqlite.SQLiteException: too many SQL variables (code 1 SQLITE_ERROR): , while compiling: SELECT _id, _data, bucket_display_name FROM images WHERE (bucket_id IN ( ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )) ORDER BY date_added ASC
2021-06-08 22:37:26 d Utils ==========end

Now I’ve tried the version 2.2.28 - with this ver. the auto-mobile-upload it seems it’s working (upload started)

Any news @daniel.pan ? I wouldn’t mind doing more testing, if you have new test builds. I could revert back to an older version but I would prefer to just fix things!

In your log, it is “Network Error”. We don’t know the cause yet.

In the log of other users, the cause is clear. It is compatibility issue with Android 9 in the SQL query.

Yeah, it’s a bit strange that I get a generic network error in the log. My desktop client can connect perfectly without any problems, and I can upload and download without any trouble on the android client as well. It seems it’s just camera upload that gives this specific error. I hope you guys will be able to find out why. If any further testing could help, then let me know!

I had the same problem for about 2 months but only noticed it now (it’s only a backup for me usually). I only wondered why Seafile occasionally crashed since a while.

I just downloaded the release 2.2.36 and now it is uploading something again. Maybe this should be made available via automatic update :slight_smile:

Hello,
now the camera-upload does not work since version 2.2.32. So for over half a year. Is there any chance that the camera-upload will ever work again?

Can you give version 2.2.39 a test? Release Seafile-2.2.39 · haiwen/seadroid · GitHub

We have added some code to be compatible with Android 9.