Copy layout fails on some versions of MySQL

Bug #605152 reported by Alex Harrington
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Xibo
Fix Released
Medium
Alex Harrington

Bug Description

Copy Layout does not correctly pass in a createdDT or modifiedDT when copying a layout which causes an error on some versions of MySQL.

<errormsg>The query [ INSERT INTO layout (layout, permissionID, xml, userID, description, tags, templateID, retired, duration, background) SELECT 'Layout1 2', permissionID, xml, 1, description, tags, templateID, retired, duration, background FROM layout WHERE layoutid = 5] failed to execute<br />MySQL error: Field 'createdDT' doesn't have a default value</errormsg>
<errornum>1024</errornum>
<errortype>User Notice</errortype>
<scriptname>C:\Inetpub\wwwroot\digisign\lib\data\layout.data.class.php</scriptname>
<scriptlinenum>206</scriptlinenum>

<errormsg>Unable to Copy this Layout</errormsg>
<errornum>256</errornum>
<errortype>User Error</errortype>
<scriptname>C:\Inetpub\wwwroot\digisign\lib\pages\layout.class.php</scriptname>
<scriptlinenum>1901</scriptlinenum>

Related branches

Changed in xibo:
status: New → Confirmed
importance: Undecided → Medium
milestone: none → 1.2.0-rc2
Changed in xibo:
assignee: nobody → Alex Harrington (alexharrington)
Changed in xibo:
status: Confirmed → Fix Committed
Changed in xibo:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Related questions

Remote bug watches

Bug watches keep track of this bug in other bug trackers.