Adding URL for privacy and other links not working #6149
Description
Current greenlight v3 (3.6.3) is somehow broken.
Trying to add privacy URL in backend as admin.
When hitting "Update URL" the spinner goes forever.
docker logs -f greenlight-v3 shows no error on level warn.
Also in debug, there is nothing which shows to any direction of errors:
D, [2025-11-22T19:18:55.324030 #1] DEBUG -- : [5c806ef7-d6e1-4ac4-9048-2f67fb1aaf67] SiteSetting Count (5.2ms) SELECT COUNT(*) FROM (SELECT DISTINCT "site_settings"."id" FROM "site_settings" LEFT OUTER JOIN "settings" "setting" ON "setting"."id" = "site_settings"."setting_id" WHERE "site_settings"."provider" = $1 AND "setting"."name" IN ($2, $3)) subquery_for_count [["provider", "greenlight"], ["name", "Terms"], ["name", "PrivacyPolicy"]]
D, [2025-11-22T19:18:55.324488 #1] DEBUG -- : [1345c7e7-8d44-4c61-95b9-1057dcadc2f1] User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."session_token" = $1 LIMIT $2 [["session_token", "[FILTERED]"], ["LIMIT", 1]]
D, [2025-11-22T19:18:55.327507 #1] DEBUG -- : [5c806ef7-d6e1-4ac4-9048-2f67fb1aaf67] SQL (3.3ms) SELECT "site_settings"."id" AS t0_r0, "site_settings"."setting_id" AS t0_r1, "site_settings"."value" AS t0_r2, "site_settings"."provider" AS t0_r3, "site_settings"."created_at" AS t0_r4, "site_settings"."updated_at" AS t0_r5, "setting"."id" AS t1_r0, "setting"."name" AS t1_r1, "setting"."created_at" AS t1_r2, "setting"."updated_at" AS t1_r3 FROM "site_settings" LEFT OUTER JOIN "settings" "setting" ON "setting"."id" = "site_settings"."setting_id" WHERE "site_settings"."provider" = $1 AND "setting"."name" IN ($2, $3) [["provider", "greenlight"], ["name", "Terms"], ["name", "PrivacyPolicy"]]
I, [2025-11-22T19:18:55.327973 #1] INFO -- : [5c806ef7-d6e1-4ac4-9048-2f67fb1aaf67] method=GET path=/api/v1/site_settings.json format=json controller=Api::V1::SiteSettingsController action=index status=200 allocations=2891 duration=9.52 view=0.28 db=8.47 time=2025-11-22 19:18:55 UTC host=greenlight
D, [2025-11-22T19:18:55.328805 #1] DEBUG -- : [1345c7e7-8d44-4c61-95b9-1057dcadc2f1] Role Load (0.6ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" = $1 LIMIT $2 [["id", "caaf0c64-1f66-438a-ac9d-dcb5adbeccef"], ["LIMIT", 1]]
D, [2025-11-22T19:18:55.330990 #1] DEBUG -- : [1345c7e7-8d44-4c61-95b9-1057dcadc2f1] Role Load (0.1ms) SELECT "roles".* FROM "roles" WHERE "roles"."name" = $1 AND "roles"."provider" = $2 LIMIT $3 [["name", "SuperAdmin"], ["provider", "bn"], ["LIMIT", 1]]
D, [2025-11-22T19:18:55.334928 #1] DEBUG -- : [1345c7e7-8d44-4c61-95b9-1057dcadc2f1] RolePermission Exists? (0.3ms) SELECT 1 AS one FROM "role_permissions" INNER JOIN "permissions" "permission" ON "permission"."id" = "role_permissions"."permission_id" WHERE "role_permissions"."role_id" = $1 AND "permission"."name" = $2 AND "role_permissions"."value" = $3 LIMIT $4 [["role_id", "caaf0c64-1f66-438a-ac9d-dcb5adbeccef"], ["name", "ManageSiteSettings"], ["value", "true"], ["LIMIT", 1]]
D, [2025-11-22T19:18:55.335687 #1] DEBUG -- : [1345c7e7-8d44-4c61-95b9-1057dcadc2f1] Setting Pluck (0.3ms) SELECT "settings"."name", "value" FROM "settings" INNER JOIN "site_settings" ON "site_settings"."setting_id" = "settings"."id" WHERE "settings"."name" IN ($1, $2, $3, $4) AND "site_settings"."provider" = $5 [["name", "Terms"], ["name", "PrivacyPolicy"], ["name", "HelpCenter"], ["name", "Maintenance"], ["provider", "greenlight"]]
I, [2025-11-22T19:18:55.336572 #1] INFO -- : [1345c7e7-8d44-4c61-95b9-1057dcadc2f1] method=GET path=/api/v1/admin/site_settings.json format=json controller=Api::V1::Admin::SiteSettingsController action=index status=200 allocations=3324 duration=16.85 view=0.79 db=1.51 time=2025-11-22 19:18:55 UTC host=greenlight
Sure, i can update this in pgsql myself, but i think this is not the right way ;-)
And for anybody who faces the same issue, updating in DB works fine, just execute:
UPDATE site_settings
SET value = 'https://www.your-server.tld/privacypolicy/'
WHERE setting_id = (
SELECT id FROM settings WHERE name = 'PrivacyPolicy'
);