Xibo

Displays won't register on new installation

Asked by spamking

I have a brand new server installation (Version 1.2.2) on Windows Server 2008 R2. I've installed client version 1.2.2, but can't get any clients to register.

I just get the "Error adding display" message . . .

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Alex Harrington
Solved:
Last query:
Last reply:
Revision history for this message
Alex Harrington (alexharrington) said : 		#1

What's in the server log?

Revision history for this message
spamking (spamking1) said : 		#2

The troubleshooting file from within Xibo?

Revision history for this message
Alex Harrington (alexharrington) said : 		#3

Can do

Revision history for this message
spamking (spamking1) said : 		#4

email on the way

Thanks.

Revision history for this message
Best Alex Harrington (alexharrington) said : 		#5

Can you try replacing lib/data/display.class.php with this file:

http://dl.dropbox.com/u/58386/Xibo-RELEASE/display.data.class.php

And see if it works then.

Alex

Revision history for this message
spamking (spamking1) said : 		#6

Thanks Alex. The new file allowed display registration.

Revision history for this message
spamking (spamking1) said : 		#7

Thanks Alex Harrington, that solved my question.

Revision history for this message
Tred44 (tdyson) said : 		#8

I've just had the same error and this has also fixed it.

Revision history for this message
Franz Schubert (rigne2) said : 		#9

Same Problem on on Version 1.2.3. Changing the display.data.class.php doesn´t fix it.
Log:
<errormsg>The query [INSERT INTO display ( display , isAuditing , defaultlayoutid, license , licensed , inc_schedule , email_alert , alert_timeout ) VALUES ( 'Pausenhalle', 0 , 1 , 'c43baac60b97b0b21c68127169700d2f', 0 , 0 , 1 , 0 )] failed to executeField 'NumberOfMacAddressChanges' doesn't have a default value</errormsg>
<errornum>1024</errornum>
<errortype>User Notice</errortype>
<scriptname>C:\inetpub\wwwroot\xibo\lib\data\display.data.class.php</scriptname>
<scriptlinenum>76</scriptlinenum>

Revision history for this message
Dan Garner (dangarner) said : 		#10

I think you mean 1.3.2?

Can you try running the following SQL:

ALTER TABLE `display` CHANGE `NumberOfMacAddressChanges` `NumberOfMacAddressChanges` INT( 11 ) NOT NULL DEFAULT '0';

I've created a bug: https://bugs.launchpad.net/xibo/+bug/932057

Revision history for this message
Franz Schubert (rigne2) said : 		#11

Thanks!

Yes I meant 1.3.2

Adding a display is working now.

But now the client is crashing after start......
Looking for a log to see what happens there.