SABnzbd Fails to Start (0.5.2) Sqlite Error

[naneil]

Hi guys,
I'm having some problems with SABnzbd, on a Windows 7 system where it has worked fine for some time.

Problem: Running sabnzbd.exe does nothing. The logs are not touched. If I run sabnzbd-console.exe, it gives an error : "Sorry, requires Python module sqlite3 (pysqlite2 in python 2.4).

I've tried:
- Removing my antivirus - no change. It was only an on demand bit-defender scanner anyway.
- Uninstalling completely, installing to a new directory - same issue.
- Downloading the windows .zip and running from that - same issue.
- Checked 'lib' directory - sqlite3.dll is present.

I recently installed a python distribution, Enthought, for my degree course, but I don't think this should affect it, and it's been on here before with no issues.


Any ideas? Thanks.

[shypike]

Check your virus scanner. The foolish program has probably removed sqlite3.dll.
Re-install and watch it.

[naneil]

I've done both, see above. sqlite3.dll was always there, and my AV is removed.

[naneil]

http://forums.sabnzbd.org/index.php?topic=3480.0

Just for reference for anyone reading this, same issue here, though I've not tried replacing the .dll with one from the sqlite.org site yet. I too have a python distribution installed, so I think this is the problem, it must be finding the wrong dlls from my PATH...


Edit: OK! I swapped out the included .dll with the one from sqlite.org, and it now works fine. Weird. I can now confirm this is a bug.

[shypike]

I recently installed a python distribution, Enthought, for my degree course, but I don't think this should affect it, and it's been on here before with no issues.

Sorry, I didn't read your post careful enough.
It has nothing to with the virus scanner.
We only support standard Python distributions from python.org and  activestate.com (preferred).
Anything else, and you're on your own.

[naneil]

Thanks shypike.

Thing is  - I don't get why it's touching my python distribution at all. And if it is the other distribution causing the problems, why does replacing the sqlite3.dll that is inside of the sabnzbd folder fix it? Doesn't make sense.

As I'm running the windows binaries, and it runs without python itself being installed, this seems weird. Though I might be missing something!

Thanks for your help

[shypike]

Possibly SABnzbd's Python finds your previously installed sqlite3.dll before it finds its own.
Is the location of sqlite3.dll in your PATH?
Welcome to Windows DLL-Hell

[naneil]

Code: Select all

C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common
d:\Program Files (x86)\MiKTeX 2.8\miktex\bin;d:\watcom-1.3\binnt
d:\watcom-1.3\binw;C:\Program Files (x86)\PC Connectivity Solution
%SystemRoot%\system32
%SystemRoot%
%SystemRoot%\System32\Wbem
%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\
d:\Program Files\MATLAB\R2007b\bi
d:\Program Files\MATLAB\R2007b\bin\win64
C:\Program Files (x86)\Python25
C:\Program Files (x86)\Python25\Scripts
D:\Python26
D:\Python26\Scripts
C:\Program Files (x86)\Common Files\ACD Systems\EN
C:\Program Files (x86)\Common Files\ACD Systems

The above is my path. I guess it's finding one of the wrong sqlite3.dll s, but its strange that overwriting the one in the sabnzbd lib directory with a fresh one fixes the issue...

Anyway, working now. Just thought I'd post this in case it is a bug, and to help anyone else stumbling across the same issue

[shypike]

but its strange that overwriting the one in the sabnzbd lib directory with a fresh one fixes the issue...

It's likely a bug in the Python run-time system, combined with the way
Windows deals with DLLs and the fact that the sqlite people distribute different
versions of sqlite3.dll under the exact same filename.
Possibly we can improve the way the error message is given a bit.

[vdkraan]

I replaced de Sqlite.dll in the C:\Program Files\SABnzbd\lib with the version
of my Python3.1 installation. Hope this helps for you too.