<p>I believe this has been fixed in the latest version of Feed Me (<a href="https://github.com/verbb/feed-me/releases" rel="nofollow noreferrer">3.0.2.1</a> at time of writing). Do feel free to comment if not, or get in touch via the <a href="https://verbb.io/craft-plugins/feed-me/docs/support/get-support" rel="nofollow noreferrer">Feed Me support channels</a></p>

CC BY-SA 4.0
2018-12-26T21:06:21.157Z
2018-12-26T21:06:21.157Z
crawf
<p>I'm currently getting the following error when matching on an entry field.</p>

<p><code>Offers Test: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer ~~ unknown LINE 3: WHERE "id" LIKE $1 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. The SQL being executed was: SELECT "structureId" FROM "sections" WHERE "id" LIKE '%' LIMIT 1 - Schema.php:664</code>    </p>

<p>Currently, I have two channels one is called "Brands" and the other "Offers". Offers has an Entry field which I'm trying to match on this field, see the below image:</p>

<p><a href="https://i.sstatic.net/Yi3PD.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Yi3PD.png" alt="enter image description here"></a></p>

<entries><plugin-feedme><postgresql>
SQL Error (Feed Me) when matching entries
# SQL Error (Feed Me) when matching entries

(Asked by: username_0 on 2018-05-23)

I'm currently getting the following error when matching on an entry field.

`Offers Test: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer ~~ unknown LINE 3: WHERE "id" LIKE $1 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. The SQL being executed was: SELECT "structureId" FROM "sections" WHERE "id" LIKE '%' LIMIT 1 - Schema.php:664`

Currently, I have two channels one is called "Brands" and the other "Offers". Offers has an Entry field which I'm trying to match on this field, see the below image:

[![enter image description here](https://i.sstatic.net/Yi3PD.png)](https://i.sstatic.net/Yi3PD.png)

**Tags:** entries, plugin-feedme, postgresql

---

## 1 answers

### Answer by username_1 on 2018-12-26. Score: 2 | Accepted answer

I believe this has been fixed in the latest version of Feed Me ([3.0.2.1](https://github.com/verbb/feed-me/releases) at time of writing). Do feel free to comment if not, or get in touch via the [Feed Me support channels](https://verbb.io/craft-plugins/feed-me/docs/support/get-support)


---

