Program to edit MM SQLite DB?

Post a reply


In an effort to prevent automatic submissions, we require that you complete the following challenge.
Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Program to edit MM SQLite DB?

Re: Program to edit MM SQLite DB?

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

Editing MM.DB - IUNICODE error - MediaMonkey.DLL

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!

Re: Program to edit MM SQLite DB?

by frz » Tue Mar 15, 2016 1:04 pm

Re: Program to edit MM SQLite DB?

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.

Re: Program to edit MM SQLite DB?

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.

Re: Program to edit MM SQLite DB?

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

Re: Program to edit MM SQLite DB?

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.

Re: Program to edit MM SQLite DB?

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

Re: Program to edit MM SQLite DB?

by MMuser2011 » Mon Oct 06, 2014 4:18 am

PetrCBR wrote:When your SQLite editor supports SQLite Extensions (like SQLite Maestro, Database Browser for SQLite), you can download our extension from here to support IUNICODE.
Unfortunately your extension doesn't work with Database Browser for SQLite.

If you try an UPDATE command on the 'Songs' table like this:

Code: Select all

UPDATE Songs SET IDMedia=9 WHERE IDMedia=7 AND SongPath LIKE '%mp3\M\%'
you get the error "unknown tokenizer: mm".

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 11083) in a way to enable commands like UPDATE?

Re: Program to edit MM SQLite DB?

by MMuser2011 » Sun Sep 07, 2014 5:13 am

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?

Re: Program to edit MM SQLite DB?

by PetrCBR » Sun Sep 07, 2014 5:04 am

We're using our tokenizer for better search results.

Re: Program to edit MM SQLite DB?

by MMuser2011 » Sat Sep 06, 2014 5:01 am

If I load your extension with the free SQLite Database Browser 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: Select all

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)

Re: Program to edit MM SQLite DB?

by PetrCBR » Fri Sep 05, 2014 1:27 pm

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

Re: Program to edit MM SQLite DB?

by MMuser2011 » Fri Sep 05, 2014 1:18 pm

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

Re: Program to edit MM SQLite DB?

by chrisjj » Fri Sep 05, 2014 1:16 pm

MMuser2011 wrote:No, I don't think so.
Because no one has published how this tokenizer works. Or do YOU know, what command is used?
I don't but I think PetrCBR, an MM Dev, may do.

Top