I removed all scripts but this one and tried to maintain backup db. Same error message : "vacuum etc." Fresh db maintains just fine.
The restore process seems to fail at playlists import with message (in french, translation is mine):
- Code: Select all
"Problem in database query:
Error executing SQL "SELECT GROUP_concat'Dstlists.ID) from backujpDb.Lists INNER JOIN LISTS as DstLists.Textdata=DstLists.Textdata WHERE Srclists.IdListType = 3 AND SrcList.ID IN (Occasion)
" :No such column:Occasion (1,1)
Occasion is not a custom Field. I build AutoPlaylists with the "occasion" field (as a mean to setup relevant sets for my live gig.
Importing everything but autoplaylists returns:
- Code: Select all
Error executing SQL "SELECT Songs.*
WHERE INSERT Into Filters (Pos, Name, Cond, View, Player, ContentType) SELECT 11, SrcFilters.Name, Cond, View, Player, COntentType FROM BAckupDB.Filters AS SrcFilters WHERE SrcFilters.Name = "Evalué" GROUP BY SrcFilters.NameID 5SELECT SongsID FROM DBSync
": near "INSERT" Syntax error (1,1)
"Evalué" is a filter I created yesterday and is not linked to db corruption. Interesting that it would the last created filter though. Next error message reports "Line 2170, column 12".
Running import without filters... Success, Import in 13.42 seconds (I'm impressed)
Full maintenance passes, which is a relief. restoring Magic Nodes: OK.
What I Should have now is a healthy Db without autoplaylists or filters.
Only, filters show just fine. And some AutoPlaylists are there. Will recreate the rest manually.
I'm more than happy with the process : db now passes maintenance and I have recovered most of my data.
As for the impressive performance (have no idea how such speed can happen), it probably should be noted that MM runs with the SQLiteSafety=0 switch and both db's sit on a ram disk. Computer is a core i7 with Xp Sp3.
I would welcome any input on what might have happened. I'm willing to start over if you're interested in detailed debugging. using custom fields along with "occasion", "mood" and other fields in both autoplaylists and filters probably has something to do with the errors.