Copy layout fails on some versions of MySQL
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>
<errortype>User Notice</errortype>
<scriptname>
<scriptlinenum>
<errormsg>Unable to Copy this Layout</errormsg>
<errornum>
<errortype>User Error</errortype>
<scriptname>
<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 |