2019-01-24, 13:30
Hi,
Thanks for a great plugin!
Im using the plugin for my photo collection and everythink it is working fine with the default database (SQLlite)! Now im trying to switch to a MySQL database (5.7.25-0ubuntu0.16.04.2 ). I did all steps to create the MyPicsDB and i changed the configuration in Kodi to use now the MySQL database. After a scan of the folders i was able to browse trough the photos and i cann display all ("Latest 50 Pics" or "uploads from last 10 days" or "Browse by date". So it seems the photos are in.
If im changing into the "Browse by Tag" folder i can see all of the tags and i see also the count how many photos should be in (EXIF and ICMP tags ). If im changing into the specific folder ( for ex. Title), the folder is empty.
In log file i could see somme errors:
12:21:19.023 T:764 NOTICE: [My Pictures Database] line 86 in default.py object Main.get_args >> MyPicturesDB plugin called :
12:21:19.023 T:764 NOTICE: [My Pictures Database] line 87 in default.py object Main.get_args >> sys.argv[0] = plugin://plugin.image.mypicsdb/
12:21:19.023 T:764 NOTICE: [My Pictures Database] line 88 in default.py object Main.get_args >> sys.argv[2] = ?action=%27showpics%27&method=%27tag%27&name=%27Gartenteich%20Tino%20(4%20Pics)%27&page=%271%27&tag=%27Gartenteich%20Tino%27&tagtype=%27Title%27&viewmode=%27view%27
12:21:19.966 T:764 ERROR: [My Pictures Database] line 274 in dbabstractionlayer.py object Database abstraction layer >> The request failed :
12:21:19.967 T:764 ERROR: [My Pictures Database] line 275 in dbabstractionlayer.py object Database abstraction layer >> <type 'exceptions.Exception'> - 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'MyPicsDB.f.ImageDateTime' which is not in SELECT list; this is incompatible with DISTINCT
12:21:19.967 T:764 ERROR: [My Pictures Database] line 279 in dbabstractionlayer.py object Database abstraction layer >> SQL > SELECT distinct strPath,strFilename FROM Files f, TagContents tc, TagsInFiles tif, TagTypes tt WHERE f.idFile = tif.idFile AND tif.idTagContent = tc.idTagContent AND tc.TagContent = ? and tc.idTagType = tt.idTagType and length(trim(tt.TagTranslation))>0 and tt.TagTranslation = ? order by imagedatetime
As i wrote, with the SQLLITE database it is working fine, with MySQL database i do have this issue.
A re-initialization of the MySQL database I have already done several times.
Thanks for a great plugin!
Im using the plugin for my photo collection and everythink it is working fine with the default database (SQLlite)! Now im trying to switch to a MySQL database (5.7.25-0ubuntu0.16.04.2 ). I did all steps to create the MyPicsDB and i changed the configuration in Kodi to use now the MySQL database. After a scan of the folders i was able to browse trough the photos and i cann display all ("Latest 50 Pics" or "uploads from last 10 days" or "Browse by date". So it seems the photos are in.
If im changing into the "Browse by Tag" folder i can see all of the tags and i see also the count how many photos should be in (EXIF and ICMP tags ). If im changing into the specific folder ( for ex. Title), the folder is empty.
In log file i could see somme errors:
12:21:19.023 T:764 NOTICE: [My Pictures Database] line 86 in default.py object Main.get_args >> MyPicturesDB plugin called :
12:21:19.023 T:764 NOTICE: [My Pictures Database] line 87 in default.py object Main.get_args >> sys.argv[0] = plugin://plugin.image.mypicsdb/
12:21:19.023 T:764 NOTICE: [My Pictures Database] line 88 in default.py object Main.get_args >> sys.argv[2] = ?action=%27showpics%27&method=%27tag%27&name=%27Gartenteich%20Tino%20(4%20Pics)%27&page=%271%27&tag=%27Gartenteich%20Tino%27&tagtype=%27Title%27&viewmode=%27view%27
12:21:19.966 T:764 ERROR: [My Pictures Database] line 274 in dbabstractionlayer.py object Database abstraction layer >> The request failed :
12:21:19.967 T:764 ERROR: [My Pictures Database] line 275 in dbabstractionlayer.py object Database abstraction layer >> <type 'exceptions.Exception'> - 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'MyPicsDB.f.ImageDateTime' which is not in SELECT list; this is incompatible with DISTINCT
12:21:19.967 T:764 ERROR: [My Pictures Database] line 279 in dbabstractionlayer.py object Database abstraction layer >> SQL > SELECT distinct strPath,strFilename FROM Files f, TagContents tc, TagsInFiles tif, TagTypes tt WHERE f.idFile = tif.idFile AND tif.idTagContent = tc.idTagContent AND tc.TagContent = ? and tc.idTagType = tt.idTagType and length(trim(tt.TagTranslation))>0 and tt.TagTranslation = ? order by imagedatetime
As i wrote, with the SQLLITE database it is working fine, with MySQL database i do have this issue.
A re-initialization of the MySQL database I have already done several times.