After updating to package v1.10.0 (greenlight v3.8.0) the app frontend crashes

[dev-cb]

Root cause was a missing database entry for the new setting AccessibilityStatement. The frontend now always requests it:

/api/v1/site_settings.json?names[]=Terms&names[]=PrivacyPolicy&names[]=AccessibilityStatement

On existing installations, this setting may not exist (the data migration isn’t applied automatically), which causes the endpoint to return:

null

This leads to a frontend crash with error Cannot read properties of null (reading 'data').

Workaround (Confirmed)

Manually create the missing records:

1. Insert into settings

INSERT INTO settings (id, name, created_at, updated_at) VALUES (gen_random_uuid(), 'AccessibilityStatement', NOW(), NOW());

2. Insert corresponding rows into site_settings for all providers

INSERT INTO site_settings (id, setting_id, value, provider, created_at, updated_at)
SELECT
  gen_random_uuid(),
  s.id,
  '',
  p.provider,
  NOW(),
  NOW()
FROM
  (SELECT DISTINCT provider FROM site_settings) p
CROSS JOIN
  (SELECT id FROM settings WHERE name = 'AccessibilityStatement') s
WHERE NOT EXISTS (
  SELECT 1
  FROM site_settings ss
  WHERE ss.setting_id = s.id
    AND ss.provider = p.provider
);

After this, the endpoint returns valid data and the application works correctly.

---

Details and full context here:
https://github.com/bigbluebutton/greenlight/issues/6259

[james]

Hello @dev-cb
Thanks for reporting, providing a workaround and creating an upstream issue.
This is indeed a flaw from upstream that we did not catch in our CI life cycle test.
And I also think I found out why this fails for the Cloudron app but not for other styles of hosting Greenlight.

@dev-cb
Would you be able to assist in reproducing this error and testing a fix I have in mind?

[dev-cb]

@james Sure thing. I know from @luckow that there was an issue when a user did set up a profile picture. Maybe that is related and is a regression of a previous upstream version update which introduced a new setting.

Let me know how I can assist.