MM5 Crashes at startup trying to do an SQL insert

Report bugs & feature requests for MediaMonkey 5 and learn about the newest builds.

Moderator: Gurus

dctim1906
Posts: 2
Joined: Fri Sep 07, 2012 11:11 pm

MM5 Crashes at startup trying to do an SQL insert

Post by dctim1906 » Tue Mar 12, 2019 12:54 pm

I reloaded the latestMM5.
The error says:
There was a problem querying the database:
Error executing SQL "INSERT INTO Songs( Songpath,.....Sampli":no such table:main.SongsText(1,1)

Can someone help with this?

It was working fine until I cleared the database.

Thanks

dctim1906
Posts: 2
Joined: Fri Sep 07, 2012 11:11 pm

Re: MM5 Crashes at startup trying to do an SQL insert

Post by dctim1906 » Tue Mar 12, 2019 1:34 pm

I reinstalled using "Portable Installation", the program asked to import my MM4 database and now this is working.

Barry4679
Posts: 656
Joined: Fri Sep 11, 2009 8:07 am
Location: Australia
Contact:

Re: MM5 Crashes at startup trying to do an SQL insert

Post by Barry4679 » Tue Mar 12, 2019 9:36 pm

dctim1906 wrote:
Tue Mar 12, 2019 12:54 pm
It was working fine until I cleared the database.
How did you "clear" the database? ... Using the clear option at File|ManageDatabase menu option? ... maybe it has a problem.

If you want to proceed with further testing, I suggest that you close MM5, and trying deleting the MM.db file using Windows Explorer, and then restart MM5 .... it should offer to re-import your db data from MM4.

You can see your database location by entering the BackupDatabaseNow option at File|ManageDatabase

Ludek
Posts: 2887
Joined: Fri Mar 09, 2007 9:00 am

Re: MM5 Crashes at startup trying to do an SQL insert

Post by Ludek » Wed Mar 13, 2019 6:36 am

I have just tested the 'Crear database...' feature (from the Manage database dialog) and it proceeded just fine,
and I haven't been facing any error when subsequently adding tracks to library (i.e. the SongsText table is there)

Post Reply