Program to edit MM SQLite DB?

[MelodyGabrielle]

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

[dtsig]

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.

[MMuser2011]

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/viewto ... 15#p396488

Code: Select all

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

[wawa79]

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

Code: Select all

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");

But the following works:

Code: Select all

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");

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.

[dtsig]

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.

[frz]

See
http://www.mediamonkey.com/forum/viewto ... 41#p421241

[byakuyabo]

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:

http://www.mediamonkey.com/forum/viewto ... =1&t=77512
http://www.mediamonkey.com/forum/viewto ... =1&t=77570

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!

[MMuser2011]

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