wallabag / wallabag/android-app
SQLite error: too many parameters when sweeping for deleted articles
- Dominant language
- Java
- Stars
- 587
- Forks
- 276
- PR merge metrics
- No merged PRs in 30d
Description
I made the mistake of importing my entire Pocket archive to Wallabag....all 15 years and 25,000 items! First, I'm impressed that Wallabag (the software) and Wallabag.It (the server) handled it!
I've been mass-deleting old articles (which if I'd thought about it, I would have done *before* importing the data), and found that at one point I deleted too many articles on the server for the mobile app to delete at once. Whenever it tried to sweep for deleted articles, it would work on it for a while, then report a SQLite error that there were too many parameters in the statement and stop.
I finally fixed it by deleting the local database and then re-running a full sync. But it seems like the sweep process should batch the SQL statements if there's more than a certain number of items to delete.
Unfortunately I didn't catch the actual numbers, but I figure the max number of parameters should be somewhere in the SQLite documentation.
App version 2.5.3 on Android 14, using wallabag.it.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.