When autocomplete widget is chosen for a field and form with this widget got rebuild "target_id" is set to empty string which then get passed to entity_load() in entityreference_field_widget_form() and triggering "PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer" with PostgreSQL. This is not a problem for MySQL.

CommentFileSizeAuthor
#5 entityreference-2765885-4.patch466 bytesRoSk0
#2 entityreference-2765885-2.patch574 bytesRoSk0
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

RoSk0 created an issue. See original summary.

RoSk0’s picture

RoSk0
he/him
Primary language Russian
Location Wellington
CreditAttribution: RoSk0 at Catalyst IT commented
Status: Active » Needs review
FileSize
entityreference-2765885-2.patch574 bytes

Provided patch makes sure that "target_id" set for empty widget is not an empty string.

Status: Needs review » Needs work

The last submitted patch, 2: entityreference-2765885-2.patch, failed testing.

RoSk0’s picture

RoSk0
he/him
Primary language Russian
Location Wellington
CreditAttribution: RoSk0 at Catalyst IT commented
Status: Needs work » Needs review

Re-roll against latest version.

RoSk0’s picture

RoSk0
he/him
Primary language Russian
Location Wellington
CreditAttribution: RoSk0 at Catalyst IT commented
FileSize
entityreference-2765885-4.patch466 bytes

Sorry, missed actual patch.