Problem Querying the database during synch

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: Problem Querying the database during synch

Re: Problem Querying the database during synch

by nohitter151 » Tue Feb 17, 2009 10:40 pm

Right, you'll have to re-add all tracks to start a new database.

Re: Problem Querying the database during synch

by iceman » Tue Feb 17, 2009 9:50 pm

I did that and it seems to have worked. I take it that just wiped the slate clean essentially? So in other words I'll have to now re-add all of my music to the MM library again?!
Thanks for helping me eliminte that problem though. that was frustrating!

Iceman

Re: Problem Querying the database during synch

by nohitter151 » Tue Feb 17, 2009 9:23 pm

'Database image is malformed' errors can occur if the underlying database has been corrupted. This can happen if the drive is somehow shut down during a
database operation or if a low level kernel level process is interfering with SQL operations (this has been observed with SpyCatcher).

The solution to this is to manually delete the corrupt database so that a new one can be rebuilt. To do so, delete the file located at:

Windows XP:
C:\Documents and Settings\USERNAME\Local Settings\Application Data\MediaMonkey\MM.DB

Windows Vista:
C:\Users\USERNAME\AppData\Local\MediaMonkey\MM.DB

To increase database robustness see:
http://www.mediamonkey.com/support/inde ... ticleid=75

Re: Problem Querying the database during synch

by iceman » Tue Feb 17, 2009 9:19 pm

I am having the same problem with MM. I am having a problem querying the database with the same error as listed above.
I don't understand any of the previous posts on how to fix this issue. Can someone help? It does sound very similar to my recent problem. Up to now I've had no problem ripping cds with MM and playing any and all tracks. However, my computer froze up the other day and I had to turn it off via the power button. Since then now MM won't rip cds and it won't even play mp3s that I've ripped with Roxio. It says the above error message. Can someone please explain in laymen terms what I need to do to fix this issue? I'm in the middle of a move across state lines and I need to get this problem fixed ASAP before I move.
Please help me?!

I forgot to add that when I'm ripping a cd, the player audio goes all warbly as if the speakers were under water as well. WTF?

by martialartsguy » Thu Jan 24, 2008 5:00 pm

Sheesh, now that you mention it - I had a similar crash last night before bed and that must have corrupted my db as well.

It is Fixed

by Jpowers408 » Thu Jan 24, 2008 4:29 pm

It is fixed now. Thinking back on what happened I was in the middle of renaming all my files when we had a power surge and that must have corrupted the file mentioned above. I am glad it works now I just finished adding my 33,000 songs. :wink:

I think I fixed it

by Jpowers408 » Thu Jan 24, 2008 3:48 pm

Follow this post and delete this file

http://www.mediamonkey.com/faq/index.ph ... 20database

by Jpowers408 » Thu Jan 24, 2008 3:07 pm

I found the .ini file it is located in (your user name)/AppData/Local/MediaMonkey/MediaMonkey.ini

.1127

by Jpowers408 » Thu Jan 24, 2008 3:00 pm

I am using .1127 now and having the problem I found these two threads which are kind of helpful except I can not find this .ini file they talk about. I am using Vista unfortunetly so nothing is ever the same.

http://www.mediamonkey.com/forum/viewtopic.php?t=3194

http://www.mediamonkey.com/faq/index.php

by martialartsguy » Thu Jan 24, 2008 2:41 pm

Incidentally - I didn't have this problem before uploading to the newest beta as far as I remember. I'm going to go back to .1127 to test this error message again.

Same Problem

by Jpowers408 » Thu Jan 24, 2008 2:02 pm

I am having the same problem with MM. I am having a problem querying the database with the same error as listed above. I have not installed any spyware or anti virus programs either. I have Defraged and used windoc on computer and it still happens. The program was running fine and then I went and change two options and it started to happen. I think I changed the remove under scores option and update track info when rescanning files. I changed both options back and I still have the same problem. I have uninstalled program and reinstalled two times now still getting the same error message.

by martialartsguy » Thu Jan 24, 2008 12:21 pm

Unfortunately, I haven't changed or added anything as far as that is concerned.

Re: Problem Querying the database during synch

by PetrCBR » Thu Jan 24, 2008 12:07 pm

Have you installed some anti-spyware, anti-virus or other anti-something ? If so, try to disable it before you run MM if this problem persist.

Problem Querying the database during synch

by martialartsguy » Thu Jan 24, 2008 10:58 am

I am currently running MM3.0.2.1131 & am trying to synch to a 60gb Creative Zen.

When I attempt to synchonize, I get the following error:

Image

For those searching:
There was a problem querying the database:
Could not retrieve data "SELECT ID, IDTrack, Rating, PlayCount, DevicePath, Uploadtime, Converted
FROM DeviceTracks WHERE IDDevice=? and DevicePath=?
" : database Image is Malformed (11,11)

When I push Cancel, it cancels the process; for Retry it loops; for Ignore it does nothing.

I have not had any problems with synching except for it going slow, when I changed the option to convert tracks. I am now not converting tracks for the above process.

Top