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

  Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
ajerazzor Offline
Member
Posts: 71
Joined: Jun 2011
Reputation: 1
Post: #466
(2014-06-24 20:50)Xycl Wrote:  Are you sure that your mass editing didn't delete the persons tags?

EDIT: Forget my response.

Enable debug log in MyPicsDB settings:
1) Select a person with the filter wizard and press okay.
2) Go to the same person pictures through the tags menu.
3) Upload the logfile

I pulled out the bit I think is the error from the log
I am running a mysql database
13:00:34 T:2656035904 NOTICE: -->Python Interpreter Initialized<--
13:00:37 T:2656035904 NOTICE: [My Pictures Database] line 86 in default.py object Main.get_args >> MyPicturesDB plugin called :
13:00:37 T:2656035904 NOTICE: [My Pictures Database] line 87 in default.py object Main.get_args >> sys.argv[0] = plugin://plugin.image.mypicsdb/
13:00:37 T:2656035904 NOTICE: [My Pictures Database] line 88 in default.py object Main.get_args >> sys.argv[2] = ?action='showpics'&viewmode='view'&method='wizard'&matchall='0'&kw='Person%7C%7CNoah'&nkw=''&start=''&end=''
13:00:38 T:2656035904 NOTICE: [My Pictures Database] line 689 in MypicsDB.py function filterwizard_result >> match_all = 0
13:00:38 T:2656035904 ERROR: [My Pictures Database] line 274 in dbabstractionlayer.py object Database abstraction layer >> The request failed :
13:00:38 T:2656035904 ERROR: [My Pictures Database] line 275 in dbabstractionlayer.py object Database abstraction layer >> <type 'exceptions.Exception'> - 1146: Table 'MyPicsDB.FILES' doesn't exist
13:00:38 T:2656035904 ERROR: [My Pictures Database] line 279 in dbabstractionlayer.py object Database abstraction layer >> SQL > Select strPath,strFilename from (SELECT distinct strPath,strFilename, ImageDateTime FROM FILES WHERE 1=1 AND idFile in ( SELECT tif.idfile FROM TagContents tc, TagsInFiles tif , TagTypes tt WHERE tif.idTagContent = tc.idTagContent AND tc.idTagType = tt.idTagType AND tt.TagTranslation = 'Person' AND tc.TagContent in( 'Noah' ) ) order by imagedatetime ) maindateset
13:00:38 T:2690643008 NOTICE: Thread BackgroundLoader start, auto delete: false
13:01:09 T:2656035904 NOTICE: Previous line repeats 2 times.
13:01:09 T:2656035904 NOTICE: Thread LanguageInvoker start, auto delete: false
13:01:09 T:2656035904 NOTICE: -->Python Interpreter Initialized<--

EDIT: OK I pulled the SQL out of the log and ran it manually - it doesnt like the FILES uppercase table name - I will try changing the collation - thought that was OK though...

EDIT 2: Looks like linux SQL is case sensitive on table names. I have found the string in MyPicsDB.py - line 684 and changed FILES to Files. Will report back on how that goes.
(This post was last modified: 2014-06-26 08:45 by ajerazzor.)
find quote
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #467
You're right.
MySQL on Linux has case sensitive table names.

I'll change it, too.

Interesting that no one else seems to use a Linux based MySQL Db.

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

Main page: https://github.com/Xycl
Repository: Xycl Repository
find quote
ajerazzor Offline
Member
Posts: 71
Joined: Jun 2011
Reputation: 1
Post: #468
(2014-06-26 09:28)Xycl Wrote:  You're right.
MySQL on Linux has case sensitive table names.

I'll change it, too.

Interesting that no one else seems to use a Linux based MySQL Db.

Yep can confirm that fixed it
find quote
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #469
(2014-06-25 16:55)mikebzh44 Wrote:  Hi Xycl.

As MyPicsDB is no longer available on XBMC.org repo, did you continue to use transifex for translations ?

Because, I have just translate new strings :

https://www.transifex.com/projects/p/xbm...db/8903021

Thanks.

Yes transifex is still used.
But it takes some time until new translations are available for download.

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

Main page: https://github.com/Xycl
Repository: Xycl Repository
find quote
dcartron Offline
Junior Member
Posts: 2
Joined: Jun 2014
Reputation: 0
Post: #470
Hi,

I have a problem with the path of image folders. Once a folder has been added it seems impossible to remove it. I right clicked on the folder name (something like [+] my/path/to/the/image/folder [recursive=ON, update=ON]) and choose the "Delete this path from database" option, but i get an error message about script failure.
And in the log i can read :
ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
- NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
Error Type: <type 'exceptions.UnicodeDecodeError'>
Error Contents: 'ascii' codec can't decode byte 0xc3 in position 39: ordinal not in range(128)
Traceback (most recent call last):
File "/home/daniel/.xbmc/addons/plugin.image.mypicsdb/default.py", line 1798, in <module>
m.show_roots()
File "/home/daniel/.xbmc/addons/plugin.image.mypicsdb/default.py", line 1031, in show_roots
if dialog.yesno(common.getstring(30250), common.getstring(30251)%common.smart_utf8(self.args.delpath)) :
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 39: ordinal not in range(128)
-->End of Python script error report<--
09:20:36 T:140596372002752 ERROR: GetDirectory - Error getting plugin://plugin.image.mypicsdb/?action='rootfolders'&do='delroot'&delpath='smb%3A%2F%2FUTHER%2Fcartron%2FImages%2FBricolage%2FCr%C3%A8che%2F'&exclude='1'&viewmode='view'
09:20:36 T:140596372002752 ERROR: CGUIMediaWindow::GetDirectory(plugin://plugin.image.mypicsdb/?action='rootfolders'&do='delroot'&delpath='smb%3A%2F%2FUTHER%2Fcartron%2FImages%2FBricolage%2FCr%C3%A8che%2F'&exclude='1'&viewmode='view') failed

Is it a bug or something special in my files (maybe the accent in the dir name?)

(2014-06-25 16:55)mikebzh44 Wrote:  Hi Xycl.

As MyPicsDB is no longer available on XBMC.org repo, did you continue to use transifex for translations ?

Because, I have just translate new strings :

https://www.transifex.com/projects/p/xbm...db/8903021

Thanks.

Mike, could you please credit me and not you for the translatios?
(This post was last modified: 2014-06-27 11:17 by dcartron.)
find quote
mikebzh44 Offline
Posting Freak
Posts: 1,711
Joined: Nov 2011
Reputation: 47
Location: Nantes - France
Post: #471
Yes sorry, dcartron did the update translation.

BTW, to fix dcartron issue, just don't use smart_utf8 function in line 1032 in default.py but decode string instead.

[code]if dialog.yesno(common.getstring(30250), common.getstring(30251)%self.args.delpath.decode('utf-8')) :

Error occurs because dcartron try to delete this path containing accented character:

smb://UTHER/cartron/Images/Bricolage/Crêche

Sorry for my english, but, you know, I'm French so ...

(This post was last modified: 2014-06-27 11:27 by mikebzh44.)
find quote
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #472
This was the change?
Quote:msgctxt "#30216"
msgid "Add all XBMC pictures sources to database"
msgstr "Ajouter toutes les sources d'images XBMC à la base de données"

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

Main page: https://github.com/Xycl
Repository: Xycl Repository
find quote
dcartron Offline
Junior Member
Posts: 2
Joined: Jun 2014
Reputation: 0
Post: #473
Not only this one, i made some proofreading, add a forgotten string, finish to translate some still half french half english, add the accents when needed on capital letters, and rewrote some string that were incorrects.

(2014-06-27 11:23)mikebzh44 Wrote:  Yes sorry, dcartron did the update translation.

BTW, to fix dcartron issue, just don't use smart_utf8 function in line 1032 in default.py but decode string instead.

[code]if dialog.yesno(common.getstring(30250), common.getstring(30251)%self.args.delpath.decode('utf-8')) :

Error occurs because dcartron try to delete this path containing accented character:

smb://UTHER/cartron/Images/Bricolage/Crêche

I agree, i tried to add then delete another path without accent, it works, and the error messages is explicit too...
(This post was last modified: 2014-06-27 12:36 by dcartron.)
find quote
aalwani Offline
Junior Member
Posts: 14
Joined: Jul 2014
Reputation: 0
Post: #474
Hi guys, how do I disable this notification that appears every while at the bottom showing added modified etc. ..
find quote
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #475
(2014-07-18 17:30)aalwani Wrote:  Hi guys, how do I disable this notification that appears every while at the bottom showing added modified etc. ..

Currently not possible.

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