unknown tokenizer: mm [#14334]

To get bugs in the current release fixed, please report them here.

Moderator: Gurus

skrutm
Posts: 18
Joined: Mon Apr 16, 2012 9:32 am

unknown tokenizer: mm [#14334]

Post by skrutm » Thu Aug 03, 2017 6:30 am

Hi,
I still have problems updating the DB with SQLite. I get "unknown tokenizer: mm" error. I want to do what other already tried... for example "UPDATE Songs SET IDMedia=9 WHERE IDMedia=7" I've tried to copy SQLite3MM, SQLite3MMExt over, I tried "SELECT load_extension('SQLite3MM.dll');" I tried it with SQLiteStudio and SQliteSpy... no success.
Can you please tell me exactly what I must do, queries to work.
Matjaz

Peke
Posts: 11203
Joined: Tue Jun 10, 2003 7:21 pm
Location: Serbia
Contact:

Re: unknown tokenizer: mm

Post by Peke » Thu Aug 03, 2017 9:28 pm

Best regards,
Pavle
MediaMonkey lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
How to add Images to forum

PetrCBR
Posts: 1432
Joined: Tue Mar 07, 2006 5:31 pm
Location: Czech
Contact:

Re: unknown tokenizer: mm

Post by PetrCBR » Fri Aug 04, 2017 5:13 am

SQLite often change API so your editor need to use same version as we're using (3.7.6.3).
SQLite3MM.dll is main SQLite engine (sqlite3.dll) with our tokenizer.
SQLite3MMExt.dll is extensions library we're using (collation, functions etc.). This extensions library should work on any SQLite version, however for updating database (change/add string values using UPDATE query) you need our tokenizer (for full text search), which is in main library.

skrutm
Posts: 18
Joined: Mon Apr 16, 2012 9:32 am

Re: unknown tokenizer: mm [#14334]

Post by skrutm » Thu Aug 17, 2017 12:14 am

I’m still confused. What version oif SQLiteSpy should I download? 1.9.0 that includes SQLite 3.7.6? Can you provide me with the link to the right version?
Thanks,
Matjaz

ITgreybeard
Posts: 13
Joined: Sat Feb 04, 2012 6:52 pm
Location: WA USA

Re: unknown tokenizer: mm [#14334]

Post by ITgreybeard » Thu May 03, 2018 6:15 pm

Is there a workable .dll to load into SQLiteSpy (or other such db tool) that makes possible both reading and writing to the current version of MediaMonkey?

I am running MM 4.1.20.1864 on Win10 Pro, am committed to MM as the best cataloging tool anywhere, have purchased the Lifetime Gold version, and have more than 35K audio tracks managed with it starting half a dozen years ago. I now want to catalog a video collection, but that is requiring some up-front tag massaging.

I am looking to craft a few special updates that would pertain to video files, and have downloaded a half-dozen SQLite-compatible tools to do so, including SQLiteSpy. When a copy of MediaMonkey.dll is placed in the same directory as the SQLiteSpy executable, SQLiteSpy works pretty well for reading, but falls down on updating, complaining that an unknown tokenizer 'mm' is missing.

Elsewhere in the forum it is suggested that SQLite3MM.dll and SQLite3MMExt.dll could work. So I have tested placing copies of SQLite3MM.dll and SQLite3MMExt.dll into the SQLite3 folder, and then loading them singly or in all possible combinations with MediaMonkey.dll via the tools/extensions interface on SQLiteSpy. Either of these two alternative dll's produces the error that 'the specified procedure could not be found,' though SQLite3Spy does not actually specify the procedure -- to me, that is.

ODBC proved an interesting but not useful tool, as errors persisted in sorting or joining data, though simple reading usually was successful. I could link tables to MS Access, but running much of anything sucked.

There is a reputed SQLite3 interface to Visual Studio, and while I have installed it, it seemed better to try these retail interfaces first.

So let me re-pose the question: Is there a workable.dll to load into SQLite3Spy (or other such db tool) that makes possible both reading and writing to the current version of MediaMonkey?

If not, I might try my hand at scripting, but I gravitate towards SQL, what with long career experience in the many variants and versions of the language.

Thanks. ITG
Last edited by ITgreybeard on Thu May 03, 2018 6:25 pm, edited 1 time in total.

ITgreybeard
Posts: 13
Joined: Sat Feb 04, 2012 6:52 pm
Location: WA USA

Re: unknown tokenizer: mm [#14334]

Post by ITgreybeard » Thu May 03, 2018 6:17 pm

Still an issue - Is there anything that I could do about it?
ITgreybeard : MM Lifetime Gold. Rescued and customized DELL T7400 (Qchan memory, PCI-e II, SATA II, on-board RAID): ++Dual QCore Xeon 3.0GHz, 32GB ECC, AMD W5000 wk graphics, SATA III and USB3.0 via cards, SSD and HDD aplenty. Win10 Pro +Ubuntu. Fallback= Custom ASUS i7-860 2.8GHz w/8GB mem, ATI FirePro V4800 (FireGL V) graphics card, multiple disks. Yes they're old :wink: but so am I ...

MMuser2011
Posts: 1225
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: unknown tokenizer: mm [#14334]

Post by MMuser2011 » Sun May 20, 2018 5:25 am

@Peke, @jiri, @rusty: Please let us know what we can do to solve this problem. The use of SQLite would really be helpful if we could manage/update the Songs table too.

Unfortunately
Petr provided the necessary info in the forum. I think that's sufficient since few users will be doing this.
doesn't help for the actual situation.
Magic Nodes v4.2 (2011-07-01) SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.3 (2011-07-06)

Post Reply