Hey all, just reverted to using myPicsDB as I now have a skin that I can get a widget working with. I have upgraded to the latest version and am seeing a few errors in the log around deletion. Seems like the delete statement cannot handle ' in the path names. It added these files fine but possibly the SQL is not escaped
20:22:16 T:11148 NOTICE: [My Pictures Database] line 344 in scanpath.py object VFSScanner._addpath >> Picture dir: "smb://Kandalf/Picture Slideshows/Specials\Heather's Birthdays" file: "20150718120500-IMGP1121.jpg" deleted from DB
20:22:16 T:11148 ERROR: [My Pictures Database] line 274 in dbabstractionlayer.py object Database abstraction layer >> The request failed :
20:22:16 T:11148 ERROR: [My Pictures Database] line 275 in dbabstractionlayer.py object Database abstraction layer >> <type 'exceptions.Exception'> - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Birthdays_') AND strFilename='20150718120728-IMGP1122.jpg'' at line 1
20:22:16 T:11148 ERROR: [My Pictures Database] line 279 in dbabstractionlayer.py object Database abstraction layer >> SQL > DELETE FROM Files WHERE idFolder = (SELECT idFolder FROM Folders WHERE FullPath Like 'smb://Kandalf/Picture Slideshows/Specials\Heather's Birthdays_') AND strFilename=?
20:22:16 T:11148 NOTICE: [My Pictures Database] line 285 in dbabstractionlayer.py object SQL request numvar = 1 content = 20150718120728-IMGP1122.jpg >> 4
20:22:16 T:11148 NOTICE: [My Pictures Database] line 374 in MypicsDB.py function cleanup_keywords >> Tag tables will be cleaned.
NOTE: It seems this issue slows down the scan a lot. Takes about 20 seconds for it to fail. I have hundreds of files under this directory so its painful -- as for the UI in Kodi -- it looks as if its stalled as it lists the last successful update file name. Check logs if you see this as the scan is progressing :-) For now may rename/regenerate directories out of lightroom to avoid this issue.