Postgres 9.4 JSONB data type has no default operator class #5170

New Issue

Closed

opened 2026-01-22 15:00:27 +01:00 by admin · 2 comments

admin commented 2026-01-22 15:00:27 +01:00

Owner

Copy Link

Originally created by @MattiasNilsson on GitHub (Jun 30, 2016).

When using the package doctrine/migrations (~1.0) together with doctrine/orm (~2.5) the following migrations fails. The migration itself worked nicely until I recenlty updated, and the last commit which was working were: https://github.com/doctrine/doctrine2/commit/4a38c96ec57e3c860c2e0c85cd98f09e685f398c

This is the backtrace of the error:

-> CREATE INDEX selectiontypes_data_ix ON tips_selectiontypes (data)
Migration 20160304100036_TableIndexes failed during Execution. Error An exception occurred while executing 'CREATE INDEX selectiontypes_data_ix ON tips_selectiontypes (data)':

SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree"
HINT: You must specify an operator class for the index or define a default operator class for the data type.

PHP Warning: strpos() expects parameter 1 to be string, array given in /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractAsset.php on line 70
PHP Stack trace:
PHP 1. {main}() /vagrant/cli.php:0
PHP 2. Symfony\Component\Console\Application->run() /vagrant/cli.php:88
PHP 3. Symfony\Component\Console\Application->doRun() /vagrant/vendor/symfony/console/Application.php:123
PHP 4. Symfony\Component\Console\Application->doRunCommand() /vagrant/vendor/symfony/console/Application.php:192
PHP 5. Symfony\Component\Console\Command\Command->run() /vagrant/vendor/symfony/console/Application.php:844
PHP 6. Doctrine\DBAL\Migrations\Tools\Console\Command\MigrateCommand->execute() /vagrant/vendor/symfony/console/Command/Command.php:259
PHP 7. Doctrine\DBAL\Migrations\Migration->migrate() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Tools/Console/Command/MigrateCommand.php:143
PHP 8. Doctrine\DBAL\Migrations\Version->execute() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Migration.php:176
PHP 9. BetterCollective\Migrations\Version20160119144038->up() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Version.php:289
PHP 10. Doctrine\DBAL\Schema\Table->addForeignKeyConstraint() /vagrant/src/BetterCollective/Migrations/Version20160119144038.php:85
PHP 11. Doctrine\DBAL\Schema\Table->addNamedForeignKeyConstraint() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:393
PHP 12. Doctrine\DBAL\Schema\ForeignKeyConstraint->__construct() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:448
PHP 13. Doctrine\DBAL\Schema\AbstractAsset->_setName() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/ForeignKeyConstraint.php:80
PHP 14. strpos() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractAsset.php:70
PHP Warning: explode() expects parameter 2 to be string, array given in /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractAsset.php on line 71
PHP Stack trace:
PHP 1. {main}() /vagrant/cli.php:0
PHP 2. Symfony\Component\Console\Application->run() /vagrant/cli.php:88
PHP 3. Symfony\Component\Console\Application->doRun() /vagrant/vendor/symfony/console/Application.php:123
PHP 4. Symfony\Component\Console\Application->doRunCommand() /vagrant/vendor/symfony/console/Application.php:192
PHP 5. Symfony\Component\Console\Command\Command->run() /vagrant/vendor/symfony/console/Application.php:844
PHP 6. Doctrine\DBAL\Migrations\Tools\Console\Command\MigrateCommand->execute() /vagrant/vendor/symfony/console/Command/Command.php:259
PHP 7. Doctrine\DBAL\Migrations\Migration->migrate() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Tools/Console/Command/MigrateCommand.php:143
PHP 8. Doctrine\DBAL\Migrations\Version->execute() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Migration.php:176
PHP 9. BetterCollective\Migrations\Version20160119144038->up() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Version.php:289
PHP 10. Doctrine\DBAL\Schema\Table->addForeignKeyConstraint() /vagrant/src/BetterCollective/Migrations/Version20160119144038.php:85
PHP 11. Doctrine\DBAL\Schema\Table->addNamedForeignKeyConstraint() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:393
PHP 12. Doctrine\DBAL\Schema\ForeignKeyConstraint->__construct() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:448
PHP 13. Doctrine\DBAL\Schema\AbstractAsset->_setName() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/ForeignKeyConstraint.php:80
PHP 14. explode() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractAsset.php:71

[Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing 'CREATE INDEX selectiontypes_data_ix ON tips_selectiontypes (data)':
SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree"
HINT: You must specify an operator class for the index or define a default operator class for the data type.

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree"
HINT: You must specify an operator class for the index or define a default operator class for the data type.

[PDOException]
SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree"
HINT: You must specify an operator class for the index or define a default operator class for the data type.

So what it fails on is that in the class Doctrine\DBAL\Schema\AbstractAsset and the following if (strpos($name, ".") !== false) which assumed that the $name variable is a string.

The command which fires this are the following:

$table = $schema->getTable('tips_selectiontypes');
$table->addIndex(['data'], 'selectiontypes_data_ix');

Any ideas?

Originally created by @MattiasNilsson on GitHub (Jun 30, 2016). When using the package doctrine/migrations (~1.0) together with doctrine/orm (~2.5) the following migrations fails. The migration itself worked nicely until I recenlty updated, and the last commit which was working were: [https://github.com/doctrine/doctrine2/commit/4a38c96ec57e3c860c2e0c85cd98f09e685f398c](https://github.com/doctrine/doctrine2/commit/4a38c96ec57e3c860c2e0c85cd98f09e685f398c) This is the backtrace of the error: > -> CREATE INDEX selectiontypes_data_ix ON tips_selectiontypes (data) > Migration 20160304100036_TableIndexes failed during Execution. Error An exception occurred while executing 'CREATE INDEX selectiontypes_data_ix ON tips_selectiontypes (data)': > > SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree" > HINT: You must specify an operator class for the index or define a default operator class for the data type. > > PHP Warning: strpos() expects parameter 1 to be string, array given in /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractAsset.php on line 70 > PHP Stack trace: > PHP 1. {main}() /vagrant/cli.php:0 > PHP 2. Symfony\Component\Console\Application->run() /vagrant/cli.php:88 > PHP 3. Symfony\Component\Console\Application->doRun() /vagrant/vendor/symfony/console/Application.php:123 > PHP 4. Symfony\Component\Console\Application->doRunCommand() /vagrant/vendor/symfony/console/Application.php:192 > PHP 5. Symfony\Component\Console\Command\Command->run() /vagrant/vendor/symfony/console/Application.php:844 > PHP 6. Doctrine\DBAL\Migrations\Tools\Console\Command\MigrateCommand->execute() /vagrant/vendor/symfony/console/Command/Command.php:259 > PHP 7. Doctrine\DBAL\Migrations\Migration->migrate() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Tools/Console/Command/MigrateCommand.php:143 > PHP 8. Doctrine\DBAL\Migrations\Version->execute() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Migration.php:176 > PHP 9. BetterCollective\Migrations\Version20160119144038->up() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Version.php:289 > PHP 10. Doctrine\DBAL\Schema\Table->addForeignKeyConstraint() /vagrant/src/BetterCollective/Migrations/Version20160119144038.php:85 > PHP 11. Doctrine\DBAL\Schema\Table->addNamedForeignKeyConstraint() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:393 > PHP 12. Doctrine\DBAL\Schema\ForeignKeyConstraint->__construct() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:448 > PHP 13. Doctrine\DBAL\Schema\AbstractAsset->_setName() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/ForeignKeyConstraint.php:80 > PHP 14. strpos() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractAsset.php:70 > PHP Warning: explode() expects parameter 2 to be string, array given in /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractAsset.php on line 71 > PHP Stack trace: > PHP 1. {main}() /vagrant/cli.php:0 > PHP 2. Symfony\Component\Console\Application->run() /vagrant/cli.php:88 > PHP 3. Symfony\Component\Console\Application->doRun() /vagrant/vendor/symfony/console/Application.php:123 > PHP 4. Symfony\Component\Console\Application->doRunCommand() /vagrant/vendor/symfony/console/Application.php:192 > PHP 5. Symfony\Component\Console\Command\Command->run() /vagrant/vendor/symfony/console/Application.php:844 > PHP 6. Doctrine\DBAL\Migrations\Tools\Console\Command\MigrateCommand->execute() /vagrant/vendor/symfony/console/Command/Command.php:259 > PHP 7. Doctrine\DBAL\Migrations\Migration->migrate() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Tools/Console/Command/MigrateCommand.php:143 > PHP 8. Doctrine\DBAL\Migrations\Version->execute() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Migration.php:176 > PHP 9. BetterCollective\Migrations\Version20160119144038->up() /vagrant/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Version.php:289 > PHP 10. Doctrine\DBAL\Schema\Table->addForeignKeyConstraint() /vagrant/src/BetterCollective/Migrations/Version20160119144038.php:85 > PHP 11. Doctrine\DBAL\Schema\Table->addNamedForeignKeyConstraint() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:393 > PHP 12. Doctrine\DBAL\Schema\ForeignKeyConstraint->__construct() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:448 > PHP 13. Doctrine\DBAL\Schema\AbstractAsset->_setName() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/ForeignKeyConstraint.php:80 > PHP 14. explode() /vagrant/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractAsset.php:71 > > [Doctrine\DBAL\Exception\DriverException] > An exception occurred while executing 'CREATE INDEX selectiontypes_data_ix ON tips_selectiontypes (data)': > SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree" > HINT: You must specify an operator class for the index or define a default operator class for the data type. > > [Doctrine\DBAL\Driver\PDOException] > SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree" > HINT: You must specify an operator class for the index or define a default operator class for the data type. > > [PDOException] > SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree" > HINT: You must specify an operator class for the index or define a default operator class for the data type. So what it fails on is that in the class **Doctrine\DBAL\Schema\AbstractAsset** and the following **if (strpos($name, ".") !== false)** which assumed that the $name variable is a string. The command which fires this are the following: $table = $schema->getTable('tips_selectiontypes'); $table->addIndex(['data'], 'selectiontypes_data_ix'); Any ideas?

admin closed this issue 2026-01-22 15:00:27 +01:00

admin commented 2026-01-22 15:00:28 +01:00

Author

Owner

Copy Link

@stof commented on GitHub (Jul 13, 2016):

There is no code of the ORM involved here. You should open an issue on DBAL

@stof commented on GitHub (Jul 13, 2016): There is no code of the ORM involved here. You should open an issue on DBAL

admin commented 2026-01-22 15:00:28 +01:00

Author

Owner

Copy Link

@stof commented on GitHub (Jul 13, 2016):

and btw, the code triggering this error is not $table->addIndex(['data'], 'selectiontypes_data_ix');. The stack traces is talking about Doctrine\DBAL\Schema\Table->addForeignKeyConstraint() /vagrant/src/BetterCollective/Migrations/Version20160119144038.php:85

@stof commented on GitHub (Jul 13, 2016): and btw, the code triggering this error is not `$table->addIndex(['data'], 'selectiontypes_data_ix');`. The stack traces is talking about `Doctrine\DBAL\Schema\Table->addForeignKeyConstraint() /vagrant/src/BetterCollective/Migrations/Version20160119144038.php:85`

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#5170