Error executing SQL (Select * from TmpADFFolder...

This forum is for reporting bugs in MediaMonkey for Windows 4. Note that version 4 is no longer actively maintained as it has been replaced by version 5.

Moderator: Gurus

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

Error executing SQL (Select * from TmpADFFolder...

Post by MMuser2011 »

I try to "Maintain Library" ("Archiv warten"). The last point "Optimize Database (complete)" ("Datenbank optimieren (komplett)") creates the following error:

Code: Select all

Error executing SQL "select * from TmpADFFolder1-1" : near "-": syntax error (1,1)
I can "cancel" or "repeat" or "ignore" this error message.

If I "ignore" this error message, the process run forever and I have to kill MediaMonkey in the Windows Taskmanager. After restarting MediaMonkey, a second run will no more produce any error.

After adding some new tracks, this SQL error appears again.

I have no Podcasts or any external synchronising device in my MediaMonkey (v4.1.3.1708)
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
Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

Re: Error executing SQL (Select * from TmpADFFolder...

Post by Mizery_Made »

This table is placed in the database by the "Advanced Duplicate Find & Fix" script.
Peke
Posts: 17484
Joined: Tue Jun 10, 2003 7:21 pm
Location: Earth
Contact:

Re: Error executing SQL (Select * from TmpADFFolder...

Post by Peke »

Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
Image
How to attach PICTURE/SCREENSHOTS to forum posts
Post Reply