2011-12-13, 04:39
bradvido88 Wrote:It looks like MySQL is failing at executing that query. What version of MySQL are you using? Can you try and execute the query manually (if you know how)
Code:SELECT idFile FROM files WHERE idPath IN(SELECT idPath FROM path WHERE LOWER(strPath) = 'y:\streaming\drop\tv shows\once.upon.a.time\season.1\') AND lower(strFileName) = 's01e06 - the shepherd.mpg'
Trying to do a crash course in mysql right now to find out the second part, but the version is:
Server version: 5.1.54-1ubuntu4 (Ubuntu)
Running on ubuntu server (natty)