0001: SET sql_mode = ? 0.0005s

0002: SHOW DATABASES LIKE 'asuredb' 0.001s

0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW' 0.009s

0004: SHOW FULL FIELDS IN "Member" 0.0034s

0005: SHOW COLLATION LIKE 'utf8mb3_general_ci' 0.0014s

0006: SHOW FULL FIELDS IN "Group" 0.0016s

0007: SHOW FULL FIELDS IN "Permission" 0.0015s

0008: SHOW FULL FIELDS IN "SiteConfig" 0.0028s

0009: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."AllChangesEnabled", "SiteConfig"."ReviewPeriodDays", "SiteConfig"."ReviewFrom", "SiteConfig"."ReviewSubject", "SiteConfig"."ReviewBody", "SiteConfig"."Fallback", "SiteConfig"."FallbackLink", "SiteConfig"."FallbackResponseCode", "SiteConfig"."OGSiteName", "SiteConfig"."TwitterHandle", "SiteConfig"."CreatorTwitterHandle", "SiteConfig"."FacebookAppID", "SiteConfig"."UseTitleAsMetaTitle", "SiteConfig"."SchemaOrganisationName", "SiteConfig"."GACode", "SiteConfig"."FacebookURL", "SiteConfig"."TwitterUsername", "SiteConfig"."FooterLogoLink", "SiteConfig"."FooterLogoDescription", "SiteConfig"."FooterLogoSecondaryLink", "SiteConfig"."FooterLogoSecondaryDescription", "SiteConfig"."EmptySearch", "SiteConfig"."NoSearchResults", "SiteConfig"."MainFontFamily", "SiteConfig"."HeaderBackground", "SiteConfig"."NavigationBarBackground", "SiteConfig"."CarouselBackground", "SiteConfig"."FooterBackground", "SiteConfig"."AccentColor", "SiteConfig"."TextLinkColor", "SiteConfig"."Phone", "SiteConfig"."Email", "SiteConfig"."TwitterURL", "SiteConfig"."LinkedInURL", "SiteConfig"."YoutubeURL", "SiteConfig"."OtherURL", "SiteConfig"."CtaEmail", "SiteConfig"."CtaThanks", "SiteConfig"."CtaText", "SiteConfig"."NZPhone", "SiteConfig"."NZAddress", "SiteConfig"."NZPostal", "SiteConfig"."AUPhone", "SiteConfig"."AUAddress", "SiteConfig"."AUPostal", "SiteConfig"."SingaporePhone", "SiteConfig"."SingaporeAddress", "SiteConfig"."SingaporePostal", "SiteConfig"."CopyrightText", "SiteConfig"."TitleDivider", "SiteConfig"."Announcement", "SiteConfig"."DefaultNewsletterStyle", "SiteConfig"."DefaultNewsletterModalTitle", "SiteConfig"."DefaultNewsletterTitle", "SiteConfig"."DefaultNewsletterText", "SiteConfig"."DefaultNewsletterThanksTitle", "SiteConfig"."DefaultNewsletterThanksText", "SiteConfig"."CrmUsername", "SiteConfig"."CrmPassword", "SiteConfig"."CrmClientSecret", "SiteConfig"."CrmClientId", "SiteConfig"."CrmTestURL", "SiteConfig"."CrmDevURL", "SiteConfig"."CrmProdURL", "SiteConfig"."EmailFooterCopy", "SiteConfig"."AkismetKey", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SchemaOrganisationImageID", "SiteConfig"."DefaultSocialImageID", "SiteConfig"."LogoID", "SiteConfig"."LogoRetinaID", "SiteConfig"."FooterLogoID", "SiteConfig"."FooterLogoRetinaID", "SiteConfig"."FooterLogoSecondaryID", "SiteConfig"."FavIconID", "SiteConfig"."AppleTouchIcon144ID", "SiteConfig"."AppleTouchIcon114ID", "SiteConfig"."AppleTouchIcon72ID", "SiteConfig"."AppleTouchIcon57ID", "SiteConfig"."DefaultBannerImageID", "SiteConfig"."DefaultNewsletterImageID", "SiteConfig"."SecondLogoID", "SiteConfig"."SecondLogoRetinaID", "SiteConfig"."TrainingLogoID", "SiteConfig"."SearchImageID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0012s

0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."AllowEmbargoedEditing", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."VanityMappingID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."URLSegment" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0013s

0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."AllowEmbargoedEditing", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."VanityMappingID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."URLSegment" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0024s

0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."AllowEmbargoedEditing", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."VanityMappingID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0013: SELECT DISTINCT count(DISTINCT "Iplist"."ID") AS "Count" FROM "Iplist" 0.0004s

0014: SELECT DISTINCT "Iplist"."ClassName", "Iplist"."LastEdited", "Iplist"."Created", "Iplist"."Ipaddress", "Iplist"."ID", CASE WHEN "Iplist"."ClassName" IS NOT NULL THEN "Iplist"."ClassName" ELSE 'Iplist' END AS "RecordClassName" FROM "Iplist" ORDER BY "Iplist"."Ipaddress" ASC 0.0003s

GET /services/laboratory-testing/?isDev=1&showqueries=1

[Emergency] Uncaught SilverStripe\ORM\Connect\DatabaseException: Couldn't run query: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'CWP\\CWP\\PageTypes\\BasePage', 'Page', 'AcademyPage', 'CampaignLandingPage', 'HomePage', 'IndustryEventPage', 'InvoicePage', 'QuizPage', 'SectionPage', 'TeamMemberPage', 'WebinarHolder', 'WebinarPage', 'WorkshopRegistrationPage', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'CourseFinderPage', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'AQNewsHolder', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'ContactPage', 'FormPage', 'PopupFormPage') THEN "SiteTree_Live"."Priority" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AcademyPage', 'CampaignLandingPage', 'HomePage', 'IndustryEventPage', 'InvoicePage', 'QuizPage', 'SectionPage', 'TeamMemberPage', 'WebinarHolder', 'WebinarPage', 'WorkshopRegistrationPage', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'CourseFinderPage', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'AQNewsHolder', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'ContactPage', 'FormPage', 'PopupFormPage') THEN "Page_Live"."Priority" ELSE NULL END AS "Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."AllowEmbargoedEditing", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."VanityMappingID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "Page_Live"."MetaTitle", "Page_Live"."Canonical", "Page_Live"."Robots", "Page_Live"."ChangeFrequency", "Page_Live"."SitemapHide", "Page_Live"."HideSocial", "Page_Live"."OGtype", "Page_Live"."OGlocale", "Page_Live"."TwitterCard", "Page_Live"."ShowServicesSidebarCTA", "Page_Live"."ServicesSidebarCTAHeading", "Page_Live"."ServicesSidebarCTASubheading", "Page_Live"."ServicesSidebarCTAButtonText", "Page_Live"."ServicesSidebarCTAButtonLink", "Page_Live"."HideSocialShare", "Page_Live"."BannerCaption", "Page_Live"."ShowNewsletterPopup", "Page_Live"."SchemaMetaType", "Page_Live"."Keywords", "Page_Live"."ExtraHeadScript", "Page_Live"."HideMenus", "Page_Live"."SearchCount", "Page_Live"."SocialImageID", "Page_Live"."ElementalAreaID", "Page_Live"."BannerImageID", "Page_Live"."MenuImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 Unknown column 'Page_Live.ShowServicesSidebarCTA' in 'field list'

GET /services/laboratory-testing/?isDev=1&showqueries=1

Line 64 in /container/application/public/vendor/silverstripe/framework/src/ORM/Connect/DBConnector.php

Source

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

Trace