User-Agent length error on digital signage device

[omega9380]

My company uses ViewSonic NMP309-W digital signage devices for our digital signage throughout the facility. These devices all run a custom version of Android 7. I would like to switch to using DakBoard to manage our signage, because to be blunt, the software for the ViewSonic devices is terrible.

The software allows an "HTML5 Widget" to allow you to simply display a website. I set one up to test Dakboard and used the Private URL for a screen. When I send the playlist to the device, it loads up, and it gives a "Whoops, something went wrong" page with this error:

Error 500: CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column "user_agent" at row 1

Screenshots Here's a screenshot of the error from the device:

It looks like the user_agent string provided by the device's browser is too long. Here's a screenshot of the user agent for this device:

And finally a screenshot of the WhatIsMyBrowser main page from the device:

Expected behavior The screen page to load on the browser.

Smartphone (please complete the following information):

• Device: Viewsonic NMP309-W digital signage device
• OS: Android 7.1.1
• Browser Android WebView
• Version 68

Additional context It looks like the UA being sent by this browser is simply too long for the DakBoard screen to load. Not sure if there's anything you can do to fix this. We have 12 of these boxes and I was hoping to reuse them to move to using DakBoard, but if we can't, we can't. Thanks and keep up the awesome work on this system!

[cocarrig]

Hi @omega9380,

I think we can provide a solution to this problem based on some discussion of how we are using this data. I will drop this into our development project.

[Dan-Peck]

Merged in @ 00ef602 and added to the queue for upcoming release to the live site.

[omega9380]

It works! I was able to load DakBoards on the ViewSonic devices today. Thanks a lot!