“Regular Maintenance”-task fails with an SQL-error

botboe · March 11, 2026, 2:11pm

CMS Version

4.4.0

Installation Method

Docker

Operating System

Docker on Ubuntu 24.04.4 LTS

Issue

The “Regular Maintenance”-task fails with an SQL-error. Even after a fresh reinstall.

21154,1e48606,"2026-03-11 09:46:01",CONSOLE,,GET,"Checking permissions against the logged in user: ID: 1, Name: xibo_admin, UserType: 1",,DEBUG,0
21155,1e48606,"2026-03-11 09:46:01",CONSOLE,,GET,"SET @permissionEntityForGroup=&#039;Xibo\Entity\Campaign&#039;;
SELECT `layout`.layoutID, 
                        `layout`.parentId,
                        `layout`.layout,
                        `layout`.description,
                        `layout`.duration,
                        `layout`.userID,
                        `user`.userName as owner,
                        `campaign`.CampaignID,
                        `campaign`.type,
                        `layout`.status,
                        `layout`.statusMessage,
                        `layout`.enableStat,
                        `layout`.width,
                        `layout`.height,
                        `layout`.retired,
                        `layout`.createdDt,
                        `layout`.modifiedDt,
                        `layout`.backgroundImageId,
                        `layout`.backgroundColor,
                        `layout`.backgroundzIndex,
                        `layout`.schemaVersion,
                        `layout`.publishedStatusId,
                        `status`.status AS publishedStatus,
                        `layout`.publishedDate,
                        `layout`.autoApplyTransitions,
                        `layout`.code,
                        `campaign`.folderId,
                        `campaign`.permissionsFolderId,
                    NULL as displayOrder,      (SELECT GROUP_CONCAT(DISTINCT `group`.group)
                          FROM `permission`
                            INNER JOIN `permissionentity`
                            ON `permissionentity`.entityId = permission.entityId
                            INNER JOIN `group`
                            ON `group`.groupId = `permission`.groupId
                         WHERE entity = @permissionEntityForGroup
                            AND objectId = campaign.CampaignID
                            AND view = 1
                        ) AS groupsWithPermissions    FROM layout   INNER JOIN status ON status.id = layout.publishedStatusId   INNER JOIN `lkcampaignlayout`    ON lkcampaignlayout.LayoutID = layout.LayoutID    INNER JOIN `campaign`    ON lkcampaignlayout.CampaignID = campaign.CampaignID        AND campaign.IsLayoutSpecific = 1   INNER JOIN `user` ON `user`.userId = `campaign`.userId  WHERE 1 = 1  AND layout.layoutID NOT IN (SELECT layoutId FROM lktaglayout INNER JOIN tag ON lktaglayout.tagId = tag.tagId WHERE tag = &#039;template&#039;)  AND layout.parentId IS NULL  AND campaign.CampaignID NOT IN (  )  
                     AND layout.layoutID NOT IN (SELECT DISTINCT defaultlayoutid FROM display) 
                     AND layout.layoutID NOT IN (SELECT DISTINCT layoutId FROM lklayoutdisplaygroup) 
                      AND campaign.type IN (&quot;media&quot;, &quot;playlist&quot;)  ORDER BY layout",,ERROR,0
21156,1e48606,"2026-03-11 09:46:01",CONSOLE,,GET,"run: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#039;)  
                     AND layout.layoutID NOT IN (SELECT DISTINCT defaultlayo&#039; at line 38 Exception Type: PDOException",,ERROR,0
21157,1e48606,"2026-03-11 09:46:01",CONSOLE,,GET,"#0 /var/www/cms/lib/Storage/PdoStorageService.php(327): PDOStatement-&gt;execute()

I believe, the problem lies in:

AND campaign.CampaignID NOT IN (  )

Which is, afair not a valid syntax.

Has anyone else seen this problem?

Best regards
Tobias