Schedule Now Issue

Asked by Phrutti

I click "Schedule Now" button on Layout Designed page. Then I input the duration for show on display, Then I click save and received message "Could not INSERT a new Schedule".

How can fixed this problem

Thank you in advance

Bhrutti

Question information

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

What version are you using?

Revision history for this message
Phrutti (phrutti) said :
#2

Thank you very for your quickly reply, I use version 1.3.2

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

I've just tried on my test 1.3.2 system and it worked fine.

Can you tell me:

1. Is this a new 1.3.2 installation or was it an upgrade?
2. Are you trying to schedule now on one display, a display group, or multiple displays or display groups?
3. Does it do it with all layouts or only one?
4. What is logged in the Xibo log for that event?

Alex

Revision history for this message
Phrutti (phrutti) said :
#4

1. Is this a new 1.3.2 installation or was it an upgrade?
    Ans: This is new installation
2. Are you trying to schedule now on one display, a display group, or multiple displays or display groups?
    Ans: I try on 2 display individual
3. Does it do it with all layouts or only one?
    All display is same layout
4. What is logged in the Xibo log for that event?
    The log is empty

Please advice

Bhrutti

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

Something should have been logged if an error came up.

I expect you have the filter settings on log set incorrectly.

Can you run the Report Fault wizard from the Management Menu please and email the troubleshoot.txt to <email address hidden> and I'll see if there's anything useful.

Alex

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

From the log you sent:

Date: 2012-06-13 17:06:59
Page: Schedule
Function: Add
Message: IN

Date: 2012-06-13 17:06:59
Page: schedule
Function:
Message: INSERT INTO `schedule` ( layoutid , DisplayGroupIDs , userID , is_priority , recurrence_type , recurrence_detail, recurrence_range , FromDT , ToDT ) VALUES ( 4 , '11' , 1 , 1 , '' , '1' , 0 , 1339582019 , 1339582319 )

Date: 2012-06-13 17:06:59
Page: schedule
Function:
Message: <errormsg>The query [INSERT INTO `schedule` ( layoutid , DisplayGroupIDs , userID , is_priority , recurrence_type , recurrence_detail, recurrence_range , FromDT , ToDT ) VALUES ( 4 , '11' , 1 , 1 , '' , '1' , 0 , 1339582019 , 1339582319 )] failed to executeData truncated for column 'recurrence_type' at row 1</errormsg>
<errornum>1024</errornum>
<errortype>User Notice</errortype>
<scriptname>...\lib\data\schedule.data.class.php</scriptname>
<scriptlinenum>94</scriptlinenum>

Date: 2012-06-13 17:06:59
Page: Data Module
Function: SetError
Message: Data Class: Error Number [25001] Error Message [Could not INSERT a new Schedule]

Date: 2012-06-13 17:06:59
Page: schedule
Function:
Message: <errormsg>Could not INSERT a new Schedule</errormsg>
<errornum>256</errornum>
<errortype>User Error</errortype>
<scriptname>...\lib\pages\schedule.class.php</scriptname>
<scriptlinenum>1879</scriptlinenum>

Date: 2012-06-13 17:06:59
Page: schedule
Function:
Message: Creating a Response Manager to deal with the HALT Error.

Ideas Dan?

Alex

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

Id have to run that SQL statement on a test database, which I can do this evening. Not sure what the problem could be though ... how could '' be truncated....

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

Can you please try editing lib/data/schedule.data.class.php and changing:

Line 61: if ($recType != 'null')
change to: if ($recType != '' && $recType != 'null')

Line 81: if ($recType != 'null')
change to: if ($recType != '' && $recType != 'null')

I think this will fix the problem

Can you help with this problem?

Provide an answer of your own, or ask Phrutti for more information if necessary.

To post a message you must log in.