Error executing SQL "SELECT songs id"

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: Error executing SQL "SELECT songs id"

Re: Error executing SQL "SELECT songs id"

by Ludek » Tue Mar 25, 2014 3:46 am

Thanks for reporting, I finally found the steps: http://www.ventismedia.com/mantis/view.php?id=11979

Will be fixed in build 1701.

Re: Error executing SQL "SELECT songs id"

by Kalopsiaphi » Mon Mar 24, 2014 12:51 pm

I got a response.

Told me to try the latest build (1700) and closed the ticket. :lol:

I reopened it and sent the latest file from the new build.

Meanwhile it still kinda works. It just yells at me first. :roll:

Re: Error executing SQL "SELECT songs id"

by Kalopsiaphi » Mon Mar 24, 2014 11:11 am

Hi Ludek

I downloaded the beta version. Not sure what fix you are referring to the SQL warning popped right up.

No problem with the 740 error though.
Debug has been sent. Hopefully the file went through.

Thanks

Re: Error executing SQL "SELECT songs id"

by nohitter151 » Mon Mar 24, 2014 8:03 am

Kalopsiaphi wrote:
No "gold" tab to click this time. Although the Help>about said I was running the current gold version the "auto-organize" etc was grayed out.
I made sure I was administrator on everything and rebooted a couple times before I got "Gold options" again.
You must select some file or files in order to use "auto-organize". That's why it was greyed out.

Re: Error executing SQL "SELECT songs id"

by Ludek » Mon Mar 24, 2014 6:33 am

Hi, this issue should be fixed in the latest builds, please download the latest build (1700) from here:
http://www.mediamonkey.com/forum/viewto ... 95#p386592
and let us know how it works.

Thx.

Re: Error executing SQL "SELECT songs id"

by Kalopsiaphi » Mon Mar 24, 2014 6:21 am

I am using MediaMonkey_4.1.0.1692. (windows 7).
It happens when scanning, auto-tag from web, and generally trying to update my library.
The player freezes up also and I get:

There was a problem querying the database:
Error executing SQL "SELECT Songs.Id
FROM Songs WHERE Songs.PlayCounter + (Songs.PlaybackPos *1.0/Songs.SongLength) >0 ORDER BY Songs.LastTimePlayed DESC AND Songs.ID=?
":near "AND": syntax error(1,1)
AND
Access violation at address 00A8564B in module 'MediaMonkey.exe'.
Write of address 00000040.

LOL THEN when I downloaded MM Debug I got :

CreateProcess failed; code 740
The requested operation requires elevation.

I have gotten this before about 6 weeks ago. MM been working well since then.

No "gold" tab to click this time. Although the Help>about said I was running the current gold version the "auto-organize" etc was grayed out.
I made sure I was administrator on everything and rebooted a couple times before I got "Gold options" again.

STILL getting the other errors though.
Have now downloaded the manual debug view.

Re: Error executing SQL "SELECT songs id"

by Lowlander » Sun Mar 23, 2014 12:19 pm

Are you only scanning when you get the first error (not using Addons like Discogs mentioned in the second post?)? Which version of MediaMonkey are you running?

A debug log (step 4b) send to support should show more: http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=69

Re: Error executing SQL "SELECT songs id"

by Kalopsiaphi » Sat Mar 22, 2014 10:11 pm

Arrgh

Now I am getting -
Access violation at address 00A8564B in module 'MediaMonkey.exe'.
Write of address 00000040.

When I try to auto tag from web. (discogs)

It had been working fine. What did I screw up ?! :/

Error executing SQL "SELECT songs id"

by Kalopsiaphi » Sat Mar 22, 2014 7:49 pm

Hi there.
When I try to get MM to scan/rescan library I get this code and it freezes. (windows 7)

I am using iPhone and iPod. Most of my library has been moved to MM so I am not ticking "itunes" boxes to scan. Could that be the problem?

There was a problem querying the database:
Error executing SQL "SELECT Songs.Id
FROM Songs WHERE Songs.PlayCounter + (Songs.PlaybackPos *1.0/Songs.SongLength) >0 ORDER BY Songs.LastTimePlayed DESC AND Songs.ID=?
":near "AND": syntax error(1,1)

Thanks!

Top