Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

Googled the problem and found this:
https://www.sqlite.org/fts3.html#section_2

• If a build of SQLite does not include the FTS modules, then any attempt to prepare an SQL statement to create an FTS3 or FTS4 table or to drop or access an existing FTS table in any way will fail. The error message returned will be similar to "no such module: ftsN" (where N is either 3 or 4).

Since that seemed to suggest the sqlite3.dll in your executable binary distro was built without FTS4, I hunted down an x86 version that did (the x64 version didn't work, since your app is x86, apparently). After putting the DLLs, the executable, and the importing .m3u all in the same directory...
IT WORKED! I now have the test .m3u successfully imported into the Plex Playlists, and it plays!
I can't believe the Plex folks cannot figure out how to do this on their own.  You're my hero for the day!
Many thanks for your patience, advice and hard work on this.

I've disabled the services using sqllite3.dll, rebooted, and confirmed those services are not running. I've also not started PMS.
When I run the batch file that launches PlexPlaylistImporter.exe, however, after answering 'y' to create the new PMS playlist, I get the same error:   Plex playlist is not already created. Would you like to create it now (y/n)? y   DB Error: no such module: fts4
I've verified in the Registry (HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\KnownDLLs) and in Process Explorer that the sqllite3.dll in the PlexPlaylistImporter.exe folder – C:\Program Files (x86)\PlexPlaylistImporter – is not known to the system. The same is true of the python34.dll in the same PPI folder. It looks to me like the program is failing to find and load the DLLs.
Any suggestions?
Thanks!

Yes, the sqlite3.dll is in the same folder as the executable.
A quick check in Process Explorer shows three other active instances of two separate sqlite3.dll copies: - Backup software infrastructure component; I may be able to stop this service, reboot, and proceed without having the service restart, so it's at least something I can try. - PlexDLNAServer.exe - PMS
If I don't need PMS running when doing the import, this should be manageable. Both PMS and the DLNA server use the same copy in the PMS directory.
I'll note that a Win Explorer search found 9 separate copies of sqlite3.dll, all with different dates and sizes, including some not currently active: - PlexPlaylistImporter - PMS - MediaMonkey (which I'm using til I get music playlist imports to work in PMS) - Kodi (ditto; horse race for which gets there first) - Backup software - Security software
Thanks!

Just to make sure... you do have the sqlite3.dll in the same directory as the PlexPlaylistImporter.exe, right?

Yeah, my next guess was going to be that it was choosing the wrong dll.

The article I linked says:

• If a DLL with the same module name is already loaded in memory, the  system uses the loaded DLL, no matter which directory it is in. The  system does not search for the DLL.
• If the  DLL is on the list of known DLLs for the version of Windows  on which the application is running, the system uses its copy of the  known DLL (and the known DLL's dependent DLLs, if any). The system does  not search for the DLL. For a list of known DLLs on the current system,  see the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\KnownDLLs.     

So it is most likely the first one. Is it possible for you to temporarily unload the program that is using it? You can also search for DLL usage handles by using Process Explorer. In the find menu there is a "Find Handle or DLL... (Ctrl+F)" option.
If you are unable to stop the other process, you can try manually replacing the .dll in its folder, but that is risky

You're correct - I'm using your binary from here.

I copied all the content from the downloaded Zip archive to a corresponding folder: C:\Program Files (x86)\PlexPlaylistImporter\.

I don't have SQL Lite installed per se; I only have PMS (latest version) installed and running. Do I need to do anything else to ensure the correct DLLs get used?

Thanks!

Find all directories that do not contain subdirectories

Code: [Select]

find -type d -exec sh -c 'test `find "{}/" -mindepth 1 -type d | wc -l` -eq 0' ';' -print

From an internet search "This error is happening because of [your] build of SQLite does not include the FTS modules." So I'd guess that either your sqlite3 libs, or python sqlite3 libs need to be updated. I really need to get a windows executable compiled for it...

You might want to try using the provided executable instead. It is at the top of the project page under "Downloads: Binary".

[Edit] After rereading your message... are you already using the executable I provided?

Background: running PlexPlaylistImporter.exe on the PMS host (Win 7 x64 SP1 fully patched, PMS 0.9.16.6.1993 - latest version).

Testing import of an m3u music playlist; edited to ensure full paths to all mp3 files including drive letter are in the m3u.

I get the prompt to create the new PMS playlist (it doesn't already exist), and after answering 'y' to the prompt, I get the following:
DB Error: no such module: fts4

Explicitly identifying the PMS database path and filename in the command line made no difference.

Do I separately need to install and run Python 3, or is the one on the (running) PMS sufficient?

TIA,
S

@Pierre: Are you sure you are running Python3 and not Python2?

@ulle: I'm not exactly sure what you are trying to ask. Any user could potentially use the software as long as they meet 3 conditions:

• They have python 3 installed (and any dependent libraries)
• They have access to the playlist and the files inside the playlist
• They have access to write to the plex database file
  

Just found out that adding "winsymlinks:nativestrict" to your CYGWIN variable in bash makes all internal symlinks use actual windows NTFS symlinks. This is a MUCH better solution, as it will then support all commands that work with symlinks, including rsync.