Skip to content

Error when trying to modify an event to being recurrent

A sql error happen (using postgres):

Executing (default): SELECT "id", "title", "slug", "description", "multidate", "start_datetime", "end_datetime", "image_path", "media", "is_visible", "recurrent", "likes", "boost", "online_locations", "ap_object", "ap_id", "createdAt", "updatedAt", "placeId", "userId", "apUserApId", "parentId" FROM "events" AS "event" WHERE "event"."id" = '4';
Executing (default): UPDATE "events" SET "description"=$1,"start_datetime"=$2,"end_datetime"=$3,"recurrent"=$4,"updatedAt"=$5 WHERE "id" = $6
2024-01-17T19:50:49.813Z error: [EVENT UPDATE] invalid input syntax for type integer: "NaN"
Error
    at Query.run (/nix/store/q6zmc8mcqr5bgpcl28pqn8ykjk4vg7wx-gancio-1.12.0/libexec/gancio/node_modules/sequelize/lib/dialects/postgres/query.js:50:25)
    at /nix/store/q6zmc8mcqr5bgpcl28pqn8ykjk4vg7wx-gancio-1.12.0/libexec/gancio/node_modules/sequelize/lib/sequelize.js:315:28
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async PostgresQueryInterface.update (/nix/store/q6zmc8mcqr5bgpcl28pqn8ykjk4vg7wx-gancio-1.12.0/libexec/gancio/node_modules/sequelize/lib/dialects/abstract/query-interface.js:355:12)
    at async model.save (/nix/store/q6zmc8mcqr5bgpcl28pqn8ykjk4vg7wx-gancio-1.12.0/libexec/gancio/node_modules/sequelize/lib/model.js:2490:35)
    at async model.update (/nix/store/q6zmc8mcqr5bgpcl28pqn8ykjk4vg7wx-gancio-1.12.0/libexec/gancio/node_modules/sequelize/lib/model.js:2598:12)
    at async update (/nix/store/q6zmc8mcqr5bgpcl28pqn8ykjk4vg7wx-gancio-1.12.0/libexec/gancio/deps/gancio/server/api/controller/event.js:515:7)