Now I have the same SQL error I had late last night:
Fatal Error - sorry this shouldn't happen. SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'value' cannot be null
This is what i have in my General Log file:
TCP Port: 3306, Named Pipe: XIBO
Time Id Command Argument
2020-03-06T11:49:38.652189Z 1 Query SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE CREATE_OPTIONS LIKE '%partitioned%';
2020-03-06T11:50:06.012292Z 3 Connect root@localhost on using TCP/IP
2020-03-06T11:50:06.031620Z 3 Init DB mysql
2020-03-06T11:50:08.188688Z 3 Query set global general_log=on
2020-03-06T11:50:16.092835Z 4 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T11:50:16.092835Z 4 Query SET NAMES 'utf8'
2020-03-06T11:50:16.092835Z 4 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T11:50:16.231360Z 4 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T11:50:16.262541Z 5 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T11:50:16.278174Z 5 Query SET NAMES 'utf8'
2020-03-06T11:50:16.278174Z 5 Query SELECT `session_data`, `isexpired`, `useragent`, `session_expiration`, `userId`
FROM `session`
WHERE `session_id` = 'irreep2mll5o0t8830ll4ekbbh'
2020-03-06T11:50:16.293802Z 4 Query START TRANSACTION
2020-03-06T11:50:16.293802Z 4 Query UPDATE `setting` SET `value` = NULL WHERE `setting` = 'audit'
2020-03-06T11:50:16.293802Z 5 Query START TRANSACTION
2020-03-06T11:50:16.309422Z 5 Query UPDATE `session` SET
session_data = 'init|s:1:\"1\";',
session_expiration = '1583496856',
LastAccessed = '2020-03-06 11:50:16',
userID = '0',
IsExpired = '1'
WHERE session_id = 'irreep2mll5o0t8830ll4ekbbh'
2020-03-06T11:50:16.309422Z 5 Query COMMIT
2020-03-06T11:50:16.309422Z 5 Quit
2020-03-06T11:50:16.309422Z 4 Query ROLLBACK
2020-03-06T11:50:16.309422Z 4 Quit
2020-03-06T11:50:30.794137Z 6 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T11:50:30.794137Z 6 Query SET NAMES 'utf8'
2020-03-06T11:50:30.794137Z 6 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T11:50:30.903713Z 6 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T11:50:30.919083Z 6 Query START TRANSACTION
2020-03-06T11:50:30.919083Z 6 Query UPDATE `setting` SET `value` = NULL WHERE `setting` = 'audit'
2020-03-06T11:50:30.919083Z 6 Query ROLLBACK
2020-03-06T11:50:30.919083Z 6 Quit
2020-03-06T11:50:43.125346Z 3 Query set global general_log=off
Running this command:
update
setting set value="emergency" where setting="audit";
has allowed Xibo to load to the update screen, but the start button wouldn’t do anything in Chrome, it is running through in edge though at the moment.
Now stuck at 104 “Update all Videos with their real duration” been there for about fifteen / twenty minutes so far.
eventually this error came up:
SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
If i enable the general SQL log I can see the following events:
2020-03-06T13:09:01.091453Z 2170 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
AND module = 'image' ORDER BY Module
2020-03-06T13:09:01.107071Z 2170 Quit
2020-03-06T13:09:01.107071Z 2171 Query START TRANSACTION
2020-03-06T13:09:01.107071Z 2171 Query UPDATE `session` SET
session_data = 'init|s:1:\"1\";csrfToken|s:40:\"f0e46ada1cb1928b7cabc0a5d41d728839700b32\";slim.flash|a:0:{}userid|i:1;',
session_expiration = '1583500453',
LastAccessed = '2020-03-06 13:09:01',
userID = '1',
IsExpired = '0'
WHERE session_id = 'oavu39onfg23sovmk32i2tnlj3'
2020-03-06T13:09:01.107071Z 2171 Query COMMIT
2020-03-06T13:09:01.107071Z 2171 Quit
2020-03-06T13:09:05.307370Z 2061 Query UPDATE `media`
SET `name` = 'Kings Hill School Playground.mp4',
duration = '1616',
retired = '0',
moduleSystemFile = '0',
editedMediaId = '0',
isEdited = '0',
userId = '1',
released = '1',
apiRef = NULL
WHERE mediaId = '26190'
2020-03-06T13:09:05.307370Z 2061 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
AND module = 'video' ORDER BY Module
2020-03-06T13:09:06.184756Z 2172 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:06.184756Z 2172 Query SET NAMES 'utf8'
2020-03-06T13:09:06.184756Z 2172 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T13:09:06.278460Z 2172 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:06.356650Z 2172 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
ORDER BY Module
2020-03-06T13:09:06.403515Z 2172 Query SELECT version() AS v
2020-03-06T13:09:06.403515Z 2172 Query SELECT display.displayId,
display.display,
display.defaultLayoutId,
layout.layout AS defaultLayout,
display.license,
display.licensed,
display.licensed AS currentlyLicensed,
display.loggedIn,
display.lastAccessed,
display.auditingUntil,
display.inc_schedule AS incSchedule,
display.email_alert AS emailAlert,
display.alert_timeout AS alertTimeout,
display.clientAddress,
display.mediaInventoryStatus,
display.macAddress,
display.macAddress AS currentMacAddress,
display.lastChanged,
display.numberOfMacAddressChanges,
display.lastWakeOnLanCommandSent,
display.wakeOnLan AS wakeOnLanEnabled,
display.wakeOnLanTime,
display.broadCastAddress,
display.secureOn,
display.cidr,
ST_X(display.GeoLocation) AS latitude,
ST_Y(display.GeoLocation) AS longitude,
display.client_type AS clientType,
display.client_version AS clientVersion,
display.client_code AS clientCode,
display.displayProfileId,
display.screenShotRequested,
display.storageAvailableSpace,
display.storageTotalSpace,
displaygroup.displayGroupId,
displaygroup.description,
`display`.xmrChannel,
`display`.xmrPubKey,
`display`.lastCommandSuccess,
`display`.deviceName,
`display`.timeZone,
`display`.overrideConfig
FROM `display`
INNER JOIN `lkdisplaydg`
ON lkdisplaydg.displayid = display.displayId
INNER JOIN `displaygroup`
ON displaygroup.displaygroupid = lkdisplaydg.displaygroupid
AND `displaygroup`.isDisplaySpecific = 1
LEFT OUTER JOIN layout
ON layout.layoutid = display.defaultlayoutid
WHERE 1 = 1 AND display.license = 'b5b490efd94c8fef32c215378619c395' ORDER BY display
2020-03-06T13:09:06.419088Z 2173 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:06.419088Z 2173 Query SET NAMES 'utf8'
2020-03-06T13:09:06.419088Z 2173 Query INSERT INTO log (runNo, logdate, channel, type, page, function, message, userid, displayid)
VALUES ('88bb8ee', '2020-03-06 13:09:06', 'XMDS', 'ERROR', 'NotifyStatus', 'POST', 'SQLSTATE[42S22]: Column not found: 1054 Unknown column \'display.auditingUntil\' in \'field list\'', '0', '0')
2020-03-06T13:09:06.434780Z 2173 Quit
2020-03-06T13:09:06.434780Z 2172 Quit
2020-03-06T13:09:10.701724Z 2174 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:10.701724Z 2174 Query SET NAMES 'utf8'
2020-03-06T13:09:10.701724Z 2174 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T13:09:10.795495Z 2174 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:10.873603Z 2174 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
ORDER BY Module
2020-03-06T13:09:10.904869Z 2174 Query SELECT version() AS v
2020-03-06T13:09:10.904869Z 2174 Query SELECT display.displayId,
display.display,
display.defaultLayoutId,
layout.layout AS defaultLayout,
display.license,
display.licensed,
display.licensed AS currentlyLicensed,
display.loggedIn,
display.lastAccessed,
display.auditingUntil,
display.inc_schedule AS incSchedule,
display.email_alert AS emailAlert,
display.alert_timeout AS alertTimeout,
display.clientAddress,
display.mediaInventoryStatus,
display.macAddress,
display.macAddress AS currentMacAddress,
display.lastChanged,
display.numberOfMacAddressChanges,
display.lastWakeOnLanCommandSent,
display.wakeOnLan AS wakeOnLanEnabled,
display.wakeOnLanTime,
display.broadCastAddress,
display.secureOn,
display.cidr,
ST_X(display.GeoLocation) AS latitude,
ST_Y(display.GeoLocation) AS longitude,
display.client_type AS clientType,
display.client_version AS clientVersion,
display.client_code AS clientCode,
display.displayProfileId,
display.screenShotRequested,
display.storageAvailableSpace,
display.storageTotalSpace,
displaygroup.displayGroupId,
displaygroup.description,
`display`.xmrChannel,
`display`.xmrPubKey,
`display`.lastCommandSuccess,
`display`.deviceName,
`display`.timeZone,
`display`.overrideConfig
FROM `display`
INNER JOIN `lkdisplaydg`
ON lkdisplaydg.displayid = display.displayId
INNER JOIN `displaygroup`
ON displaygroup.displaygroupid = lkdisplaydg.displaygroupid
AND `displaygroup`.isDisplaySpecific = 1
LEFT OUTER JOIN layout
ON layout.layoutid = display.defaultlayoutid
WHERE 1 = 1 AND display.license = 'b5b490efd94c8fef32c215378619c395' ORDER BY display
2020-03-06T13:09:10.920478Z 2175 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:10.920478Z 2175 Query SET NAMES 'utf8'
2020-03-06T13:09:10.920478Z 2175 Query INSERT INTO log (runNo, logdate, channel, type, page, function, message, userid, displayid)
VALUES ('bf667a2', '2020-03-06 13:09:10', 'XMDS', 'ERROR', 'RegisterDisplay', 'POST', 'SQLSTATE[42S22]: Column not found: 1054 Unknown column \'display.auditingUntil\' in \'field list\'', '0', '0')
2020-03-06T13:09:10.936123Z 2175 Quit
2020-03-06T13:09:10.936123Z 2174 Quit
2020-03-06T13:09:11.326751Z 2176 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:11.326751Z 2176 Query SET NAMES 'utf8'
2020-03-06T13:09:11.326751Z 2176 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T13:09:11.436112Z 2176 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:11.498609Z 2176 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
ORDER BY Module
2020-03-06T13:09:11.545475Z 2176 Query SELECT version() AS v
2020-03-06T13:09:11.545475Z 2176 Query SELECT display.displayId,
display.display,
display.defaultLayoutId,
layout.layout AS defaultLayout,
display.license,
display.licensed,
display.licensed AS currentlyLicensed,
display.loggedIn,
display.lastAccessed,
display.auditingUntil,
display.inc_schedule AS incSchedule,
display.email_alert AS emailAlert,
display.alert_timeout AS alertTimeout,
display.clientAddress,
display.mediaInventoryStatus,
display.macAddress,
display.macAddress AS currentMacAddress,
display.lastChanged,
display.numberOfMacAddressChanges,
display.lastWakeOnLanCommandSent,
display.wakeOnLan AS wakeOnLanEnabled,
display.wakeOnLanTime,
display.broadCastAddress,
display.secureOn,
display.cidr,
ST_X(display.GeoLocation) AS latitude,
ST_Y(display.GeoLocation) AS longitude,
display.client_type AS clientType,
display.client_version AS clientVersion,
display.client_code AS clientCode,
display.displayProfileId,
display.screenShotRequested,
display.storageAvailableSpace,
display.storageTotalSpace,
displaygroup.displayGroupId,
displaygroup.description,
`display`.xmrChannel,
`display`.xmrPubKey,
`display`.lastCommandSuccess,
`display`.deviceName,
`display`.timeZone,
`display`.overrideConfig
FROM `display`
INNER JOIN `lkdisplaydg`
ON lkdisplaydg.displayid = display.displayId
INNER JOIN `displaygroup`
ON displaygroup.displaygroupid = lkdisplaydg.displaygroupid
AND `displaygroup`.isDisplaySpecific = 1
LEFT OUTER JOIN layout
ON layout.layoutid = display.defaultlayoutid
WHERE 1 = 1 AND display.license = 'b5b490efd94c8fef32c215378619c395' ORDER BY display
2020-03-06T13:09:11.561202Z 2177 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:11.561202Z 2177 Query SET NAMES 'utf8'
2020-03-06T13:09:11.561202Z 2177 Query INSERT INTO log (runNo, logdate, channel, type, page, function, message, userid, displayid)
VALUES ('f59e1ca', '2020-03-06 13:09:11', 'XMDS', 'ERROR', 'SubmitLog', 'POST', 'SQLSTATE[42S22]: Column not found: 1054 Unknown column \'display.auditingUntil\' in \'field list\'', '0', '0')
2020-03-06T13:09:11.576738Z 2177 Quit
2020-03-06T13:09:11.576738Z 2176 Quit
2020-03-06T13:09:14.686099Z 2178 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:14.686099Z 2178 Query SET NAMES 'utf8'
2020-03-06T13:09:14.686099Z 2178 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T13:09:14.795528Z 2178 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:14.811153Z 2179 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:14.811153Z 2179 Query SET NAMES 'utf8'
2020-03-06T13:09:14.811153Z 2179 Query SELECT `session_data`, `isexpired`, `useragent`, `session_expiration`, `userId`
FROM `session`
WHERE `session_id` = 'l4q87u481735s0csqmpkmpnpr2'
2020-03-06T13:09:14.811153Z 2178 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:14.920526Z 2178 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
in the xibo log file:
+-------+---------+---------------------+---------+-------+-----------------+----------+------------------------------------------------------------------------------------------------+--------+-----------+
| logid | runNo | logdate | channel | type | page | function | message | userID | displayID |
+-------+---------+---------------------+---------+-------+-----------------+----------+------------------------------------------------------------------------------------------------+--------+-----------+
| 1 | 101140e | 2020-03-06 13:36:48 | XMDS | ERROR | SubmitLog | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 2 | 2717eec | 2020-03-06 13:36:48 | XMDS | ERROR | RegisterDisplay | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 3 | 8403bf4 | 2020-03-06 13:36:50 | XMDS | ERROR | GetResource | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 4 | 09e4ed7 | 2020-03-06 13:36:53 | XMDS | ERROR | NotifyStatus | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 5 | 9a70955 | 2020-03-06 13:36:57 | XMDS | ERROR | Schedule | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 6 | f5ba752 | 2020-03-06 13:36:57 | XMDS | ERROR | RequiredFiles | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
+-------+---------+---------------------+---------+-------+-----------------+----------+------------------------------------------------------------------------------------------------+--------+-----------+