Lock not working on postgres

nextcloud / files_lock

GNU Affero General Public License v3.0

25 stars 8 forks source link

Lock not working on postgres #15

Closed juliusknorr closed 4 years ago

juliusknorr commented 4 years ago

An exception occurred while executing 'INSERT INTO "oc_files_lock" ("user_id", "file_id", "token", "creation") VALUES(?, ?, ?, ?)' with params ["admin", 1512, "files_lock\/bf882238-366f-4e45-a22f-e46a692fea9a", 1576656238]: SQLSTATE[22008]: Datetime field overflow: 7 ERROR: date/time field value out of range: "1576656238" HINT: Perhaps you need a different "datestyle" setting.

@daita

ArtificialOwl commented 4 years ago

./occ files:lock --uninstall
./occ app:enable files_lock

DanScharon commented 4 years ago

./occ files:lock --uninstall
./occ app:enable files_lock

Even after doing this I still get warnings:

ERROR:  invalid input syntax for integer: "2020-05-20 12:25:02"
STATEMENT:  SELECT "l"."id", "l"."user_id", "l"."file_id", "l"."token", "l"."creation" FROM "oc_files_lock" "l" WHERE ("l"."creation" <= $1) OR ("l"."creation" IS NULL)