Posts: 454
Joined: Feb 2012
Reputation:
13
To only remove &reload=xxx till next ampersand please use version 13.3.9
Posts: 2
Joined: Jun 2016
Reputation:
0
2016-07-01, 16:46
(This post was last modified: 2016-07-01, 22:56 by stuka.)
Hey,
Before explaining why I came here, let me say that I'm a beginner with Kodi, and Kodi Add-ons.
So I installed Kodi, then your (marvelous) add-on on my old PC, which was running Windows before, and now Mint 17.3.
When I try to scan the folder that contains all my pics (about 20.000), PyPicsDB scans it, but stops after a while. It finds precisely 5311 pictures.
I tried 2 times with different installs, and the problem remains the same. I don't know if I'm just dumb and didn't find an obvious way to fix it, or if a problem exists in my files.
Thanks for reading this, and thanks for you work !
EDIT : It appears that one of my .jpg has been corruted, excluded it and re-scanning, I'll update in the morning
Posts: 1,272
Joined: Mar 2006
Reputation:
27
The easy way to understand your problem is through a debug log. Turn in on the settings, perform the scan and post the log on pastebin
Peppe
Posts: 2
Joined: Jun 2016
Reputation:
0
Thanks,
I checked myself in the log a bit, and it appears that one folder I was trying to scan contained corrupted files.
I excluded it in the search path, and it worked properly
Thanks for reading me, problem is fixed !
Posts: 5
Joined: Jul 2016
Reputation:
0
Hi I am new here
Hey , how to add music playlist to my album
I can't seem to be able to do it... Can't find that option anywhere
Please help with this stupid question
Thanks in advance for reply
Posts: 56
Joined: Jun 2010
Reputation:
0
Hi!
I've been using MyPicsDB for years now and a problem has been bothering me for months. I tag my photos using the face tagging feature of Picasa for Windows (which is configured to write face tags to the photos itself). I've 4000 pics of person X but MyPicsDB shows only about 400. The number shown by MyPicsDB varies whenever I go to Browse by Tags -> Person. Never figured out why. I've tried resetting the whole db and the problem is back after few weeks.
Today,
- I added only 1 folder to MyPicsDB with about 1000 photos. It found 411 photos of person X. Closed Kodi.
- Opened Picasa, tagged a new person (about 25 photos). Closed Picasa.
- Opened Kodi, MyPicsDB, scan for new/changed photos.
- After the scanning, new person has 25 photos, person X is down to 6 photos (all of which have new person as well).
If it helps, Picasa writes XMP-mwg-rs tags for faces.
Kindly fix the problem.
Posts: 56
Joined: Jun 2010
Reputation:
0
2016-08-21, 18:25
Hi Xycl!
It appears that more tags have a similar problem, not just the Person tag. I did an even more minimal test today. I added a single folder to MyPicsDB with 2 pictures. Both pics had the IPTC Caption/Description set to "Wow". I scanned them and I see 2 pics in the Browse by Tags -> Description -> Wow.
Then I edited one of the pictures and changed the caption to "Wowa". I scanned for new & changed pictures and MyPicsDB correctly shows 1 modified. Now Browse by Tags -> Description -> has only Wowa listed and Wow is missing.
However this does not happen always, sometimes both tags stayed - keep changing the caption from Wow to Wowa and back and the problem does happen soon enough. When it happens, I checked with a sqlite browser that the TagsInFiles.idTagContent has values which do not exist in TagContents table. It appears that instead of reusing the existing idTagType<->TagContent unique pair, a new record is added with a new idTagContent and the old pairs are deleted.
Is it a bug in the sqlite engine? I did my tests with v16.1 on Win7. I strongly believe it is the same problem on my main kodibuntu installation.
Posts: 1
Joined: Jan 2015
Reputation:
0
Hi Xycl!,
I have connected the Plugin to my MYSQL database which is working fine and also updating the database. When searching for picture with a certain tag I receive no results due to an SQL exception:
The Log says the following (Searching for Keyword Tag NRW):
16:38:08 T:12264 NOTICE: [My Pictures Database] line 86 in default.py object Main.get_args >> MyPicturesDB plugin called :
16:38:08 T:12264 NOTICE: [My Pictures Database] line 87 in default.py object Main.get_args >> sys.argv[0] = plugin://plugin.image.mypicsdb/
16:38:08 T:12264 NOTICE: [My Pictures Database] line 88 in default.py object Main.get_args >> sys.argv[2] = ?action=%27showpics%27&method=%27tag%27&name=%27NRW%20(32%20Pics)%27&page=%271%27&tag=%27NRW%27&tagtype=%27Keyword%27&viewmode=%27view%27
16:38:08 T:12264 NOTICE: [My Pictures Database] line 101 in default.py object Main.get_args >> action='showpics',method='tag',name='NRW (32 Pics)',page='1',tag='NRW',tagtype='Keyword',viewmode='view'
16:38:08 T:12264 NOTICE: [My Pictures Database] line 63 in MypicsDB.py function __init__ >> Used DB Backend = MySql
16:38:08 T:12264 NOTICE: Previous line repeats 1 times.
16:38:08 T:12264 ERROR: [My Pictures Database] line 274 in dbabstractionlayer.py object Database abstraction layer >> The request failed :
16:38:08 T:12264 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
16:38:08 T:12264 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
16:38:08 T:12264 NOTICE: [My Pictures Database] line 285 in dbabstractionlayer.py object SQL request numvar = 1 content = NRW >> 4
16:38:08 T:12264 NOTICE: [My Pictures Database] line 285 in dbabstractionlayer.py object SQL request numvar = 2 content = Keyword >> 4
The MySQL server is the following: Server-Version: 5.7.13-0ubuntu0.16.04.2 - (Ubuntu)
Needless to say that with SQLLite it works without a problem:-)
Thanks