PostgreSQL error caused by \,

[yihanwu1024]

Sabre/DAV 4.7.0
PostgreSQL 15

Whenever a calendar or contact field contains a comma , (escaped to \,) it will fail to save.

<?xml version="1.0" encoding="utf-8"?>
<d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns">
  <s:sabredav-version>4.7.0</s:sabredav-version>
  <s:exception>PDOException</s:exception>
  <s:message>SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type bytea
CONTEXT:  unnamed portal parameter $3 = '...'</s:message>
</d:error>

[yihanwu1024]

Might be relevant: laravel/framework#43070

[johamb]

I also encountered this issue using PostgreSQL 14 and 17.
As a workaround, i wrote a ServerPlugin which replaces single backslashes with double backslashes:

<?php

namespace Custom\CalDAV\Sanitizer;

use Sabre\DAV\ServerPlugin;
use Sabre\DAV\Server;

class SanitizerPlugin extends ServerPlugin
{
    function initialize(Server $server)
    {
        $server->on("beforeCreateFile", [$this, "handleSanitizationCreate"]);
        $server->on("beforeWriteContent", [$this, "handleSanitizationUpdate"]);
    }

    function handleSanitizationCreate($path, &$data, \Sabre\DAV\ICollection $parent, &$modified)
    {
        if (is_resource($data)) {
            $data = stream_get_contents($data);
        }
        $data = str_replace('\\', '\\\\', $data);
    }

    function handleSanitizationUpdate($path, \Sabre\DAV\IFile $node, &$data, &$modified)
    {
        if (is_resource($data)) {
            $data = stream_get_contents($data);
        }
        $data = str_replace('\\', '\\\\', $data);
    }
}