I am trying to set up emulator on Apple M1 pro. When I run `python3 install_apps.py` I keep getting error as `sqlite3.OperationalError: no such table: apps`. I am trying to set up Clover Mini 3. I have been following the video and instructions posted here . Any help will be greatly appreciated.
I'm seeing the same error on running "install_apps.py". The error is "sqlite3.OperationalError: no such table: apps". I have verified that I am using python version 3.11.1. 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. I have tried using Clover Mini 3 with Android API 22 and 29. Both fail in the same way because the current clover engine APK (2212) seems to have bad appsinfo database.
Where can I find version of clover engine older than 2212 for sandbox to test? Alternatively, you can provide me a list of apps this script should install, their URL etc and I can install them manually.
BTW, I am running Android Studio / Emulator on Apple Macbook Pro with M1 processor.
I ran through the entire installation again and wasn't able to reproduce the error with the new engine. Please review our steps(https://docs.clover.com/docs/setting-up-an-android-emulator) and here are our app apks: https://sandbox.dev.clover.com/developers/dev-apks
I'm cross posting my answer in this thread so others may be able to move forward. Please note that I seem to have incorrectly said that I tried Android API 22. My second attempt with API 22 with some modifications now gets me unstuck and installs the apps in the emulator. See my answer from another thread below...
----
Bryan, thanks for looking into this. I am already using the latest python version 3.11.1. However, I was able to move forward from this failure by downgrading the device in emulator to use Android API level 22, rather than the latest 29 that I was using.
However, the install script started to fail at another point where it was fetching the actual APK files. The issue is that the Clover's SSL certificate at https://filessandbox.dev.clover.com/ (the location from where the script downloads the APK files) seems to be missing or expired. When I modified install_apps.py line 60 to disable SSL certificate checking (http = urllib3.PoolManager(cert_reqs = ssl.CERT_NONE)) the script moves forward with a warning. Clover apps are now installed in the emulator device !
You might want to alert someone of the missing / expired SSL certificate at sandbox file server above. Thanks.
As per @satish yes sometimes appinfo.db able created as blank so python script throwing error
for row in conn.execute('select * from apps'):
sqlite3.OperationalError: no such table: apps
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
8 People are following this question.
