[Xycl]

Hi, Xycl,

I found the strings.po in Chinese (Traditional) of myPicsDB Addon only covers 10% or less of the supposedly default English (US).
...

Best Wishes!

Please use Translation System

[Xycl]

hi, could you take a look a this log.
i'm having some trouble, the most strange think is that sometime i have this error and sometime no!
i'm using the "random pictures" feature as widget and, as i wrote, sometimes on startup or when i set the widget content i have the error in the log. could you give me a hand?
Peppe

EDIT

i have to say that in the end the addon works each time but only about five minute kodi is on.
on startup i have the problem, widget doesn't start and even if i try to add again the widget just after kodi is on an error is showed in kodi popup.
if i leave the system running after a while i have the widget loaded.
this is the log with both situations.
Peppe

Code:

19:59:27 T:5908  NOTICE: [My Pictures Database] line    88 in default.py object Main.get_args >> sys.argv[2] = ?method='random'&page='1'&viewmode='view'&action='showpics'&name='Show+250+random+pictures'&reload=

Where does the parameter reload come from?

[peppe_sr]

hi mate.
i think ii comes from the script which menage the widget.
maybe this http://puu.sh/piDAa/e80760d677.jpg

[Xycl]

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
...

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.

Please try the following
1) Edit file resources/lib/MyPicsDB.py
2) At line 615 you should see the following:

Code:

def del_pic(self, picpath, picfile=None):
    
        if picfile:
            self.cur.request("""DELETE FROM Files WHERE idFolder = (SELECT idFolder FROM Folders WHERE FullPath Like '%s_') AND strFilename=? """%picpath,(picfile, ))
    
        else:

change it to:

Code:

def del_pic(self, picpath, picfile=None):
    
        if picfile:
            picpath = picpath.replace("\\", "\\\\")
            self.cur.request("""DELETE FROM Files WHERE idFolder = (SELECT idFolder FROM Folders WHERE FullPath Like '%s_') AND strFilename=? """%picpath,(picfile, ))
    
        else:

EDIT:
Try the new version 13.3.8

[Xycl]

hi mate.
i think ii comes from the script which menage the widget.
maybe this http://puu.sh/piDAa/e80760d677.jpg

Please try version 13.3.8

[peppe_sr]

ok, i will try at home, my system with all stuff is off ATM. thanks and sorry for the mail.
Peppe

[Xycl]

No problem

[peppe_sr]

Please try version 13.3.8

it worked at first attempt
thanks
Peppe

[twiseva]

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
...

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.

Please try the following
1) Edit file resources/lib/MyPicsDB.py
2) At line 615 you should see the following:

Code:

def del_pic(self, picpath, picfile=None):
    
        if picfile:
            self.cur.request("""DELETE FROM Files WHERE idFolder = (SELECT idFolder FROM Folders WHERE FullPath Like '%s_') AND strFilename=? """%picpath,(picfile, ))
    
        else:

change it to:

Code:

def del_pic(self, picpath, picfile=None):
    
        if picfile:
            picpath = picpath.replace("\\", "\\\\")
            self.cur.request("""DELETE FROM Files WHERE idFolder = (SELECT idFolder FROM Folders WHERE FullPath Like '%s_') AND strFilename=? """%picpath,(picfile, ))
    
        else:

EDIT:
Try the new version 13.3.8

Hey @Xycl, seems to have fixed this issue with the newest version -- great!

[twiseva]

Another oddity I am seeing is navigation of the menus. Seems like the bottom group of menu items are automatically selected (like you hit return) if you stay on them for about a second. This happens in the sub menus also. I am using Jarvis with the Nox skin if that makes any difference.

A minor update: This seems only to for the following choices: filter wizard; global search; addon settings; translates your tags; help

[peppe_sr]

Please try version 13.3.8

it worked at first attempt
thanks
Peppe

i'm in trouble again.....
my log
i think that with random item deactivated
http://puu.sh/pl3M7/fa60e72666.jpg
it seems to work, but i'm not sure al 100%......
Peppe

[Xycl]

I'll look at this tomorrow

[Xycl]

Another oddity I am seeing is navigation of the menus. Seems like the bottom group of menu items are automatically selected (like you hit return) if you stay on them for about a second. This happens in the sub menus also. I am using Jarvis with the Nox skin if that makes any difference.

A minor update: This seems only to for the following choices: filter wizard; global search; addon settings; translates your tags; help

I use MyPicsDB with a remote control at home and sometimes with a wireless keyboard.
Never saw this. But my used skin is confluence.

[twiseva]

Another oddity I am seeing is navigation of the menus. Seems like the bottom group of menu items are automatically selected (like you hit return) if you stay on them for about a second. This happens in the sub menus also. I am using Jarvis with the Nox skin if that makes any difference.

A minor update: This seems only to for the following choices: filter wizard; global search; addon settings; translates your tags; help

I use MyPicsDB with a remote control at home and sometimes with a wireless keyboard.
Never saw this. But my used skin is confluence.

So it is definitely skin related -- tried confluence and aeon nox (standard) and both are fine. Went back to Aeon nox silvo and this behavior came back. Odd. Will try and see if I can find anything in logs or on silvo thread ...

[twiseva]

Please try version 13.3.8

it worked at first attempt
thanks
Peppe

So it seems that this same error has appeared for ma after updating to 13.3.8. See http://pastebin.com/raw/SHXqw4ZL. Looks basically the same. Prior to 13.3.8 all was well, afterwards get an error popup and this in the logs.