SQL error

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: SQL error

by jiri » Sun Oct 07, 2007 11:55 am

Ok, I probably see what's wrong, it will be fixed in the next release.

Jiri

SQL error

by amarcord » Sat Oct 06, 2007 6:00 am

Hi,

Using either of beta 2 or beta 3 version, I regularly get this kind of error:
There was a problem querying the database:
Error executing SQL: "select sum(cnt) as cnt FROM (SELECT count(*) as cnt FROM Songs WHERE NormalizeTrack < -99999 AND UNION SELECT count(*) as cnt FROM Songs WHERE NormalizeAlbum < -99999 AND )
" : near "UNION": syntax error (1, 1)
Clicking Cancel or Ignore seems to have no consequence.
Is it a bug, or something related to the sql drivers? I'm running under vista.

Top