Database error when opening: SongsText table

[clayboy]

Version 4.1.22.1880

As MediaMonkey is opening, and MM is monitoring files, I get a series of popups. Each of them has the following error:
There was a problem querying the database: Error executing SQL "UPDATE Songs SET
SongPath=?, Artist=?, IdAlbum ... (<other fieldnames>)
...Actors=?,Producer=?,BitRate=?,F" : no such table: main.SongsText (1,1)

There is no table in the DB named "SongsText", but there are 3 similarly-named tables:
SongsText_content
SongsText_segdir
SongsText_segments

I wonder if this has anything to do with it. I just repaired my database. I used DB Browser for SQLite to Export to a SQL file, then Imported from the SQL file.
If you need any more information, please let me know.

[Lowlander]

Try 4.1.23: https://www.mediamonkey.com/forum/viewt ... =8811&sd=d

[clayboy]

No such luck. I installed, started up MediaMonkey, and still got the popups.

Looked at Help...About, and verified that I had version 4.1.23.1881.

It seems that the app and the database don't match. Is there a table I can look at to see which version of the app it is supposed to run against?

Thanks.

[clayboy]

I found a table in the DB called "DBInfo". It has 4 rows:
IDInfo InfoValue InfoString
1 4 null
2 1 null
3 42 null
10 1821544534 null

I don't know if this helps at all.

[PetrCBR]

Try to open maintain database (from file menu) and rebuild full-text search index.

[Peke]

Hi,
We had one similar report and solution for him was to install MMW as Portable to c:\MMWPortable and after that all started to work.

[clayboy]

PetrCBR's idea worked. The exact menu items are File...Maintain Library...Rebuild Full-Text Search index.

MediaMonkey ended up locking up, but after I killed it in Task Manager, it started back up just fine.

I can see the SongsText table now if I look at the database in DB Browser for SQLite.

Thanks!

[midwayer606s]

And it goes on to list several database headers such as SongPath, Artist, IDAlbum, Album, and this is just the beginning of the list. This message appears after the initial start up of the application. FWIW, I purchased a lifetime subscription. The list ends with "No such table. main.SongsText (1,1) Once this popup appears I am dead in the water. No response from the app and I have to use task manager to kill it.

Any suggestions?

[midwayer606s]

Upgrading to *.30 didn't help. I can tell you though, this issue happens after invoking "Elevator".
Thanks so for far for the advice.

[midwayer606s]

Just wanted to let those following this thread know that setting up in portable mode solved my issue. Thanks for the tip.