version 3.1 of MM.DB wont open in SQLiteBrowser 1.3

This forum is for questions / discussions regarding development of addons / tweaks for MediaMonkey.

Moderator: Gurus

Beoraohstan

version 3.1 of MM.DB wont open in SQLiteBrowser 1.3

Post by Beoraohstan » Sun Jul 26, 2009 2:53 pm

Hello all,

I noticed that my 3.0 version of MM.DB will open just fine in the SQLiteBrowser 1.3, but it seems that since the ugprade to 3.1, the MM.DB wont open anymore in the SQLiteBrowser.

Any ideas?

Thanks,

beo

DazB
Posts: 409
Joined: Mon Jun 11, 2007 4:09 am
Location: Yorkshire, UK

Re: version 3.1 of MM.DB wont open in SQLiteBrowser 1.3

Post by DazB » Sun Jul 26, 2009 5:45 pm

Hi,

It will be the implementation of full-text search.

Daz

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: version 3.1 of MM.DB wont open in SQLiteBrowser 1.3

Post by Bex » Mon Jul 27, 2009 6:03 pm

You can try this script:
http://mediamonkey.com/forum/viewtopic.php?f=2&t=24841
Not as fancy as other SQLIte programs, but it doesn't give you any errors...
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: version 3.1 of MM.DB wont open in SQLiteBrowser 1.3

Post by Owyn » Wed Oct 21, 2009 3:54 pm

Bex's SQL Viewer script is highly recommended and the only way I know to browse/update the MM3 database with all MM3 specific sqlite functions intact.

An alternate sqlite manager is SQLiteMan. It will complain about FTS3 (MM3's full text search module) but is otherwise fine as a browser, i.e. read only.
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies

Post Reply