Duplicate Public Access roles, Public pages: Session not authenticated

[SimonDoll]

Checklist

• [ x] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker single image
  • Budibase Version: 2.33.4
• Cloud: also affected

Describe the bug The user roles of budibase tables seem messed up (Capitalized vs non-capitalized). Depending on the app they also change:

It is unclear what the "right" public role is.

When accessing a public page e.g. with a form that writes to a table with public write access this causes a "Session not authenticated" error.

To Reproduce Steps to reproduce the behavior:

1. Create a new app, use the visitor-check-in-form template
2. Publish the app
3. Open the app with an unauthenticated browser window
4. See error: (2) Session not authenticated

Expected behavior

• Only a single public role
• Always the same default user roles for all apps
• Public pages without access errors

Screenshots If applicable, add screenshots to help explain your problem.

App Export form_test-export-1730188668723.tar.gz

Desktop (please complete the following information):

• OS: Linux
• Browser chrome & firefox

[linear[bot]]

BUDI-8790 Duplicate Public Access roles, Public pages: Session not authenticated

[ConorWebb96]

This PR here fixes this issue. It will be fixed in the next release of Budibase.

[SimonDoll]

Awesome, thanks a lot for the fast response! Can You estimate when the fix will be available @ConorWebb96?

[ConorWebb96]

In around 20-30 minutes, if I had to guess, it might be sooner. @SimonDoll