Program to edit MM SQLite DB?

Get answers about using the current release of MediaMonkey for Windows.

Moderator: Gurus

MelodyGabrielle
Posts: 1
Joined: Mon Dec 15, 2014 8:00 pm

Re: Program to edit MM SQLite DB?

Post by MelodyGabrielle » Mon Dec 15, 2014 8:05 pm

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
Posts: 3218
Joined: Mon Jan 24, 2011 6:34 pm

Re: Program to edit MM SQLite DB?

Post by dtsig » Tue Dec 16, 2014 9:30 am

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.
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

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

Re: Program to edit MM SQLite DB?

Post by MMuser2011 » Tue Dec 23, 2014 3:50 am

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
Last edited by MMuser2011 on Sat Dec 27, 2014 8:40 am, edited 3 times in total.
Magic Nodes v4.3.3 (2018-10-03) last free version 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.4.9 (2018-10-03) last free version

wawa79
Posts: 1
Joined: Sat Dec 27, 2014 8:26 am

Re: Program to edit MM SQLite DB?

Post by wawa79 » Sat Dec 27, 2014 8:28 am

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
Posts: 3218
Joined: Mon Jan 24, 2011 6:34 pm

Re: Program to edit MM SQLite DB?

Post by dtsig » Sat Dec 27, 2014 1:04 pm

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.
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig


byakuyabo
Posts: 5
Joined: Tue Nov 25, 2008 1:14 am

Editing MM.DB - IUNICODE error - MediaMonkey.DLL

Post by byakuyabo » Thu Mar 21, 2019 8:06 pm

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
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Program to edit MM SQLite DB?

Post by MMuser2011 » Fri Mar 22, 2019 2:27 am

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
Magic Nodes v4.3.3 (2018-10-03) last free version 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.4.9 (2018-10-03) last free version

Post Reply