Exception in Scheduled Advertisements [ad_content_scheduler_scheduled_ad_content]: SQLSTATE[42S22]: Column not found

Created on 23 July 2025, 7 days ago

Problem/Motivation

After uninstalling the ad content scheduler module, the menu link for scheduled ad content is still present and produces the following error when clicked:

Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Scheduled Advertisements [ad_content_scheduler_scheduled_ad_content]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unknown' in 'ORDER BY': SELECT "ad_content_field_revision"."revision_id" AS "revision_id", "ad_content_field_data_ad_content_field_revision"."id" AS "ad_content_field_data_ad_content_field_revision_id" FROM "ad_content_field_revision" "ad_content_field_revision" LEFT JOIN "ad_content_field_data" "ad_content_field_data_ad_content_field_revision" ON ad_content_field_revision.id = ad_content_field_data_ad_content_field_revision.id AND ad_content_field_data_ad_content_field_revision.langcode = ad_content_field_revision.langcode WHERE "ad_content_field_revision"."revision_id" IN (SELECT MAX(base_table.revision_id) AS "revision_id" FROM "ad_content_field_revision" "base_table" GROUP BY "base_table"."id") ORDER BY "unknown" ASC LIMIT 50 OFFSET 0; Array ( ) in main() (line 19 of index.php).

Drupal\views\ViewExecutable->execute() (Line: 1516)
Drupal\views\ViewExecutable->render() (Line: 201)
Drupal\views\Plugin\views\display\Page->execute() (Line: 1692)
Drupal\views\ViewExecutable->executeDisplay() (Line: 80)
Drupal\views\Element\View::preRenderViewElement()
call_user_func_array() (Line: 107)
Drupal\Core\Render\Renderer->doTrustedCallback() (Line: 871)
Drupal\Core\Render\Renderer->doCallback() (Line: 433)
Drupal\Core\Render\Renderer->doRender() (Line: 222)
Drupal\Core\Render\Renderer->render() (Line: 242)
Drupal\Core\Render\MainContent\HtmlRenderer->Drupal\Core\Render\MainContent\{closure}() (Line: 622)
Drupal\Core\Render\Renderer->executeInRenderContext() (Line: 235)
Drupal\Core\Render\MainContent\HtmlRenderer->prepare() (Line: 131)
Drupal\Core\Render\MainContent\HtmlRenderer->renderResponse() (Line: 90)
Drupal\Core\EventSubscriber\MainContentViewSubscriber->onViewRenderArray() (Line: 246)
Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}() (Line: 206)
Symfony\Component\EventDispatcher\EventDispatcher->callListeners() (Line: 56)
Symfony\Component\EventDispatcher\EventDispatcher->dispatch() (Line: 188)
Symfony\Component\HttpKernel\HttpKernel->handleRaw() (Line: 76)
Symfony\Component\HttpKernel\HttpKernel->handle() (Line: 53)
Drupal\Core\StackMiddleware\Session->handle() (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle() (Line: 28)
Drupal\Core\StackMiddleware\ContentLength->handle() (Line: 32)
Drupal\big_pipe\StackMiddleware\ContentLength->handle() (Line: 116)
Drupal\page_cache\StackMiddleware\PageCache->pass() (Line: 90)
Drupal\page_cache\StackMiddleware\PageCache->handle() (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle() (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle() (Line: 53)
Drupal\Core\StackMiddleware\AjaxPageState->handle() (Line: 51)
Drupal\Core\StackMiddleware\StackedHttpKernel->handle() (Line: 715)
Drupal\Core\DrupalKernel->handle() (Line: 19)

Steps to reproduce

  • Install the ad content scheduler module
  • Make an ad content scheduled
  • Uninstall the ad content scheduler module
  • Go to the broken menu link under Content -> Advertisements -> Scheduled Advertisements

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Active

Version

11.0

Component

ad module

Created by

🇩🇪Germany lrwebks Porta Westfalica

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024