No file or variants found for asset: app/app.zip error with `flet build apk` on Windows

[akunzz]

I have error

[FeodorFitsner]

The actual error is No file or variants found for asset: app/app.zip. Those "errors" are warnings.

Could you run flet build apk -vv to get a detailed log?

[akunzz]

Vietnamese: Tôi đã khắc phục được do phiên bản python tôi dùng là 13.12 tôi đã down xuống 13.11.6 và đã build OK. Làm sao tôi có thể build cho phiển bản andoird 7. 8. 9, 10, 11....
English: I was able to fix it because the python version I used was 13.12, I downloaded it to 13.11.6 and it built OK. How can I build for Android version 7. 8. 9, 10, 11....

[FeodorFitsner]

You mean Python 3.12 and 3.11.6?

[akunzz]

You mean Python 3.12 and 3.11.6?

I downgrade python to 3.11.6

[akunzz]

log.txt
this is my log file, When I install it on the device, the screen is blank

[FeodorFitsner]

What other Python dependencies does your app require, except flet?

[akunzz]

What other Python dependencies does your app require, except flet?
include: import pyodbc, json
import time, requests

[taaaf11]

@akunzz Give your requirements.txt

[akunzz]

@akunzz Give your requirements.txt

anyio==4.2.0
arrow==1.3.0
binaryornot==0.4.4
blinker==1.7.0
certifi==2023.11.17
chardet==5.2.0
charset-normalizer==3.3.2
click==8.1.7
colorama==0.4.6
cookiecutter==2.5.0
Flask==3.0.0
flet==0.18.0
flet-core==0.18.0
flet-runtime==0.18.0
h11==0.14.0
httpcore==0.17.3
httpx==0.24.1
idna==3.6
itsdangerous==2.1.2
Jinja2==3.1.2
markdown-it-py==3.0.0
MarkupSafe==2.1.3
mdurl==0.1.2
oauthlib==3.2.2
packaging==23.2
Pygments==2.17.2
pyodbc==5.0.1
pyotp==2.9.0
pypng==0.20220715.0
python-dateutil==2.8.2
python-slugify==8.0.1
PyYAML==6.0.1
qrcode==7.4.2
repath==0.9.0
requests==2.31.0
rich==13.7.0
six==1.16.0
sniffio==1.3.0
text-unidecode==1.3
types-python-dateutil==2.8.19.20240106
typing_extensions==4.9.0
urllib3==2.1.0
watchdog==3.0.0
websocket-client==1.7.0
websockets==11.0.3
Werkzeug==3.0.1

[taaaf11]

@akunzz By looking at the requirements list you gave, it seems you are using flet, Flask and pyodbc packages (the top level) right? Make your requirements.txt hand-picked, and list only direct imports in requirements.txt. Like I said before, the requirements.txt would seem like (only including direct imports from your files)

flet
Flask
pyodbc

version you give

Try this

[akunzz]

@akunzz By looking at the requirements list you gave, it seems you are using flet, Flask and pyodbc packages (the top level) right? Make your requirements.txt hand-picked, and list only direct imports in requirements.txt. Like I said before, the requirements.txt would seem like (only including direct imports from your files)

flet
Flask
pyodbc

version you give

Try this

ok let me try, in my project I import include:
import time
import requests
import pyodbc,json

[akunzz]

import pyodbc,json

class Database:
    def __init__(self):
        self.conn_str = (
            r'DRIVER={SQL Server};'
            r'SERVER=xx.xxx.xxxx;'
            r'DATABASE=xxxxxxx;'
            r'UID=xxxxx;'
            r'PWD=xxxxxx'
        )

    def execute_query(self, query):
        print(query)
        conn = pyodbc.connect(self.conn_str)
        cursor = conn.cursor()
        cursor.execute(query)
        cursor.commit()
        conn.close()

    def fetch_query(self, query):
        conn = pyodbc.connect(self.conn_str)
        cursor = conn.cursor()
        cursor.execute(query)
        rows = cursor.fetchall()
        #print(rows)
        if len(rows)!= 0:
            result = [dict(zip([column[0] for column in cursor.description], row)) for row in rows]
            conn.close()
            json_result = json.dumps(result)
            decoded_result = json.loads(json_result)
            return decoded_result
        else:
            conn.close()
            return None

from config.database import Database



class Login:
    def __init__(self):
        self.q = Database()

    def login(self, user:str, password:str):
        if user[0]=='1':
            query = "select xxx"
        else:
            query="xxxxx"
        return self.q.fetch_query(query)
    
    def get_profile(self, manv:str):
        query="select * from o_profile where manv=N'"+manv+"'"
        return self.q.fetch_query(query)
    
    def set_user(self, manv:str, str_cl:str, str_v:str):
        query="update o_profile set "+str_cl+"='"+str_v+"' where manv=N'"+manv+"'"
        self.q.execute_query(query)

from flet import *
from services.login import Login
 username = self.txt_username.value
        password = self.txt_password.value
        q = Login()
        data_login = q.login(username,password)
        if data_login != None:
            if str(data_login[0]['lamviec'])=='0':
                self.page.splash.visible = False
                self.show_ms(icons.ERROR_OUTLINE,'Nhân viên này đã nghỉ việc', colors.RED)
            else:
                self.page.client_storage.set('login', data_login)
                self.page.splash.visible = False
                self.on_store_pass
                self.callback()
                print('vào main')
        else:
            self.page.splash.visible = False
            self.show_ms(icons.ERROR_OUTLINE,'Tài khoản hoặc mật khẩu không đúng', colors.RED)

When I remove from services.login import Login and don't use it anymore, the app won't get a black screen, so I suspect it's in the import pyodbc package. even though my requirements.txt file is flet
pyodbc