Sqlite 3 ImportError #46526

New Issue

laurenz steiner · 2015-10-18T12:09:00+02:00

laurenz steiner commented

2015-10-18 12:09:00 +02:00

System Information
Operating system and graphics card
Windows 10
Blender Version
Broken: 2.75a from 2015-07-07

With some files the DLL load failed error appears.
Short description of error

Exact steps for others to reproduce the error
Start the bug_test.blend and read the console text.bug.zip

**System Information** Operating system and graphics card Windows 10 **Blender Version** Broken: 2.75a from 2015-07-07 With some files the DLL load failed error appears. **Short description of error** **Exact steps for others to reproduce the error** Start the bug_test.blend and read the console text.[bug.zip](https://archive.blender.org/developer/F245740/bug.zip)

laurenz steiner commented

2015-10-18 12:09:00 +02:00

Changed status to: 'Open'

laurenz steiner commented

2015-10-18 12:09:00 +02:00

Added subscriber: @laurenz

Bastien Montagne commented

2015-10-18 12:19:41 +02:00

Added subscriber: @mont29

Bastien Montagne commented

2015-10-18 12:19:41 +02:00

First of all, please check against latest release (2.76). ;)

Also, please attach here the log text of the error in the console.

First of all, please check against latest release (2.76). ;) Also, please attach here the log text of the error in the console.

laurenz steiner commented

2015-10-18 18:32:59 +02:00

Hi, sry I didnt even notice the new release, but, i just tried it and it didnt work either.
and here is the console log:

Hi, sry I didnt even notice the new release, but, i just tried it and it didnt work either. and here is the console log: ![bug.jpg](https://archive.blender.org/developer/F245806/bug.jpg)

Bastien Montagne commented

2015-10-18 18:36:55 +02:00

Added subscriber: @MartijnBerger

Bastien Montagne commented

2015-10-18 18:36:55 +02:00

Find those .../2.76/2.76/... very suspicious… Does importing any other py module (os, sys, etc.) works?

@MartijnBerger I think that kind of path is not expected for embedded python?

Find those `.../2.76/2.76/...` very suspicious… Does importing any other py module (`os`, `sys`, etc.) works? @MartijnBerger I think that kind of path is not expected for embedded python?

laurenz steiner commented

2015-10-18 19:00:01 +02:00

Yeah, I dont have any problems with os or bge or pickle...just sqlite3 doesnt work always, but in a repeateable way. I have some files where it works without a problem, and then there are others where it doesnt work at all. like the one in the bug zip.

Campbell Barton commented

2015-10-19 09:53:48 +02:00

Added subscriber: @ideasman42

Campbell Barton commented

2015-10-19 09:53:48 +02:00

Likely Blender is installed in C:\Blender\2.76,

Could you attach the system-info output?
https://www.blender.org/manual/troubleshooting/general_help.html#system-info

Likely Blender is installed in `C:\Blender\2.76`, Could you attach the system-info output? https://www.blender.org/manual/troubleshooting/general_help.html#system-info

laurenz steiner commented

2015-10-19 18:34:54 +02:00

system-info.txt
Here is the system-info.txt
and no, blender is installed on D: in the matching release-directory

[system-info.txt](https://archive.blender.org/developer/F245920/system-info.txt) Here is the system-info.txt and no, blender is installed on D: in the matching release-directory

laurenz steiner commented

2015-10-22 19:46:50 +02:00

I now found out that the problem doesn't appear when I open the blend file with the open command instead of the shortcut or the file. Also the os command chdir(Blenderdirectory) solves the problem, but i still think that this is a bug, which should be fixed ;)

Sergey Sharybin commented

2015-11-03 12:49:02 +01:00

Added subscriber: @Sergey

Sergey Sharybin commented

2015-11-03 12:49:02 +01:00

Does it still happen with 2.76? And does this happen with other modules (os, sys, etc)?

laurenz steiner commented

2015-11-03 14:15:49 +01:00

Yes it still happens with 2.76 and no, at least I didnt notice any problems with other modules.

Martijn Berger was assigned by Sergey Sharybin

2016-01-26 16:56:56 +01:00

Sergey Sharybin commented

2016-01-26 16:56:56 +01:00

Either sqlite3.dll should either become static (_sqlite could stay dynamic, python knows how to deal with it) or we have add path with sqlite3 to the PATH variable from blender-app.exe.

@MartijnBerger, mind investigating if it's doable to make sqlite3.dll static now?

Either `sqlite3.dll` should either become static (_sqlite could stay dynamic, python knows how to deal with it) or we have add path with sqlite3 to the PATH variable from `blender-app.exe`. @MartijnBerger, mind investigating if it's doable to make sqlite3.dll static now?

Maxim commented

2016-02-02 19:53:38 +01:00

Added subscriber: @ShadowHunterRUS

hudson barkley commented

2016-02-02 23:18:49 +01:00

Added subscriber: @snuq

hudson barkley commented

2016-02-02 23:18:49 +01:00

This started happening on my computer, my script using sqlite3 would not work, and typing 'import sqlite3' in the python console would not work.
This was happening in any .blend file (even when I loaded the factory defaults), running blender from various locations, and in several different versions of blender.

If anyone else comes across this in a search before it is fixed, I managed to get it to import properly by adding the folder that contains the sqlite3.dll file (the blender main directory) to the windows 'Path' variable.

This started happening on my computer, my script using sqlite3 would not work, and typing 'import sqlite3' in the python console would not work. This was happening in any .blend file (even when I loaded the factory defaults), running blender from various locations, and in several different versions of blender. If anyone else comes across this in a search before it is fixed, I managed to get it to import properly by adding the folder that contains the sqlite3.dll file (the blender main directory) to the windows 'Path' variable.

Martijn Berger commented

2016-02-18 08:20:30 +01:00

Fixed in 2.77 and buildbots as of tomorrow