I don't know what is going on but suddenly if I want to ingest both video and application data into database using EPFImporter tool I got weird errors:
2017-12-27 18:29:20,867 [ERROR]: Fatal error encountered while ingesting '/Users/administrator/Documents/appromocje/full/itunes20171220/video'
Traceback (most recent call last):
File "/Users/administrator/Documents/appromocje/EPFIngester.py", line 129, in ingestFull
self._populateTable(self.tmpTableName, skipKeyViolators=skipKeyViolators)
File "/Users/administrator/Documents/appromocje/EPFIngester.py", line 379, in _populateTable
cur.execute(exStr)
File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1366, "Incorrect string value: '\\xF0\\xA0\\xA9\\xA4\\xE6\\xBD...' for column 'artist_display_name' at row 2")
or:
2017-12-27 18:29:21,514 [ERROR]: Fatal error encountered while ingesting '/Users/administrator/Documents/appromocje/full/itunes20171220/video_translation'
Traceback (most recent call last):
File "/Users/administrator/Documents/appromocje/EPFIngester.py", line 129, in ingestFull
self._populateTable(self.tmpTableName, skipKeyViolators=skipKeyViolators)
File "/Users/administrator/Documents/appromocje/EPFIngester.py", line 379, in _populateTable
cur.execute(exStr)
File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1048, "Column 'language_code' cannot be null")
I read Stack Overflow and noticed that UTF8 encoding may be the issue but previously it worked and my database was set utf8 as default encoding. So what are you doing Apple?
Sorry if I posted this on wrong forum, but I have lot of frustration. I asked iTunes Affiliate support about this but no response....