Postgres: invalid input syntax for type bigint

Steps to reproduce

Enter "example (test)" value to any entity autocomplete field.

The following exception will be thrown.

The website encountered an unexpected error. Please try again later.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "test" LINE 5: ...('tags')) AND ("taxonomy_term_field_data"."tid" IN ('test')) ^: SELECT "base_table"."revision_id" AS "revision_id", "base_table"."tid" AS "tid" FROM "taxonomy_term_data" "base_table" INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "base_table"."tid" WHERE ("taxonomy_term_field_data"."vid" IN (:db_condition_placeholder_0)) AND ("taxonomy_term_field_data"."tid" IN (:db_condition_placeholder_1)); Array ( [:db_condition_placeholder_0] => tags [:db_condition_placeholder_1] => test ) in Drupal\Core\Entity\Query\Sql\Query->result() (line 273 of core/lib/Drupal/Core/Entity/Query/Sql/Query.php).

Comments & Activities

Issue created by @Chi
Status changed to Needs review over 2 years ago6:49pm 3 July 2023
Open in Jenkins → Open on Drupal.org →
Environment: PHP 8.1 & MySQL 5.7
last update over 2 years ago
29,439 pass, 1 fail
Comment over 2 years ago →
🇷🇺Russia Chi
Open in Jenkins → Open on Drupal.org →
Environment: PHP 8.2 & pgsql-14.1
last update over 2 years ago
29,439 pass, 1 fail
Comment over 2 years ago →
System Message
The last submitted patch, 2: postgres-invalid-input-syntax_3372068_2.patch, failed testing. View results →
Status changed to Needs work over 2 years ago8:18pm 3 July 2023
Comment over 2 years ago →
🇷🇺Russia Chi
The alternative solution could be casting field entity ID to text in SQL query.
Status changed to Active about 2 years ago4:44pm 6 October 2023
Comment about 2 years ago →
🇨🇦Canada joseph.olstad
Hello @chi, thank you for this fix, it works for me also. No longer a WSOD running psql with this situation .
I'm not quite sure on steps to reproduce in my case so I'll leave yours as it seems easier to reproduce.
This works on both psql 12 and psql 13

Fix applies to D9.5.x also.
Comment over 1 year ago →
🇷🇺Russia niklan Russia, Perm
Patch for Drupal 10.3+

Postgres: invalid input syntax for type bigint

Steps to reproduce

Details

Comments & Activities