Clover setup in android emulator

While setting up clover in emulator most of developers facing issue

Encountered the same problem. Though I've tried to upgrading my python it still keep getting the error `

for row in conn.execute('select * from apps'):

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

sqlite3.OperationalError: no such table: apps

Why this error happen?
This error occur due to running "install_apps.py". The error is "sqlite3.OperationalError: no such table: apps". The issue is that this install python script downloads the file "appsinfo.db" (sqlite3 database) from the emulator device and runs the SQL "select * from apps". This database file has NO TABLES ! This is why the script fails. The table "apps" in sqlite3 database is supposed to be a list of apps to install, their version numbers, and their URL for install to work. Since the table is missing in the database, install script cannot proceed.

Solution

For this you need to follow below steps to resolve error

1.Download appinfo.db from - Link

2.Delete blank appinfo.db

For ref - https://prnt.sc/KTRdk9kBlJyE

3.Upload downloaded appinfo.db to emulator

For ref - https://prnt.sc/2Ywq6tIYR2I7

4.run python3 install_apps.py command

ripci commented · Aug 06, 2023 at 01:49 AM

If anyone still comes across this issue, you must download the 'App Updater' and 'Clover' engine/apps from the Dev APKS. The docs do not mention the app updater, but it in my case it was required for the install_apps.py script to work. Took way to long to find this out....

0 ·

article