Xibo error while register display - 1364 Field 'overrideConfig' doesn't have a default value

Get Help
1

Hi,

we’ve setup our xibo cms through docker. Everything seems to be working fine. But when we try to connect a tablet through the android xibo app, we get the 500 error. In our log on xibo cms we get the following errors :frowning:

ID Run Date Channel Function Level Display Page Message
224 5ffdce9 2019-02-01 23:12 XMDS POST ERROR SubmitLog Not Found
223 723f31f 2019-02-01 23:12 XMDS POST ERROR RegisterDisplay SQLSTATE[HY000]: General error: 1364 Field ‘overrideConfig’ doesn’t have a default value
222 329fd22 2019-02-01 23:12 XMDS POST ERROR RegisterDisplay SQLSTATE[HY000]: General error: 1364 Field ‘overrideConfig’ doesn’t have a default value
221 ee34eef 2019-02-01 23:12 XMDS POST ERROR RegisterDisplay SQLSTATE[HY000]: General error: 1364 Field ‘overrideConfig’ doesn’t have a default value
220 266f121 2019-02-01 23:12 XMDS POST ERROR RegisterDisplay SQLSTATE[HY000]: General error: 1364 Field ‘overrideConfig’ doesn’t have a default value
2

Sorry to hear that you are receiving those errors. Can you confirm the following?

  • What version of the Xibo CMS have you installed? You can find this out by logging into your CMS and clicking the About button beneath the options on the left hand side.
  • What 500 error are you receiving? Please provide the full error code and message

Many Thanks.

3

Hi Dan, thanks for your help.

We have the latest cms image installed. CMS is showing us 1.8.12
The installed XMR is using the lastest image from 2018-09-15 18:52:20
For the Database we are using MariaDB: 10.3.12

The Android App is giving us the following error while connecting with the cms:
Unable to Register due to Error. HTTP request failed, HTTP status: 500

In the CMS we are seeing these logs:

316 ff8eaae 2019-02-04 13:23 XMDS POST ERROR SubmitLog Not Found
315 be68530 2019-02-04 13:23 XMDS POST ERROR RegisterDisplay SQLSTATE[HY000]: General error: 1364 Field ‘overrideConfig’ doesn’t have a default value

SQLSTATE[HY000]: General error: 1364 Field ‘overrideConfig’ doesn’t have a default value

4

Thank you for the further information about your setup. You mentioned that you are using MariaDB instead of MySQL, which is the default database for a Docker installation. Can you confirm that you followed the below guide to set up an external db for your Docker installation?

https://xibo.org.uk/docs/setup/xibo-docker-with-an-external-database

Many Thanks.

5

Yes, we’ve followed that guide.

But I can try today to build a new docker cms with mysql and look if the problem still exists.

6

Thanks for letting me know that you followed the Guide. I would first recommend running the below statement to see if this resolves your issue:

ALTER TABLE display MODIFY `overrideConfig` text NULL;

Please let me know if this helps to resolve the issue.

Many Thanks.

2 Likes
7

YOU ARE AWESOME! IT WORKS NOW!

The Android Device is appearing in the CMS and I could authorise it. It displays everthing fine!

THANK YOU SO MUCH !!!

8

That’s really good news, glad you’re up and running.

Many Thanks.

1 Like