Running Task AESO - Check pages status

2026-01-20 09:09:02   START TASK RUN!
Total LIVE pages count: 745

Total STAGE pages count: 1090

Total SiteTree objects count: 1090

Array
(
    [SilverStripe\CMS\Controllers\CMSSiteTreeFilter_StatusDeletedPages] => Archived pages
    [SilverStripe\CMS\Controllers\CMSSiteTreeFilter_StatusDraftPages] => Draft pages
    [SilverStripe\CMS\Controllers\CMSSiteTreeFilter_StatusRemovedFromDraftPages] => Live but removed from draft
    [SilverStripe\CMS\Controllers\CMSSiteTreeFilter_ChangedPages] => Modified pages
    [SilverStripe\CMS\Controllers\CMSSiteTreeFilter_DeletedPages] => All pages, including archived
    [SilverStripe\CMS\Controllers\CMSSiteTreeFilter_PublishedPages] => Published pages
    [DNADesign\Elemental\Controllers\ElementSiteTreeFilterSearch] => All pages
)
Archived pages (SilverStripe\CMS\Controllers\CMSSiteTreeFilter_StatusDeletedPages) - number of records: 813

Draft pages (SilverStripe\CMS\Controllers\CMSSiteTreeFilter_StatusDraftPages) - number of records: 345

Live but removed from draft (SilverStripe\CMS\Controllers\CMSSiteTreeFilter_StatusRemovedFromDraftPages) - number of records: 2

Modified pages (SilverStripe\CMS\Controllers\CMSSiteTreeFilter_ChangedPages) - number of records: 9

All pages, including archived (SilverStripe\CMS\Controllers\CMSSiteTreeFilter_DeletedPages) - number of records: 1905

Published pages (SilverStripe\CMS\Controllers\CMSSiteTreeFilter_PublishedPages) - number of records: 747

All pages (DNADesign\Elemental\Controllers\ElementSiteTreeFilterSearch) - number of records: 1090


DB table SiteTree - number of records: 1090

DB table SiteTree_Live - number of records: 747

DB table SiteTree_Versions - number of records: 49952

DB table SiteTree_Versions - number of unique RecordID records: 1905

DB table Block - number of records: 1018

DB table Block_Live - number of records: 984

DB table Block_versions - number of records: 15295

DB table Block_versions - number of unique RecordID records: 1412


LastEdited date might be wrong. After dev/build run between SS3 and SS4 DB table SiteTree_versions is updated to SiteTree_Versions and lastEdited updated to time of task run.

DRAFT PAGES - created & saved but never published

GET /dev/tasks/App-Web-Tasks-AesoPagesAndBlocksReport

[Emergency] Uncaught SilverStripe\ORM\Connect\DatabaseException: Couldn't run query: SELECT MAX(LastEdited) FROM SiteTree_versions_old WHERE RecordID = 1282 Table 'silverstripe.SiteTree_versions_old' doesn't exist

GET /dev/tasks/App-Web-Tasks-AesoPagesAndBlocksReport

Line 63 in /home/aeso/deploys/releases/20260119165806/vendor/silverstripe/framework/src/ORM/Connect/DBConnector.php

Source

54         if (!empty($sql)) {
55             $formatter = SQLFormatter::create();
56             $formattedSQL = $formatter->formatPlain($sql);
57             $msg = "Couldn't run query:\n\n{$formattedSQL}\n\n{$msg}";
58         }
59 
60         if ($errorLevel === E_USER_ERROR) {
61             // Treating errors as exceptions better allows for responding to errors
62             // in code, such as credential checking during installation
63             throw new DatabaseException($msg, 0, null, $sql, $parameters);
64         } else {
65             user_error($msg ?? '', $errorLevel ?? 0);
66         }
67     }
68 
69     protected function duplicateEntryError(

Trace