[RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags

  Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
SunBeech Offline
Junior Member
Posts: 2
Joined: Jan 2017
Reputation: 0
Post: #661
(2017-01-27 14:56)turdferguson Wrote:  This error is the exact same one I'm getting with my installation (which previously worked fine with Aeon MQ7). I'm still running Jarvis, but the message in my logs looks the same. Are you also getting an "unsupported addon" notification in your logs too? Wish I could figure this out- this is the only game in town for filtered access to my photo library Sad

I upgraded Kodi to v17 RC4, but that did not make any difference. I checked the kodi.log file, but I don't find any references to unsupported addons.
find quote
Gandalph Offline
Junior Member
Posts: 2
Joined: Feb 2017
Reputation: 0
Post: #662
Hey there folks,

I was wondering about that strange behavior too. Undecided

Under Jarvis 16.1 "My Picture Database" was working fine without any problems, but now after I installed 17.0 Krypton (full, no RC) the same error message appears for me.

After indexing my pictures and when I want to go into the picture folders sorted by folder. When going into the folder where the pictures are I receive an "My Pictures Database error" message and for further information I can go to log.

[Image: viewer.php?img=UnbenanntYOUK6X.jpg]

As this addon is still my favorite I would like to use it ongoing but with this I can not.
Is there anybody out there fixing´solving this please?
find quote
snblg Offline
Junior Member
Posts: 46
Joined: Feb 2017
Reputation: 0
Location: France
Post: #663
Hello,

New Kodi user, I've installed your addon on Kodi Krypton, and followed your guide.
I'm using Kodi Krypton 17 official release on several archlinux computers.
I'm using a centralised mariadb mysql database.

Configuration is OK, but when trying to add a picture path, it fails :
-> Faut-il parcourir ce dossier de manière récursive -> Oui -> OK
-> Faut-il effectuer une analyse -> Oui ->
Mypicture Database préparation - Merci de patienter -> Erreur d'extension, consulter le log

My log says :
2, in raise_error
raise get_mysql_exception(errno,errmsg)
ProgrammingError: 1146: Table 'MyPicsDB.Files' doesn't exist
-->End of Python script error report<--

[Image: 008.jpg]

Exporting the database to a file does not show any Files table in the plain text result.

So, I tried on another computer -> same problem.

What am I doing wrong ?
find quote
snblg Offline
Junior Member
Posts: 46
Joined: Feb 2017
Reputation: 0
Location: France
Post: #664
I found most of the problems I had :

When creating your database, you must specify "utf8-general-ci for the encoding type.
This is why all my tables were not created.
[Image: 009.jpg]

Compare with my previous post ( just above this one )!
[Image: 012.jpg]
AS you can see, my "Files" table, and some others, were created !

Then I got different errors :
[Image: 010.jpg]
And analyzing the log showed me the .py files were not correctly installed :
I copied them from
.kodi/addons/plugin.image.mypicsdb/resources/lib/
to
.kodi/addons/plugin.image.mypicsdb

Now, my collections are created.
[Image: 011.jpg]
But I cannot browse them. No more time today, I'll search tomorrow.

Here is the error :
9:58:46.418 T:140092518450944 ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
- NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
Error Type: <type 'exceptions.ValueError'>
Error Contents: too many values to unpack
Traceback (most recent call last):
File "/home/didier/.kodi/addons/plugin.image.mypicsdb/default.py", line 1868, in <module>
m.show_folders()
File "/home/didier/.kodi/addons/plugin.image.mypicsdb/default.py", line 525, in show_folders
for path, filename in picsfromfolder:
ValueError: too many values to unpack
-->End of Python script error report<--
09:58:46.458 T:140093897626944 ERROR: GetDirectory - Error getting plugin://plugin.image.mypicsdb/?action=%27showfolder%27&folderid=%27267%27&method=%27folders%27&name=%27Cassettes%20VHS%20(25%20Images)%27&onlypics=%27non%27&viewmode=%27view%27
09:58:46.459 T:140093897626944 ERROR: CGUIMediaWindow::GetDirectory(plugin://plugin.image.mypicsdb/?action=%27showfolder%27&folderid=%27267%27&method=%27folders%27&name=%27Cassettes%20VHS%20(25%20Images)%27&onlypics=%27non%27&viewmode=%27view%27) failed


These are the same errors (1868 and 525) as Gandalph (his post is above mine)
(This post was last modified: 2017-02-15 11:13 by snblg.)
find quote
Gandalph Offline
Junior Member
Posts: 2
Joined: Feb 2017
Reputation: 0
Post: #665
Well, I know the origin programmer of this nice addon has no more that much time to look into this forum here, but maybe somebody else has the same problems as we all have - or, better, someone has ea workaround or fix?
find quote
Xycl Offline
Fan
Posts: 426
Joined: Feb 2012
Reputation: 10
Location: Germany
Post: #666
(2016-12-02 15:03)flowerpot Wrote:  hi i am working on win 10 with kodi 16.1 and rapier skin and seem to be getting a error from the picture database eveytime i load the skin up thanks for looking

http://pastebin.com/EQTVQqG4

12:50:23 T:4428 ERROR: [My Pictures Database] line 275 in dbabstractionlayer.py object Database abstraction layer >> <type 'exceptions.Exception'> - no such table: Files


Did you create the database?

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
find quote
Xycl Offline
Fan
Posts: 426
Joined: Feb 2012
Reputation: 10
Location: Germany
Post: #667
Problem with folder view:
Quote:17:17:50.486 T:3004 ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
- NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
Error Type: <type 'exceptions.ValueError'>
Error Contents: too many values to unpack
Traceback (most recent call last):
File "C:\Users\[user]\AppData\Roaming\Kodi\addons\plugin.image.mypicsdb\default.py", line 1868, in <module>
m.show_folders()
File "C:\Users\[user]\AppData\Roaming\Kodi\addons\plugin.image.mypicsdb\default.py", line 525, in show_folders
for path, filename in picsfromfolder:
ValueError: too many values to unpack
-->End of Python script error report<--
There is a new version 14.3.0 which should fix this problem.
Please try.

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
find quote
Post Reply