sqlite – Mobile app in Python with Kivy-md(navigation drawer), runs well on laptop but crashes on android phone after the splash screen. Please guide

I have developed this Python Kivy/Kivymd mobile app and is on android phone but the app crashing after displaying the logo, i have used navigation drawer in kivym to create a menu of options.plz check my main.py and kv file and the buildozer and suggest for any changes.Plz guide me on this earliest possible.This is for my high school club nationals project, i’m stuck and this will spoil my whole project and spoil my grades

main.py

import sqlite3
import webbrowser
from datetime import date
from kivy.core.window import Window
from kivy.lang import Builder
from kivy.properties import ObjectProperty, ListProperty
from kivy.uix.label import Label
from kivy.uix.popup import Popup
from kivy.uix.screenmanager import ScreenManager, Screen
from kivymd.app import MDApp
from kivymd.uix.picker import MDDatePicker


class WelcomeScreen(Screen):
    pass

class LoginScreen(Screen):
    # accessing the textbox values
    emailadd = ObjectProperty(None)
    passw = ObjectProperty(None)

    def loginbtn(self):
        # checking for the relevance of the entered values
        if self.emailadd.text != "" and self.passw.text != "":
            # validating the student credentials
            reg_user = validate_user(self.emailadd.text, self.passw.text)
            # if the user exists take the user to dashboard else prompt an error
            if reg_user == 1:
                self.reset()
                sm.current = "Dash"
            else:
                invalidlogin()
                self.reset()
                sm.current = "Login"
        else:
            invalidlogin()
            self.reset()
            sm.current = "Login"

    def reset(self):
        self.emailadd.text = ""
        self.passw.text = ""


# Creating a SignUp Screen
class SignupScreen(Screen):
    stname = ObjectProperty(None)
    passw = ObjectProperty(None)
    emailadd = ObjectProperty(None)

    def submit(self):

        # checking for the relevant values in the textboxes to create a profile
        if self.stname.text != "" and self.passw.text != "" and self.emailadd.text != "" and self.emailadd.text.count(
                "@") == 1 and self.emailadd.text.count(".") > 0:

            # if the password value is less than 5 characters, the app will prompt an error
            if len(self.passw.text) <= 5:
                passtooshort()
                self.reset()
            else:
                # checking the availability of the records in the database
                user = chk_user(self.emailadd.text)
                if user == 1:
                    # if the user doesn't exist, it will create a new record of the student and clear the textboxes
                    add_user(self.emailadd.text, self.passw.text, self.stname.text)


# Class to get a Social Media access
class DashScreen(Screen):
    # calling the School Instagram page
    def insta(self):
        webbrowser.open('https://www.instagram.com')

    # calling the School Youtube page
    def tube(self):
        webbrowser.open('https://www.youtube.com')


class ScheduleScreen(Screen):
    # Fetc all the values of the textboxes for Scheduling
   
    def add_schedule(self):
        # initializing a counter, 'i'
        i = 0

        # initializing a list of values for schedule
        perlist = [self.per1.text, self.per2.text, self.per3.text, self.per4.text, self.per5.text,
                   self.per6.text, self.per7.text, self.per8.text]

        # opening the connection with database
        conn = sqlite3.connect('mydb2.db', timeout=15)
        c = conn.cursor()
        while i < 8:
            c.execute("INSERT INTO sched (Period, Subject, EmailId) VALUES (?, ?, ?)",
                      (i, str(perlist[i]), 'someone@one,net'))
            i += 1
            conn.commit()
        conn.close()
        schedule_added()


class MyScheduleScreen(Screen):

    # creating a list for getting already inputted schedule
    subjects: ListProperty = ListProperty([("Period", "Subject")])

    # opening the connection to the database
    conn = sqlite3.connect("mydb2.db")
    c = conn.cursor()
    c.execute("SELECT * FROM sched WHERE EmailId =?", ('someone@one.net',))
    conn.commit()

    # filling up the list with the result of the SQL query
    subjects = c.fetchall()
    conn.close()


class ExtraScreen(Screen):
    # creating a list for fetching Clubnames, contact Emails values from the database for the student
    rows: ListProperty = ListProperty([("Club", "Desc")])
    # connecting with the database
    conn = sqlite3.connect('mydb2.db')
    c = conn.cursor()
    c.execute("SELECT * FROM extracur")
    conn.commit()
    rows = c.fetchall()
    conn.close()
    # closing the connection

class WindowManager(ScreenManager):
    pass

sm = WindowManager()

class PocketPad(MDApp):
    def build(self):
        kv = Builder.load_file("pktpad.kv")
        return kv

    def on_start(self):
        self.theme_cls.primary_palette = "Indigo"


if __name__ == "__main__":
    PocketPad().run()

pktpad.kv(KV-file)

ScreenManager:
    id: screen_manager
    WelcomeScreen:
        name: 'Welcome'
        id: Welcome
        manager: 'screen_manager'
    SignupScreen:
        name: 'SignUp'
        id: SignUp
        manager: 'screen_manager'
    LoginScreen:
        name: 'Login'
        id: Login
        manager: 'screen_manager'
    DashScreen:
        name: 'Dash'
        id: Dash
        manager: 'screen_manager'
    ScheduleScreen:
        name: 'Schedule'
        id: schedule
        manager: 'screen_manager'
    MyScheduleScreen:
        name: 'MySchedule'
        id: MySchedule
        manager: 'screen_manager'
    ExtraScreen:
        name: 'Extra'
        id: Extra
        manager: 'screen_manager'

<WelcomeScreen>:
    MDFloatLayout:
        md_bg_color: 1,1,1,1
        Image:
            source: "Icon.png"

        MDLabel:
            text: "W E L C O M E !"

        Button:
            text: "LOGIN"

        Button:
            text: "SIGN UP"


<SignupScreen>:
 
    MDFloatLayout:
        md_bg_color: 1,1,1,1
        MDIconButton:
            icon: "arrow-left"

        MDLabel:
            text: "   W e l c o m e"

        MDLabel:
            text: "Create a new account"

        MDFloatLayout:
            TextInput:
                id: stname
                hint_text: "Name"
 
        #Textbox for entering email address
        MDFloatLayout:
            TextInput:
                id: emailadd
                hint_text: "Email Address"
 
        MDFloatLayout:
            TextInput:
                id: passw
                hint_text: "Password n(6 or more chars)"
 
        #Creating SIGNUP button
        Button:
            text: "SIGN UP"
 
        MDLabel:
            text: "or"
 
        MDTextButton:
            text: "Already have an account?"
 
        MDTextButton:
            text: "Sign in"
 
            on_release:
                app.root.transition.direction = "left"
                app.root.current = "Login"
 
<LoginScreen>:
 
    MDFloatLayout:
        MDIconButton:
            icon: "arrow-left"
            on_release:
                app.root.transition.direction = "right"
                app.root.current = "Welcome"
 
        #Creating Welcome Labels
        MDLabel:
            text: "  W e l c o m e"

        MDLabel:
            text: "Sign in to continue"

        #Textbox email address
        MDFloatLayout:
            TextInput:
                id: emailadd
                hint_text: "Email Id"

        #Textbox password
        MDFloatLayout:
            TextInput:
                id: passw
                hint_text: "Password"
        #Creating button to log in
        Button:
            text: "LOGIN"
            on_release:
                app.root.transition.direction = "left"
                #root.loginbtn()
                app.root.current = "Dash"

        MDLabel:
            text: "or"

        MDTextButton:
            text: "Don't have an account?"

        MDTextButton:
            text: "Sign up"
            on_release:
                app.root.transition.direction = "left"
                app.root.current = "SignUp"


<DashScreen>:
    MDFloatLayout:
        BoxLayout:
            orientation: 'vertical'

            MDToolbar:
                title: 'Pocket-Pad'
                halign: "center"
                md_bg_color: (0,0,1,1)
                left_action_items: [["menu", lambda x: nav_drawer.set_state('toggle')]]
                right_action_items: [["logout", lambda x: app.stop()]]
                elevation:10

            Widget:

            Image:
                source: "Welcome.png"

            MDBottomNavigation:

                #Creating navigation item for home
                MDBottomNavigationItem:
                    name: 'Home'
                    on_tab_release: "Dash"

                #Creating navigation item for Instagram
                MDBottomNavigationItem:
                    name: 'Insta'
                    on_tab_release:
                        root.insta()

                #creating navigation item for accessing youtube
                MDBottomNavigationItem:
                    name: 'tube'
                    on_tab_release:
                        root.tube()

        MDNavigationLayout:

            ScreenManager:
                id: manager

            MDNavigationDrawer:
                id: nav_drawer
                size_hint_x: None
                elevation: 10

                BoxLayout:
                    Image:
                        id: icon
                        source: "Icon.png"

                    MDLabel:
                        text: " APP-Name"
 
                    ScrollView:

                        MDList:
                            OneLineListItem:
                                text: "Create Schedule"
                                on_press:
                                    nav_drawer.set_state("close")
                                    app.root.transition.direction = "left"
                                    app.root.current = "Schedule"
   
                            OneLineListItem:
                                text: "My Schedule"
                                on_press:
                                    nav_drawer.set_state("close")
                                    app.root.transition.direction = "left"
                                    app.root.current = "MySchedule"

                            OneLineListItem:
                                text: "Activities"
                                on_press:
                                    nav_drawer.set_state("close")
                                    app.root.transition.direction = "left"
                                    app.root.current = "Extra"
   

<ScheduleScreen>:

    MDBoxLayout:

        MDLabel:
            text: "Period"
        MDLabel:
            text: "   Subject"

    # Creating Textboxes for entering subjects
    MDFloatLayout:
        TextInput:
            id: per1
            hint_text: "Period 1 - Subject"

    MDFloatLayout:
        TextInput:
            id: per2
            hint_text: "Period 2 - Subject"

    MDFloatLayout:
        TextInput:
            id: per3
            hint_text: "Period 3 - Subject"

    MDFloatLayout:
        TextInput:
            id: per4
            hint_text: "Period 4 - Subject"

    MDFloatLayout:
        TextInput:
            id: per5
            hint_text: "Period 5 - Subject"

    MDFloatLayout:
        TextInput:
            id: per6
            hint_text: "Period 6 - Subject"

    MDFloatLayout:
        TextInput:
            id: per7
            hint_text: "Period 7 - Subject"

    MDFloatLayout:
        TextInput:
            id: per8
            hint_text: "Period 8 - Subject"

    # Creating Labels for Period Nos.
    MDFloatLayout:
        MDLabel:
            text: "1"

    MDFloatLayout:
        MDLabel:
            text: "2"

    MDFloatLayout:
        MDLabel:
            text: "3"
 
    MDFloatLayout:
        MDLabel:
            text: "4"
 
    MDFloatLayout:
        MDLabel:
            text: "5"
 
    MDFloatLayout:
        MDLabel:
            text: "6"
 
    MDFloatLayout:
        MDLabel:
            text: "7"
 
    MDFloatLayout:
        MDLabel:
            text: "8"
 
    Button:
        text: "SUBMIT"
    Button:
        text: "CANCEL"
 

<MyScheduleScreen>:
    MDBoxLayout:
         
        MDLabel:
            text: "Period"
 
        MDLabel:
            text: "    Subject"
 
    MDBoxLayout:
 
        RecycleView:
            data: [{'text':"{}".format(Period), 'color': [0, 0, 0, 1]} for Period,Subject,EmailID in root.subjects]
            viewclass: "Label"
            RecycleBoxLayout:
                bg_color:(0, 0, 0, 0)
                default_size: None, dp(36)
                orientation: "vertical"
                default_size_hint: 1, None
                size_hint_y: None
                height: self.minimum_height
        RecycleView:
            data: [{'text':"{}".format(Subject), 'color': [0, 0, 0, 1]} for Period,Subject,EmailID in root.subjects]
            viewclass: "Label"
            RecycleBoxLayout:
                bg_color:(0, 0, 0, 0)
                default_size: None, dp(36)
                orientation: "vertical"
                default_size_hint: 1, None
                size_hint_y: None
                height: self.minimum_height
 
<ExtraScreen>:
    MDBoxLayout:
        MDLabel:
            text: 'Clubs'
            pos_hint: {"center_x": 0.15, "center_y": .9}
        MDLabel:
            text: 'Send Email to'
            pos_hint: {"center_x": 0.70, "center_y": .9}

    MDBoxLayout:
        pos_hint: {'top': 0.8}
        RecycleView:
            data: [{'text':"{}".format(name), 'color': [0, 0, 0, 1]} for name,desc,POC,email in root.rows]
            viewclass: "Label"
            RecycleBoxLayout:
                bg_color:(0, 0, 0, 0)
                default_size: None, dp(36)
                orientation: "vertical"
                default_size_hint: 1, None
                size_hint_y: None
                height: self.minimum_height
                canvas:
                    Color:
                        rgba: (0, 0, 0, 0)
                    Rectangle:
                        pos: self.pos
                        size: self.size

        RecycleView:
            data: [{'text':"{}".format(email), 'color': [0, 0, 0, 1]} for name,desc,POC,email in root.rows]
            viewclass: "Label"
            RecycleBoxLayout:
                default_size: None, dp(36)
                orientation: "vertical"
                default_size_hint: 1, None
                size_hint_y: None
                height: self.minimum_height
                canvas:
                    Color:
                        rgba: (0, 0, 0, 0)
                    Rectangle:
                        pos: self.pos
                        size: self.size

BUILDOZER file
[app]

# (str) Title of your application
title = Pocket Pad

# (str) Package name
package.name = pocketpad

# (str) Package domain (needed for android/ios packaging)
package.domain = org.pocketpad

# (str) Source code where the main.py live
source.dir = .

# (list) Source files to include (let empty to include all the files)
source.include_exts = py,png,jpg,kv,atlas,db

# (list) List of inclusions using pattern matching
#source.include_patterns = assets/*,images/*.png

# (list) Source files to exclude (let empty to not exclude anything)
#source.exclude_exts = spec

# (list) List of directory to exclude (let empty to not exclude anything)
#source.exclude_dirs = tests, bin

# (list) List of exclusions using pattern matching
#source.exclude_patterns = license,images/*/*.jpg

# (str) Application versioning (method 1)
version = 0.1

# (str) Application versioning (method 2)
# version.regex = __version__ = ['"](.*)['"]
# version.filename = %(source.dir)s/main.py

# (list) Application requirements
# comma separated e.g. requirements = sqlite3,kivy
requirements = python3,kivy==2.0.0,kivymd==0.104.2,sqlite3,datetime

# (str) Custom source folders for requirements
# Sets custom source for any requirements with recipes
# requirements.source.kivy = ../../kivy

# (list) Garden requirements
#garden_requirements =

# (str) Presplash of the application
presplash.filename = Icon.png

# (str) Icon of the application
icon.filename = Icon.png

# (str) Supported orientation (one of landscape, sensorLandscape, portrait or all)
orientation = portrait

# (list) List of service to declare
#services = NAME:ENTRYPOINT_TO_PY,NAME2:ENTRYPOINT2_TO_PY

#
# OSX Specific
#

#
# author = © Copyright Info

# change the major version of python used by the app
osx.python_version = 3

# Kivy version to use
osx.kivy_version = 1.9.1

#
# Android specific
#

# (bool) Indicate if the application should be fullscreen or not
fullscreen = 0

# (string) Presplash background color (for new android toolchain)
# Supported formats are: #RRGGBB #AARRGGBB or one of the following names:
# red, blue, green, black, white, gray, cyan, magenta, yellow, lightgray,
# darkgray, grey, lightgrey, darkgrey, aqua, fuchsia, lime, maroon, navy,
# olive, purple, silver, teal.
#android.presplash_color = #FFFFFF

# (list) Permissions
android.permissions = INTERNET,ACCESS_NETWORK_STATE,WRITE_EXTERNAL_STORAGE,READ_EXTERNAL_STORAGE

# (int) Target Android API, should be as high as possible.
android.api = 30

# (int) Minimum API your APK will support.
android.minapi = 21

# (int) Android SDK version to use
#android.sdk = 20

# (str) Android NDK version to use
android.ndk = 19b

# (int) Android NDK API to use. This is the minimum API your app will support, it should usually match android.minapi.
#android.ndk_api = 21

# (bool) Use --private data storage (True) or --dir public storage (False)
#android.private_storage = True

# (str) Android NDK directory (if empty, it will be automatically downloaded.)
#android.ndk_path =

# (str) Android SDK directory (if empty, it will be automatically downloaded.)
#android.sdk_path =

# (str) ANT directory (if empty, it will be automatically downloaded.)
#android.ant_path =

# (bool) If True, then skip trying to update the Android sdk
# This can be useful to avoid excess Internet downloads or save time
# when an update is due and you just want to test/build your package
# android.skip_update = False

# (bool) If True, then automatically accept SDK license
# agreements. This is intended for automation only. If set to False,
# the default, you will be shown the license when first running
# buildozer.
# android.accept_sdk_license = False

# (str) Android entry point, default is ok for Kivy-based app
#android.entrypoint = org.renpy.android.PythonActivity

# (str) Android app theme, default is ok for Kivy-based app
# android.apptheme = "@android:style/Theme.NoTitleBar"

# (list) Pattern to whitelist for the whole project
#android.whitelist =

# (str) Path to a custom whitelist file
#android.whitelist_src =

# (str) Path to a custom blacklist file
#android.blacklist_src =

# (list) List of Java .jar files to add to the libs so that pyjnius can access
# their classes. Don't add jars that you do not need, since extra jars can slow
# down the build process. Allows wildcards matching, for example:
# OUYA-ODK/libs/*.jar
#android.add_jars = foo.jar,bar.jar,path/to/more/*.jar

# (list) List of Java files to add to the android project (can be java or a
# directory containing the files)
#android.add_src =

# (list) Android AAR archives to add (currently works only with sdl2_gradle
# bootstrap)
#android.add_aars =

# (list) Gradle dependencies to add (currently works only with sdl2_gradle
# bootstrap)
#android.gradle_dependencies =

# (list) add java compile options
# this can for example be necessary when importing certain java libraries using the 'android.gradle_dependencies' option
# see https://developer.android.com/studio/write/java8-support for further information
# android.add_compile_options = "sourceCompatibility = 1.8", "targetCompatibility = 1.8"

# (list) Gradle repositories to add {can be necessary for some android.gradle_dependencies}
# please enclose in double quotes
# e.g. android.gradle_repositories = "maven { url 'https://kotlin.bintray.com/ktor' }"
#android.add_gradle_repositories =

# (list) packaging options to add
# see https://google.github.io/android-gradle-dsl/current/com.android.build.gradle.internal.dsl.PackagingOptions.html
# can be necessary to solve conflicts in gradle_dependencies
# please enclose in double quotes
# e.g. android.add_packaging_options = "exclude 'META-INF/common.kotlin_module'", "exclude 'META-INF/*.kotlin_module'"
#android.add_gradle_repositories =

# (list) Java classes to add as activities to the manifest.
#android.add_activities = com.example.ExampleActivity

# (str) OUYA Console category. Should be one of GAME or APP
# If you leave this blank, OUYA support will not be enabled
#android.ouya.category = GAME

# (str) Filename of OUYA Console icon. It must be a 732x412 png image.
#android.ouya.icon.filename = %(source.dir)s/data/ouya_icon.png

# (str) XML file to include as an intent filters in <activity> tag
#android.manifest.intent_filters =

# (str) launchMode to set for the main activity
#android.manifest.launch_mode = standard

# (list) Android additional libraries to copy into libs/armeabi
#android.add_libs_armeabi = libs/android/*.so
#android.add_libs_armeabi_v7a = libs/android-v7/*.so
#android.add_libs_arm64_v8a = libs/android-v8/*.so
#android.add_libs_x86 = libs/android-x86/*.so
#android.add_libs_mips = libs/android-mips/*.so

# (bool) Indicate whether the screen should stay on
# Don't forget to add the WAKE_LOCK permission if you set this to True
#android.wakelock = False

# (list) Android application meta-data to set (key=value format)
#android.meta_data =

# (list) Android library project to add (will be added in the
# project.properties automatically.)
#android.library_references =

# (list) Android shared libraries which will be added to AndroidManifest.xml using <uses-library> tag
#android.uses_library =

# (str) Android logcat filters to use
android.logcat_filters = *:S python:D

# (bool) Copy library instead of making a libpymodules.so
#android.copy_libs = 1

# (str) The Android arch to build for, choices: armeabi-v7a, arm64-v8a, x86, x86_64
android.arch = armeabi-v7a

# (int) overrides automatic versionCode computation (used in build.gradle)
# this is not the same as app version and should only be edited if you know what you're doing
# android.numeric_version = 1

#
# Python for android (p4a) specific
#

# (str) python-for-android fork to use, defaults to upstream (kivy)
#p4a.fork = kivy

# (str) python-for-android branch to use, defaults to master
#p4a.branch = master

# (str) python-for-android git clone directory (if empty, it will be automatically cloned from github)
#p4a.source_dir =

# (str) The directory in which python-for-android should look for your own build recipes (if any)
#p4a.local_recipes =

# (str) Filename to the hook for p4a
#p4a.hook =

# (str) Bootstrap to use for android builds
# p4a.bootstrap = sdl2

# (int) port number to specify an explicit --port= p4a argument (eg for bootstrap flask)
#p4a.port =


#
# iOS specific
#

# (str) Path to a custom kivy-ios folder
#ios.kivy_ios_dir = ../kivy-ios
# Alternately, specify the URL and branch of a git checkout:
ios.kivy_ios_url = https://github.com/kivy/kivy-ios
ios.kivy_ios_branch = master

# Another platform dependency: ios-deploy
# Uncomment to use a custom checkout
#ios.ios_deploy_dir = ../ios_deploy
# Or specify URL and branch
ios.ios_deploy_url = https://github.com/phonegap/ios-deploy
ios.ios_deploy_branch = 1.7.0

# (str) Name of the certificate to use for signing the debug version
# Get a list of available identities: buildozer ios list_identities
#ios.codesign.debug = "iPhone Developer: <lastname> <firstname> (<hexstring>)"

# (str) Name of the certificate to use for signing the release version
#ios.codesign.release = %(ios.codesign.debug)s


[buildozer]

# (int) Log level (0 = error only, 1 = info, 2 = debug (with command output))
log_level = 2

# (int) Display warning if buildozer is run as root (0 = False, 1 = True)
warn_on_root = 1

# (str) Path to build artifact storage, absolute or relative to spec file
# build_dir = ./.buildozer

# (str) Path to build output (i.e. .apk, .ipa) storage
# bin_dir = ./bin

#    -----------------------------------------------------------------------------
#    List as sections
#
#    You can define all the "list" as [section:key].
#    Each line will be considered as a option to the list.
#    Let's take [app] / source.exclude_patterns.
#    Instead of doing:
#
#[app]
#source.exclude_patterns = license,data/audio/*.wav,data/images/original/*
#
#    This can be translated into:
#
#[app:source.exclude_patterns]
#license
#data/audio/*.wav
#data/images/original/*
#


#    -----------------------------------------------------------------------------
#    Profiles
#
#    You can extend section / key with a profile
#    For example, you want to deploy a demo version of your application without
#    HD content. You could first change the title to add "(demo)" in the name
#    and extend the excluded directories to remove the HD content.
#
#[app@demo]
#title = My Application (demo)
#
#[app:source.exclude_patterns@demo]
#images/hd/*
#
#    Then, invoke the command line with the "demo" profile:
#
#buildozer --profile demo android debug

Leave a Comment