[GH-ISSUE #35] Error accessing the database (sqlite) after converting py to exe #34

Closed
opened 2026-02-26 12:20:15 +03:00 by kerem · 4 comments
Owner

Originally created by @supernooba on GitHub (Nov 23, 2018).
Original GitHub issue: https://github.com/brentvollebregt/auto-py-to-exe/issues/35

I've tried converting my py script (with a database that contains username and password), it runs however, it's not able to access the database. I tried both options in converting either the 'one directory' or 'one file' but to no avail.

Can you please advise workaround? thank you very much

Originally created by @supernooba on GitHub (Nov 23, 2018). Original GitHub issue: https://github.com/brentvollebregt/auto-py-to-exe/issues/35 I've tried converting my py script (with a database that contains username and password), it runs however, it's not able to access the database. I tried both options in converting either the 'one directory' or 'one file' but to no avail. Can you please advise workaround? thank you very much
kerem closed this issue 2026-02-26 12:20:15 +03:00
Author
Owner

@brentvollebregt commented on GitHub (Nov 23, 2018):

Did you add the database in the additional files section?

<!-- gh-comment-id:441153110 --> @brentvollebregt commented on GitHub (Nov 23, 2018): Did you add the database in the additional files section?
Author
Owner

@supernooba commented on GitHub (Nov 23, 2018):

@brentvollebregt Hi Brent,

Yes, I've done that, but the error still persist: below is the log

Cleaning workspace
145388 INFO: PyInstaller: 3.4
145389 INFO: Python: 3.6.5
145390 INFO: Platform: Windows-10-10.0.16299-SP0
145394 INFO: wrote C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\userLogin.spec
145407 INFO: UPX is not available.
145414 INFO: Extending PYTHONPATH with paths
['C:\Users\mestrera\Desktop\Classroom\workProjects\userControl - Copy '
'(2)',
'C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe']
145414 INFO: checking Analysis
145415 INFO: Building Analysis because Analysis-00.toc is non existent
145416 INFO: Initializing module dependency graph...
145427 INFO: Initializing module graph hooks...
145437 INFO: Analyzing base_library.zip ...
151455 INFO: running Analysis Analysis-00.toc
151504 INFO: Adding Microsoft.Windows.Common-Controls to dependent assemblies of final executable
required by C:\Users\mestrera\AppData\Local\Continuum\miniconda3\python.exe
152594 INFO: Caching module hooks...
152614 INFO: Analyzing C:\Users\mestrera\Desktop\Classroom\workProjects\userControl - Copy (2)\userLogin.py
152901 INFO: Loading module hooks...
152901 INFO: Loading module hook "hook-encodings.py"...
153267 INFO: Loading module hook "hook-pydoc.py"...
153271 INFO: Loading module hook "hook-PyQt5.py"...
154046 WARNING: Hidden import "PyQt5.sip" not found!
154047 INFO: Loading module hook "hook-PyQt5.QtCore.py"...
154205 INFO: Loading module hook "hook-PyQt5.QtGui.py"...
154594 INFO: Loading module hook "hook-PyQt5.QtWidgets.py"...
155221 INFO: Loading module hook "hook-sqlite3.py"...
155607 INFO: Loading module hook "hook-xml.py"...
156039 INFO: Looking for ctypes DLLs
156040 INFO: Analyzing run-time hooks ...
156047 INFO: Including run-time hook 'pyi_rth_qt5.py'
156059 INFO: Looking for dynamic libraries
157070 INFO: Looking for eggs
157071 INFO: Using Python library C:\Users\mestrera\AppData\Local\Continuum\miniconda3\python36.dll
157071 INFO: Found binding redirects:
[]
157081 INFO: Warnings written to C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\build\userLogin\warn-userLogin.txt
157157 INFO: Graph cross-reference written to C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\build\userLogin\xref-userLogin.html
157180 INFO: Appending 'datas' from .spec
157187 INFO: checking PYZ
157188 INFO: Building PYZ because PYZ-00.toc is non existent
157189 INFO: Building PYZ (ZlibArchive) C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\build\userLogin\PYZ-00.pyz
157833 INFO: Building PYZ (ZlibArchive) C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\build\userLogin\PYZ-00.pyz completed successfully.
157854 INFO: checking PKG
157854 INFO: Building PKG because PKG-00.toc is non existent
157855 INFO: Building PKG (CArchive) PKG-00.pkg
169243 INFO: Building PKG (CArchive) PKG-00.pkg completed successfully.
169263 INFO: Bootloader C:\Users\mestrera\AppData\Local\Continuum\miniconda3\lib\site-packages\PyInstaller\bootloader\Windows-64bit\runw.exe
169264 INFO: checking EXE
169266 INFO: Building EXE because EXE-00.toc is non existent
169267 INFO: Building EXE from EXE-00.toc
169301 INFO: SRCPATH [('C:\Users\mestrera\Desktop\Classroom\workProjects\userControl - Copy (2)\icons8_bar_chart_64_C26_icon.ico', None)]
169304 INFO: Updating icons from ['C:\Users\mestrera\Desktop\Classroom\workProjects\userControl - Copy (2)\icons8_bar_chart_64_C26_icon.ico'] to C:\Users\mestrera\AppData\Local\Temp\tmpk11q8j21
169311 INFO: Writing RT_GROUP_ICON 0 resource with 76 bytes
169313 INFO: Writing RT_ICON 1 resource with 1128 bytes
169314 INFO: Writing RT_ICON 2 resource with 2440 bytes
169315 INFO: Writing RT_ICON 3 resource with 4264 bytes
169315 INFO: Writing RT_ICON 4 resource with 9640 bytes
169316 INFO: Writing RT_ICON 5 resource with 17252 bytes
169333 INFO: Appending archive to EXE C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\dist\userLogin.exe
169796 INFO: Building EXE from EXE-00.toc completed successfully.
Moving project to: output/
Cleaning workspace
Complete.

<!-- gh-comment-id:441158672 --> @supernooba commented on GitHub (Nov 23, 2018): @brentvollebregt Hi Brent, Yes, I've done that, but the error still persist: below is the log Cleaning workspace 145388 INFO: PyInstaller: 3.4 145389 INFO: Python: 3.6.5 145390 INFO: Platform: Windows-10-10.0.16299-SP0 145394 INFO: wrote C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\userLogin.spec 145407 INFO: UPX is not available. 145414 INFO: Extending PYTHONPATH with paths ['C:\\Users\\mestrera\\Desktop\\Classroom\\workProjects\\userControl - Copy ' '(2)', 'C:\\Users\\mestrera\\Desktop\\Classroom\\GitHub\\auto-py-to-exe'] 145414 INFO: checking Analysis 145415 INFO: Building Analysis because Analysis-00.toc is non existent 145416 INFO: Initializing module dependency graph... 145427 INFO: Initializing module graph hooks... 145437 INFO: Analyzing base_library.zip ... 151455 INFO: running Analysis Analysis-00.toc 151504 INFO: Adding Microsoft.Windows.Common-Controls to dependent assemblies of final executable required by C:\Users\mestrera\AppData\Local\Continuum\miniconda3\python.exe 152594 INFO: Caching module hooks... 152614 INFO: Analyzing C:\Users\mestrera\Desktop\Classroom\workProjects\userControl - Copy (2)\userLogin.py 152901 INFO: Loading module hooks... 152901 INFO: Loading module hook "hook-encodings.py"... 153267 INFO: Loading module hook "hook-pydoc.py"... 153271 INFO: Loading module hook "hook-PyQt5.py"... 154046 WARNING: Hidden import "PyQt5.sip" not found! 154047 INFO: Loading module hook "hook-PyQt5.QtCore.py"... 154205 INFO: Loading module hook "hook-PyQt5.QtGui.py"... 154594 INFO: Loading module hook "hook-PyQt5.QtWidgets.py"... 155221 INFO: Loading module hook "hook-sqlite3.py"... 155607 INFO: Loading module hook "hook-xml.py"... 156039 INFO: Looking for ctypes DLLs 156040 INFO: Analyzing run-time hooks ... 156047 INFO: Including run-time hook 'pyi_rth_qt5.py' 156059 INFO: Looking for dynamic libraries 157070 INFO: Looking for eggs 157071 INFO: Using Python library C:\Users\mestrera\AppData\Local\Continuum\miniconda3\python36.dll 157071 INFO: Found binding redirects: [] 157081 INFO: Warnings written to C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\build\userLogin\warn-userLogin.txt 157157 INFO: Graph cross-reference written to C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\build\userLogin\xref-userLogin.html 157180 INFO: Appending 'datas' from .spec 157187 INFO: checking PYZ 157188 INFO: Building PYZ because PYZ-00.toc is non existent 157189 INFO: Building PYZ (ZlibArchive) C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\build\userLogin\PYZ-00.pyz 157833 INFO: Building PYZ (ZlibArchive) C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\build\userLogin\PYZ-00.pyz completed successfully. 157854 INFO: checking PKG 157854 INFO: Building PKG because PKG-00.toc is non existent 157855 INFO: Building PKG (CArchive) PKG-00.pkg 169243 INFO: Building PKG (CArchive) PKG-00.pkg completed successfully. 169263 INFO: Bootloader C:\Users\mestrera\AppData\Local\Continuum\miniconda3\lib\site-packages\PyInstaller\bootloader\Windows-64bit\runw.exe 169264 INFO: checking EXE 169266 INFO: Building EXE because EXE-00.toc is non existent 169267 INFO: Building EXE from EXE-00.toc 169301 INFO: SRCPATH [('C:\\Users\\mestrera\\Desktop\\Classroom\\workProjects\\userControl - Copy (2)\\icons8_bar_chart_64_C26_icon.ico', None)] 169304 INFO: Updating icons from ['C:\\Users\\mestrera\\Desktop\\Classroom\\workProjects\\userControl - Copy (2)\\icons8_bar_chart_64_C26_icon.ico'] to C:\Users\mestrera\AppData\Local\Temp\tmpk11q8j21 169311 INFO: Writing RT_GROUP_ICON 0 resource with 76 bytes 169313 INFO: Writing RT_ICON 1 resource with 1128 bytes 169314 INFO: Writing RT_ICON 2 resource with 2440 bytes 169315 INFO: Writing RT_ICON 3 resource with 4264 bytes 169315 INFO: Writing RT_ICON 4 resource with 9640 bytes 169316 INFO: Writing RT_ICON 5 resource with 17252 bytes 169333 INFO: Appending archive to EXE C:\Users\mestrera\Desktop\Classroom\GitHub\auto-py-to-exe\dist\userLogin.exe 169796 INFO: Building EXE from EXE-00.toc completed successfully. Moving project to: output/ Cleaning workspace Complete.
Author
Owner

@brentvollebregt commented on GitHub (Nov 23, 2018):

This doesn't show much, you need proof of why it isn't working. Try debugging the application, output is still printed to stdout. You can read my small tutorial on debugging in my post on Issues When Using auto-py-to-exe.

<!-- gh-comment-id:441193799 --> @brentvollebregt commented on GitHub (Nov 23, 2018): This doesn't show much, you need proof of why it isn't working. Try debugging the application, output is still printed to stdout. You can read my small tutorial on debugging in my post on [Issues When Using auto-py-to-exe](https://nitratine.net/blog/post/issues-when-using-auto-py-to-exe/).
Author
Owner

@brentvollebregt commented on GitHub (Feb 20, 2019):

Closing due to no reply from @supernooba

<!-- gh-comment-id:465458285 --> @brentvollebregt commented on GitHub (Feb 20, 2019): Closing due to no reply from @supernooba
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/auto-py-to-exe#34
No description provided.