Direct Database Query ERROR

Hey guys

, I have a simple function Direct Database Query that retrieves a single record from my database. However, I’m encountering an error every time because one of the columns in my database is of type uuid(list). Does anyone else experience this error? If so, do you have any suggestions or workarounds?

The SQL query:

SELECT * FROM x9_130 WHERE id = '16fcd5f0-4fc6-490e-81ac-14b629ea6c96';

The error:

Exception: SQLSTATE[]: Invalid text representation: 7 ERROR: invalid input syntax for type uuid: "["4f7a80e5-651c-40bb-a9e3-d9dea4be554b", "c207cde3-a4ca-4f60-b282-34b76b57a6e0"]" (SQL: SELECT * FROM x9_130 WHERE id = '16fcd5f0-4fc6-490e-81ac-14b629ea6c96';)

If I omit this column, it works perfectly, but this column is very important information for my logic.

Thank you in advance🙏🏽
Ray Deck Michael Udinski Louis Machado Lachlan

10 replies