Page 1 of 1

Intermittent ODBC Error After Deleting Duplicates

Posted: Sat Feb 07, 2004 12:32 pm
by halftime
Symptoms: I pull up the "Duplicate Titles" view in "Files To Edit" node. I select a number of songs to delete and click he Delete button on my keyboard. I choose "Delete from Library and File System" option. The deletions proceed and the deleted titles disappear from the view. But some seconds afterward (usually 3-5 seconds), I get an error dialog with this text:

There was following problem with querying database:
40000:[Microsoft][ODBC Microsoft Access Driver]Syntax error
(missing operator) in query expression 'UCASE(LEFT(SongPath,
95)) = UCASE(':\MP3Library\SongTitle.mp3') AND IdMedia=44.

I get Cancel/Retry/Ignore buttons. Cancel and Ignore clear the error. Retry never has. It doesn't happen every time I delete duplicates, but when it does happen, that's where it happens. I might get several of these for a block of duplicates deleted and each one that comes up stops me from doing anything else until it's cleared.

ENV: WinXP w/SP3 on a P3650 w/ 256MB PC133SDRAM. My Access installation is Office XP Developer install.

Posted: Sun Feb 08, 2004 4:24 am
by jiri
That's interesting, could you please generate a debug log of this error so that I can see the whole context of the problem (see http://www.songs-db.com/forum/viewtopic.php?t=69 for a description of how to do it). Send it to my e-mail then, please.

Thanks,
Jiri

Posted: Sun Feb 08, 2004 4:34 am
by jiri
Actually, after reviewing the code I think the problem is fixed now and will be ok in the next release. Anyway, if you get to the debug log, I'd really like to see it.

Jiri