2014-06-26, 08:20
(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.