Hey guys,
Anyone seen this error before?
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'background' for column 'widgetId' at row 2
I saw this issue, but I’m not sure if that is the same thing since this only impacts one device. FWIW, we’re currently running android 1.7-62 on that device and I was planning on upgrading this week.
UPDATE: Now running android 1.8-101, same error. 
I think that one device is sending back old stat records - can you enable auditing on that display and see if the error is in SubmitStats and whether the Stats XML being received is for a past date.
You seem to be correct, sir.
Should I just clear the application data and then setup the client from scratch?
<?xml version="1.0" encoding="UTF-8"?>
<log>
<stat type="media" fromdt="2017-03-19 17:55:15" todt="2017-03-19 18:05:15" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 17:55:15" todt="2017-03-19 18:05:15" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 17:55:15" todt="2017-03-19 18:05:15" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 17:55:15" todt="2017-03-19 18:05:15" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 17:55:15" todt="2017-03-19 18:05:15" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 17:55:15" todt="2017-03-19 18:05:15" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="layout" fromdt="2017-03-19 17:55:15" todt="2017-03-19 18:05:15" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 17:55:15" todt="2017-03-19 18:05:15" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="media" fromdt="2017-03-19 18:05:15" todt="2017-03-19 18:15:16" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 18:05:15" todt="2017-03-19 18:15:16" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 18:05:15" todt="2017-03-19 18:15:16" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 18:05:15" todt="2017-03-19 18:15:16" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="layout" fromdt="2017-03-19 18:05:15" todt="2017-03-19 18:15:16" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 18:05:16" todt="2017-03-19 18:15:16" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 18:05:16" todt="2017-03-19 18:15:16" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="media" fromdt="2017-03-19 18:05:16" todt="2017-03-19 18:15:16" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="media" fromdt="2017-03-19 18:15:16" todt="2017-03-19 18:25:17" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 18:15:16" todt="2017-03-19 18:25:17" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 18:15:16" todt="2017-03-19 18:25:17" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 18:15:16" todt="2017-03-19 18:25:17" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 18:15:16" todt="2017-03-19 18:25:17" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 18:15:16" todt="2017-03-19 18:25:17" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="layout" fromdt="2017-03-19 18:15:16" todt="2017-03-19 18:25:17" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 18:15:16" todt="2017-03-19 18:25:17" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="media" fromdt="2017-03-19 18:25:17" todt="2017-03-19 18:35:17" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 18:25:17" todt="2017-03-19 18:35:17" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 18:25:17" todt="2017-03-19 18:35:18" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 18:25:17" todt="2017-03-19 18:35:18" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 18:25:17" todt="2017-03-19 18:35:18" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 18:25:17" todt="2017-03-19 18:35:18" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="media" fromdt="2017-03-19 18:25:17" todt="2017-03-19 18:35:18" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="layout" fromdt="2017-03-19 18:25:17" todt="2017-03-19 18:35:17" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 18:35:18" todt="2017-03-19 18:45:18" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 18:35:18" todt="2017-03-19 18:45:18" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 18:35:18" todt="2017-03-19 18:45:18" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 18:35:18" todt="2017-03-19 18:45:18" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 18:35:18" todt="2017-03-19 18:45:18" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 18:35:18" todt="2017-03-19 18:45:18" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="layout" fromdt="2017-03-19 18:35:18" todt="2017-03-19 18:45:18" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 18:35:18" todt="2017-03-19 18:45:18" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="media" fromdt="2017-03-19 18:45:18" todt="2017-03-19 18:55:19" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 18:45:18" todt="2017-03-19 18:55:19" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 18:45:18" todt="2017-03-19 18:55:19" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 18:45:18" todt="2017-03-19 18:55:19" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 18:45:18" todt="2017-03-19 18:55:19" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 18:45:18" todt="2017-03-19 18:55:19" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="media" fromdt="2017-03-19 18:45:18" todt="2017-03-19 18:55:19" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="layout" fromdt="2017-03-19 18:45:18" todt="2017-03-19 18:55:19" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 18:55:19" todt="2017-03-19 19:05:20" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 18:55:19" todt="2017-03-19 19:05:20" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 18:55:19" todt="2017-03-19 19:05:20" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 18:55:19" todt="2017-03-19 19:05:20" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 18:55:19" todt="2017-03-19 19:05:20" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 18:55:19" todt="2017-03-19 19:05:20" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="media" fromdt="2017-03-19 18:55:19" todt="2017-03-19 19:05:20" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="layout" fromdt="2017-03-19 18:55:19" todt="2017-03-19 19:05:20" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 19:05:20" todt="2017-03-19 19:15:20" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 19:05:20" todt="2017-03-19 19:15:20" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 19:05:20" todt="2017-03-19 19:15:20" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 19:05:20" todt="2017-03-19 19:15:20" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 19:05:20" todt="2017-03-19 19:15:20" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 19:05:20" todt="2017-03-19 19:15:20" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="media" fromdt="2017-03-19 19:05:20" todt="2017-03-19 19:15:20" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="layout" fromdt="2017-03-19 19:05:20" todt="2017-03-19 19:15:20" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 19:15:20" todt="2017-03-19 19:25:21" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 19:15:20" todt="2017-03-19 19:25:21" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 19:15:20" todt="2017-03-19 19:25:21" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 19:15:20" todt="2017-03-19 19:25:21" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 19:15:20" todt="2017-03-19 19:25:21" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 19:15:20" todt="2017-03-19 19:25:21" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="media" fromdt="2017-03-19 19:15:20" todt="2017-03-19 19:25:21" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="layout" fromdt="2017-03-19 19:15:20" todt="2017-03-19 19:25:21" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 19:25:21" todt="2017-03-19 19:35:22" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 19:25:21" todt="2017-03-19 19:35:22" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 19:25:21" todt="2017-03-19 19:35:22" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 19:25:21" todt="2017-03-19 19:35:22" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 19:25:21" todt="2017-03-19 19:35:22" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 19:25:21" todt="2017-03-19 19:35:22" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="layout" fromdt="2017-03-19 19:25:21" todt="2017-03-19 19:35:22" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 19:25:21" todt="2017-03-19 19:35:22" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="media" fromdt="2017-03-19 19:35:22" todt="2017-03-19 19:45:22" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 19:35:22" todt="2017-03-19 19:45:22" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 19:35:22" todt="2017-03-19 19:45:22" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 19:35:22" todt="2017-03-19 19:45:22" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 19:35:22" todt="2017-03-19 19:45:22" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 19:35:22" todt="2017-03-19 19:45:22" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="media" fromdt="2017-03-19 19:35:22" todt="2017-03-19 19:45:22" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="layout" fromdt="2017-03-19 19:35:22" todt="2017-03-19 19:45:22" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 19:45:22" todt="2017-03-19 19:55:23" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 19:45:22" todt="2017-03-19 19:55:23" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 19:45:22" todt="2017-03-19 19:55:23" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 19:45:22" todt="2017-03-19 19:55:23" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
<stat type="media" fromdt="2017-03-19 19:45:22" todt="2017-03-19 19:55:23" layoutid="37" scheduleid="60" mediaid="166" tag="null" />
<stat type="media" fromdt="2017-03-19 19:45:22" todt="2017-03-19 19:55:23" layoutid="37" scheduleid="60" mediaid="168" tag="null" />
<stat type="media" fromdt="2017-03-19 19:45:22" todt="2017-03-19 19:55:23" layoutid="37" scheduleid="60" mediaid="169" tag="null" />
<stat type="layout" fromdt="2017-03-19 19:45:22" todt="2017-03-19 19:55:23" layoutid="37" scheduleid="60" mediaid="null" tag="null" />
<stat type="media" fromdt="2017-03-19 19:55:23" todt="2017-03-19 20:05:24" layoutid="37" scheduleid="60" mediaid="170" tag="null" />
<stat type="media" fromdt="2017-03-19 19:55:23" todt="2017-03-19 20:05:24" layoutid="37" scheduleid="60" mediaid="background" tag="null" />
<stat type="media" fromdt="2017-03-19 19:55:23" todt="2017-03-19 20:05:24" layoutid="37" scheduleid="60" mediaid="164" tag="null" />
<stat type="media" fromdt="2017-03-19 19:55:23" todt="2017-03-19 20:05:24" layoutid="37" scheduleid="60" mediaid="165" tag="null" />
</log>You certainly could do that - however on second thoughts it might be better to issue a patch which automatically ignores those records from the submit, meaning you don’t lose your stats.