QueryException: 'publish_on' not found (when installed via config-import)

Created on 27 July 2019, over 5 years ago
Updated 28 June 2023, over 1 year ago

I am getting this when scheduled publishing is enabled for a node type:

Drupal\Core\Entity\Query\QueryException: 'publish_on' not found in Drupal\Core\Entity\Query\Sql\Tables->ensureEntityTable() (line 367 of                             [error]
/vagrant/docroot/core/lib/Drupal/Core/Entity/Query/Sql/Tables.php).

Is there an installation schema that needs to run somewhere?

πŸ› Bug report
Status

Needs review

Version

2.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States bburg Washington D.C.

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Open in Jenkins β†’ Open on Drupal.org β†’
    Core: 10.1.x + Environment: PHP 8.1 & MySQL 8
    last update over 1 year ago
    223 pass
  • πŸ‡³πŸ‡±Netherlands daffie

    Rerolled the patch for 2.x.

  • πŸ‡§πŸ‡ͺBelgium Simon Govaert

    Adding another solution I found for this particular problem. At first, installation seemed ok as I could enable scheduler module and fill (un)publishing dates on content. Although the (un)publishing dates were never saved. It gave a hint that the installation was not made properly.

    It failed because of missing folders (default/files/tmp and default/files/translations). The installation made by "composer require" didn't tell where it failed.

  • πŸ‡ΊπŸ‡ΈUnited States katebron

    I am also getting locked out of uninstalling this module (2.1); for me, when i try to uninstall, i get an error message abut 'publish_on' not found in taxonomy_term_field_data. (Incidentally, i haven't set up scheduler to work with taxonomy terms at all). I have tried the patch in #22 and it doesn't help the problem, perhaps because it's looking at nodes only

  • πŸ‡³πŸ‡±Netherlands yustinTR
  • πŸ‡³πŸ‡±Netherlands yustinTR
  • πŸ‡³πŸ‡±Netherlands yustinTR

    Sorry my patches wont work i wanted to apply the previous patch and make it compatible with version 2.1.

Production build 0.71.5 2024