Snippets install gives "unable to find the database"

Terry Wysocki

New to npp, just installed snippets plugin. When i run it I get the database error message and when I exit npp I get another error saying “Filename not set”. I’ve gone to the home page for the plugin and it says “NppSnippets.sqlite to the plugins/Config directory in your AppData” but of course, that file does not exist in the download. WTF. How do I install this plugin?

Terry Wysocki

Solved it myself! I found this video on Youtube that got it to work:
https://www.youtube.com/watch?v=NabHFvpAJCs
I didn’t uninstall my 64 bit system as he suggests, I just copied the downloaded folder and file into my Program Files\Notepad++\Plugins folder and now it works!

chcg

PluginManager could do it for you. The installation commands there:

Download https://github.com/ffes/nppsnippets/releases/download/v1.4.0/NppSnippets-140-x32.zip MD5: bc30a2ff3af968e66cf7e192cd5b7bb1
Copy from: NppSnippets.dll To: $PLUGINDIR$\ Validate Directory
Copy from: NppSnippets\SQL\*.sql To: $PLUGINDIR$\NppSnippets\SQL Directory
Copy from: NppSnippets\*.html To: $PLUGINDIR$\NppSnippets Directory
Copy from: NppSnippets\*.pdf To: $PLUGINDIR$\NppSnippets Directory
Copy from: NppSnippets\*.sqlite To: $PLUGINDIR$\NppSnippets Directory

dinkumoil

@chcg

On YouTube you can find a lot of videos showing how to install this plugin manually. The problem is that the copy commands provided in PluginManager’s XML file are buggy.

In the downloaded file there is no folder NppSnippets\SQL. Instead the SQL files are located in NppSnippets directly. The absence of these files after plugin’s installation causes it to fail.

Also the copy commands for the *.html and *.pdf files are superfluous, the downloaded ZIP doesn’t contain files of these types.

chcg

@dinkumoil Thanks for the hint. Indeed the copy operations are just matching to snippets 1.3 and were not adapted to the changes with 1.4.

chcg

I corrected that for the 32bit and 64bit versions PM plugin devlist right now.

Ridwanur rahman

just follow these steps .I found it from nppsnippets official website->

The easiest way to install this plugin is by using the Plugin Manager: from the “Plugins” menu, choose the “Plugin Manager” and “Show Plugin Manager”. Select the “Snippets” plugin and choose “install” and follow the instructions on the screen.

To manually install the plugin, copy NppSnippets.dll to the plugins directory and copy Template.sqlite to the plugins/config directory in the user’s “Application Data” directory and name it NppSnippets.sqlite. On my Windows 7 machine this directory is C:\Users\Frank\AppData\Roaming\Notepad++\plugins\config. Then (re)start Notepad++.

Meta Chuh

welcome to the notepad++ community, @Ridwanur-rahman
thank you for your guide and your time to share.

please note that your guide about installing NPP Snippets, albeit being correct, will currently only work on notepad++ 7.5.9 and below.
“Plugin Manager” is not compatible with notepad++ version 7.6 and above, as the plugins folder structure has changed.

for example a correct guide to install the Snippets plugin on notepad++ 7.6.2 (32 and 64 bit, installed version, not portable) would be:

install Snippets using the official, built in Plugins Admin in the notepad++ plugin menu
open an explorer window and enter following address in the address bar:
%ProgramData%\Notepad++\plugins\NppSnippets\NppSnippets\
copy Template.sqlite to %AppData%\Notepad++\plugins\config
rename Template.sqlite to NppSnippets.sqlite
restart notepad++

note: the plugin folder structure is in transition, so a guide for 7.6.2 will probably not work on 7.6.3 or 7.6.1 and below

B E86

The solution is simple guys, really. Open your %appdata%\Notepad++\plugins\config\NppSnippets.ini file and add the entry:

DBFile=“YOUR-FULL-NOTEPAD-INSTALLATION-FOLDER\plugins\NppSnippets\NppSnippets\Template.sqlite”

So if you installed Notepad++ to “C:\Program Files (x86)\Notepad++” then you would add the following line to the end of your \NppSnippets.ini file:

DBFile=“C:\Program Files (x86)\Notepad++\plugins\NppSnippets\NppSnippets\Template.sqlite”

andrecool-68

Move all the files of the plugin into one directory, and nothing needs to be renamed

Imgur