Skip to content

[Bug] Messenger throwing errors that columns are missing - camelCase vs snake_case #364

@sm-item

Description

@sm-item

Hello Pimcore team,

we tried installing the Copilot bundle and as described in the documentation we also needed the Bundles PimcoreGenericExecutionEngineBundle and PimcoreGenericDataIndexBundle.

When starting the messenger locally to test & dev like this:
bin/console messenger:consume pimcore_generic_execution_engine pimcore_generic_data_index_queue scheduler_generic_data_index

We get errors that various columns are missing / not available as you can see here as an example:

[2025-11-17T13:41:39.975699+00:00] console.CRITICAL: Error thrown while running command "messenger:consume pimcore_generic_execution_engine pimcore_generic_data_index_queue scheduler_generic_data_index". Message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g0_.operation_time' in 'SELECT'" {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g0_.operation_time' in 'SELECT' at /var/www/html/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:52)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g0_.operation_time' in 'SELECT' at /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g0_.operation_time' in 'SELECT' at /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57)","command":"messenger:consume pimcore_generic_execution_engine pimcore_generic_data_index_queue scheduler_generic_data_index","message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g0_.operation_time' in 'SELECT'"} []

This happens with most columns in the tables generic_data_index_queue, generic_execution_engine_error_log, generic_execution_engine_job_run which are and only exist as camelCase - e.g. like the column operation_time from the error above which we only have as operationTime in the table after installation.

To test further, we added additional columns with the same names as snake_case manually to the tables. Then everything works as expected (as far we can see..)!

So either there are migrations missing from your side, or there are some column name conversions in one of the bundles code wrong.

EDIT:
Versions:

  • Pimcore 2025.3
  • pimcore/generic-data-index-bundle: 2.2.0

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions