2013-08-03, 23:28
MyPicsDB Version: 12.0.0
MySQL version: 5.5.17
Hey Xycl, I'm getting the following error when MyPicsDB scans my pictures. This error causes over 8000 of my 11000+ pictures to NOT get inserted into the database because the Date Taken tag is empty.
11:35:55 T:700 ERROR: [plugin.image.mypicsdb] line 440 in MypicsDB.py object file_insert >> <type 'exceptions.Exception'> - 1292: Incorrect datetime value: 'null' for column 'ImageDateTime' at row 1
After a little investigation I was able to resolve this problem on my own by making the following change in the MypicsDB.py file at line 418.
Changed line 418
From:
imagedatetime = "null"
To:
imagedatetime = "0000-00-00 00:00:00"
You may have already fixed this in a newer version but thought I'd mention it in case there are others out there pulling their hair out trying to figure out why their pics arent being inserted that may have a similar setup.
Thanks for all your hard work!
MySQL version: 5.5.17
Hey Xycl, I'm getting the following error when MyPicsDB scans my pictures. This error causes over 8000 of my 11000+ pictures to NOT get inserted into the database because the Date Taken tag is empty.
11:35:55 T:700 ERROR: [plugin.image.mypicsdb] line 440 in MypicsDB.py object file_insert >> <type 'exceptions.Exception'> - 1292: Incorrect datetime value: 'null' for column 'ImageDateTime' at row 1
After a little investigation I was able to resolve this problem on my own by making the following change in the MypicsDB.py file at line 418.
Changed line 418
From:
imagedatetime = "null"
To:
imagedatetime = "0000-00-00 00:00:00"
You may have already fixed this in a newer version but thought I'd mention it in case there are others out there pulling their hair out trying to figure out why their pics arent being inserted that may have a similar setup.
Thanks for all your hard work!
