The "MediaMonkey.DLL" is still included in the actual SQLiteSpy_1.9.13 ZIP-File from the author:
https://www.yunqa.de/delphi/products/sqlitespy/index

Hello. I would like to perform some mass edits to the contents of MM.DB (I did save a backup copy). I can query the table contents without any trouble. The problem is that when I attempt to UPDATE a text field (Songs.SongPath), I get the error "no such collation sequence: IUNICODE". I have tried SQLiteStudio and SQLiteSpy.

I found a couple of old threads discussing this issue:

[url]http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=77512[/url]
[url]http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=77570[/url]

These posts advise adding "MediaMonkey.DLL" to the Extensions in SQLiteSpy. However, there no longer appears to be any DLL by that name included in my installation (V4), so predictably, I get the error "The specified module could not be found." when trying to load the database. I noticed that there is a file called "SQLite3MM.dll", so I tried that one. This time it finds the file, but I get a different error when trying to load the database: "The specified procedure could not be found.".

Any suggestions? Thanks!

See
http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=77570&p=421241#p421241

I believe the reason is that it is text fields that need to be changed. The only reason to do this is an attempt to work with multiple languages. Otherwise it is just a way to take up cycles.

UPDATE Songs SET Custom1="Blabla"  WHERE IDAlbum = (SELECT IDAlbum FROM Songs WHERE SongPath="\\DISQUERESEAU\Nos documents\Nos musiques\Abd Al Malik\Gibraltar\08 - Abd Al Malik - Le Grand Frère.flac");

UPDATE Songs SET Rating=5 WHERE IDAlbum = (SELECT IDAlbum FROM Songs WHERE SongPath="\\DISQUERESEAU\Nos documents\Nos musiques\Abd Al Malik\Gibraltar\08 - Abd Al Malik - Le Grand Frère.flac");

Same 'mm:unknown tokenizer' when running the following update query:

[code]UPDATE Songs SET Custom1="Blabla" WHERE IDAlbum = (SELECT IDAlbum FROM Songs WHERE SongPath="\\DISQUERESEAU\Nos documents\Nos musiques\Abd Al Malik\Gibraltar\08 - Abd Al Malik - Le Grand Frère.flac");[/code]

But the following works:

[code]UPDATE Songs SET Rating=5 WHERE IDAlbum = (SELECT IDAlbum FROM Songs WHERE SongPath="\\DISQUERESEAU\Nos documents\Nos musiques\Abd Al Malik\Gibraltar\08 - Abd Al Malik - Le Grand Frère.flac");[/code]

So it seems the error is raised when trying to write into a text field. Can anybody help? I am also running a Gold version and would appreciate some support on this.

[09:48:42] Error while executing SQL query: unknown tokenizer: mm

Nice program (previous answer with link to http://sqlitestudio.pl/ was deleted after writing this), but it doesn't work...

Same problem as I wrote in http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=77512&start=15#p396488
[code][09:48:42] Error while executing SQL query: unknown tokenizer: mm[/code]

Don't have MMW accessible right now but I believe there is a 'find missing songs' option and an enhanced script in the Addons section. These can be used to find/rename pathing info.

I too am getting the tokenizer error message.

"unknown tokenizer: mm"

I need to update pathing information for drives/songs since I moved computers. I have paid for Media Monkey, please support me in my needs for the software.

Please provide updated files / database definitions for this tokenizer.

Thanks for your help

UPDATE Songs SET IDMedia=9 WHERE IDMedia=7 AND SongPath LIKE '%mp3\M\%'

[quote="PetrCBR"]When your SQLite editor supports SQLite Extensions (like SQLite Maestro, Database Browser for SQLite), you can download our extension from [url=http://www.ventismedia.com/mantis/view.php?id=11083]here[/url] to support IUNICODE.[/quote]Unfortunately your extension doesn't work with [url=https://github.com/sqlitebrowser/sqlitebrowser/releases]Database Browser for SQLite[/url].

If you try an UPDATE command on the 'Songs' table like this:
[code]UPDATE Songs SET IDMedia=9 WHERE IDMedia=7 AND SongPath LIKE '%mp3\M\%'[/code]you get the error "[color=#FF0000][b]unknown tokenizer: mm[/b][/color]".

Therefore I kindly ask you again to answer my question:
What exactly should your tokenizer do?

Can you please fix your extension (attached to the above ticket [url=http://www.ventismedia.com/mantis/view.php?id=11083]11083[/url]) in a way to enable commands like UPDATE?

Yes, I believe it. :wink:
But how do you do that? How exactly your "mm tokenizer" works?
('mm' is the only part that seems not to be a field of any table).

Should the table "SongText" contain data or not?

We're using our tokenizer for better search results.

CREATE VIRTUAL TABLE SongsText USING FTS3(TOKENIZE mm ,artist,album,albumartist,songtitle,genre,songpath,author,lyricist,conductor,groupdesc,subtitle,lyrics,comment,custom1,custom2,custom3,custom4,custom5,origartist,origtitle,origlyricist,publisher,encoder,copyright,mood,tempo,occasion,quality,involvedpeople,producer,actors)

If I load your extension with the free [url=http://sqlitebrowser.org/]SQLite Database Browser[/url] I don't get any result in the tab "Browse data" for the virtual table 'SongsText'. Should there be any visible entry?

@PetrCBR: Can you please tell us, whats behind the unknown tokenizer 'mm' in [code]CREATE VIRTUAL TABLE SongsText USING FTS3(TOKENIZE mm ,artist,album,albumartist,songtitle,genre,songpath,author,lyricist,conductor,groupdesc,subtitle,lyrics,comment,custom1,custom2,custom3,custom4,custom5,origartist,origtitle,origlyricist,publisher,encoder,copyright,mood,tempo,occasion,quality,involvedpeople,producer,actors)[/code]

Try to replace sqlite.dll from the app with SQlite3MM.dll from MM folder.

Would be interesting to know what exactly is the 'magic' behind this song text tokenizer.

[quote="MMuser2011"]No, I don't think so.
Because no one has published how this tokenizer works. Or do YOU know, what command is used?[/quote]

I don't but I think PetrCBR, an MM Dev, may do.