Creating new file folders in SS4.2.1 with PostgreSQL (pg_connect)

<%- if @topic_view.topic.tags.present? %>
<%= t 'js.tagging.tags' %>: <%- @topic_view.topic.tags.each do |t| %> <%= t %> <%- end %>
<% end %>

Silverstripe Version:

4.2.1

Question:

Is anyone else having difficulty running Silverstripe 4.2.1 with PostgreSQL 10.0? When I try to add a folder under Files in the CMS admin, I receive this 500 error:

ERROR [Emergency]: Uncaught SilverStripe\ORM\Connect\DatabaseException: Couldn’t run query:

SELECT DISTINCT “Group”.“ClassName”, “Group”.“LastEdited”, “Group”.“Created”, “Group”.“Title”, “Group”.“Description”, “Group”.“Code”, “Group”.“Locked”, “Group”.“Sort”, “Group”.“HtmlEditorConfig”, “Group”.“ParentID”, “Group”.“ID”,
CASE WHEN “Group”.“ClassName” IS NOT NULL THEN “Group”.“ClassName”
ELSE E’SilverStripe\Security\Group’ END AS “RecordClassName”

FROM “Group”

WHERE (“Group”.“ID” = $1)

LIMIT 1

ERROR: invalid input syntax for integer: “unchanged”
IN GET /admin/assets/schema/folderCreateForm/0
Line 64 in /var/www/html/html/vendor/silverstripe/framework/src/ORM/Connect/DBConnector.php

I tried a fresh install. I also tried a fresh install using MySQL instead, and everything works as expected. I’m guessing there’s some kind of escaping issue somewhere.

1 Like

Did you find the answer?
I have the same thing :confused: