by Mike_Marrone » Thu Jun 25, 2009 12:20 am
I've been using the product with great success since April, but since upgrading to version 3.1.0.1256 yesterday I cannot rip discs into my database without getting a SQL error after every track. In fact, every function I try to use results in a pop up SQL error. I have tried re-installing the update but I have not uninstalled and re-installed yet.
I do not write code and am not a computer programmer, but I am not a novice using computers by any means. I cannot find a way to paste the error code here so I will copy it the way it appears on the screen:
There was a problem querying the database:
Error executing SQL "SELECT Songs.Id
FROM songs WHERE songs.PlayCounter>0 ORDER BY songs.LastTimePlayed DEAC AND Songs.ID=?
": near "AND": syntax error (1, 1)
Can anyone offer some advice? I am finally organizing an enormous physical collection of CDs and vinyl and the first 4,000 albums have gone beautifully up to this point. I really love the software package and will continue to use it to tag and catalog everything, but if I can't find an answer to this problem with the upgrade, I will be forced to use a different ripping method.
The weird thing is that in the entire time I've used MM I had yet to get a single error message, which leads me to believe this is a simple setting somewhere that has been changed through the upgrade process.
Thanks in advance...
Mike Marrone
I've been using the product with great success since April, but since upgrading to version 3.1.0.1256 yesterday I cannot rip discs into my database without getting a SQL error after every track. In fact, every function I try to use results in a pop up SQL error. I have tried re-installing the update but I have not uninstalled and re-installed yet.
I do not write code and am not a computer programmer, but I am not a novice using computers by any means. I cannot find a way to paste the error code here so I will copy it the way it appears on the screen:
There was a problem querying the database:
Error executing SQL "SELECT Songs.Id
FROM songs WHERE songs.PlayCounter>0 ORDER BY songs.LastTimePlayed DEAC AND Songs.ID=?
": near "AND": syntax error (1, 1)
Can anyone offer some advice? I am finally organizing an enormous physical collection of CDs and vinyl and the first 4,000 albums have gone beautifully up to this point. I really love the software package and will continue to use it to tag and catalog everything, but if I can't find an answer to this problem with the upgrade, I will be forced to use a different ripping method.
The weird thing is that in the entire time I've used MM I had yet to get a single error message, which leads me to believe this is a simple setting somewhere that has been changed through the upgrade process.
Thanks in advance...
Mike Marrone