Can't browse Genre tree from Music node [1459]

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

crcm
Posts: 62
Joined: Wed Mar 16, 2005 12:13 am
Location: Finland

Can't browse Genre tree from Music node [1459]

Post by crcm »

Can't browse Genre tree from Music node. Got this error:
302.656s - PID:1168 - Forms:_RestoreTopMost:_Level:_1
302.656s - PID:1168 - Forms:_RestoreTopMost:_Starting
302.656s - PID:1168 - MainForm:_NC Activate +
302.672s - PID:1168 - Dialog:_There was a problem querying the database:_
Could not retrieve data "SELECT Genres.IDGenre, Genres.GenreName FROM Genres WHERE Genres.IDGenre IN (Select GenresSongs.IDGenre FROM
GenresSongs INNER JOIN Songs ON (GenresSongs.IDSong=Songs.ID AND ( Songs.TrackType in (0,4) ))) ORDER BY Genres.GenreName
" :_database disk image is malformed (11, 11) result:_5
302.672s - PID:1168 - 3992 DB lock finished, took 36031664.
Genre tree works in "Entire Library" and "Classical music" nodes but again it won't work in my custom "Musica Folder" node.
Database was working fine in MM3. MM4 freezes after error.

Debugged and mailed.
Last edited by Lowlander on Wed Nov 16, 2011 2:57 pm, edited 1 time in total.
Reason: Moved to Bug Report forum as MediaMonkey 4 is now a Final Release
crcm
Jerking monkey since 2005 - FINNISH Translator
MM4.X | Win7 enterprise sp1 | SPDIF earsex | Denon sushi | AKG hearing aid | Lumia 820 color blindness OR Samsung Galactical Voodoo magic
nohitter151
Posts: 23640
Joined: Wed Aug 09, 2006 10:20 am
Location: NJ, USA
Contact:

Re: Can't browse Genre tree from Music node [1459]

Post by nohitter151 »

database disk image is malformed (11, 11) errors usually indicate a corrupted database:
http://www.mediamonkey.com/support/inde ... ticleid=78
MediaMonkey user since 2006
Need help? Got a suggestion? Can't find something?

Please no PMs in reply to a post. Just reply in the thread.
crcm
Posts: 62
Joined: Wed Mar 16, 2005 12:13 am
Location: Finland

Re: Can't browse Genre tree from Music node [1459]

Post by crcm »

So MM4 corrupts MM3 database...or is MM4 just more "picky".
crcm
Jerking monkey since 2005 - FINNISH Translator
MM4.X | Win7 enterprise sp1 | SPDIF earsex | Denon sushi | AKG hearing aid | Lumia 820 color blindness OR Samsung Galactical Voodoo magic
Lowlander
Posts: 56492
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Can't browse Genre tree from Music node [1459]

Post by Lowlander »

You could try replacing the current MM4 database with the copy of the MM3 database and see if it resolves the problem. If it doesn't an full optimization in MediaMonkey 3 before upgrading to MediaMonkey 4 might be needed.
nohitter151
Posts: 23640
Joined: Wed Aug 09, 2006 10:20 am
Location: NJ, USA
Contact:

Re: Can't browse Genre tree from Music node [1459]

Post by nohitter151 »

crcm wrote:So MM4 corrupts MM3 database...
Maybe yours, but mine was imported without any problems (and hundreds of others who tested MM4). It might be valuable to get a copy of your MM3 database.
MediaMonkey user since 2006
Need help? Got a suggestion? Can't find something?

Please no PMs in reply to a post. Just reply in the thread.
crcm
Posts: 62
Joined: Wed Mar 16, 2005 12:13 am
Location: Finland

Re: Can't browse Genre tree from Music node [1459]

Post by crcm »

Well I have backups from my database up to 50 days. Tried the optimization. No luck. Maybe I try the clean install again.
crcm
Jerking monkey since 2005 - FINNISH Translator
MM4.X | Win7 enterprise sp1 | SPDIF earsex | Denon sushi | AKG hearing aid | Lumia 820 color blindness OR Samsung Galactical Voodoo magic
crcm
Posts: 62
Joined: Wed Mar 16, 2005 12:13 am
Location: Finland

Re: Can't browse Genre tree from Music node [1459]

Post by crcm »

Well well. Noticed some ghost genres..which I can't remove (MM3). Tried removing them with this: http://www.mediamonkey.com/forum/viewto ... move+genre. One ghost genre still creeping in my database. I can rename it but not remove. Any easy sqlite editor suggestions?
crcm
Jerking monkey since 2005 - FINNISH Translator
MM4.X | Win7 enterprise sp1 | SPDIF earsex | Denon sushi | AKG hearing aid | Lumia 820 color blindness OR Samsung Galactical Voodoo magic
crcm
Posts: 62
Joined: Wed Mar 16, 2005 12:13 am
Location: Finland

Re: Can't browse Genre tree from Music node [1459]

Post by crcm »

I ended installing MM4 again, clean. And used these scripts to recover last played, added, playlists and playcounts etc:

http://solair.eunet.rs/~zvezdand/RestorePlayHistory.htm
http://www.mediamonkey.com/forum/viewto ... +playcount
Big thanks to the script-wizards!

My imported/converted MM3 database was malfunctioning in MM4. Not in MM3. I regularly maintained my database and harddrive should be ok also. Backuped daily. So maybe some deep analysis maintenance function/script for database would be nice. Just a though. 8)
crcm
Jerking monkey since 2005 - FINNISH Translator
MM4.X | Win7 enterprise sp1 | SPDIF earsex | Denon sushi | AKG hearing aid | Lumia 820 color blindness OR Samsung Galactical Voodoo magic
Lowlander
Posts: 56492
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Can't browse Genre tree from Music node [1459]

Post by Lowlander »

Post Reply