Issue Creating Scopes for New Roles (since 2.0.6)

Hello,

Since version 2.0.6, the Role interface has been updated. However, I’m encountering a “Bad server response” error whenever I try to create scopes for new roles.

Checking the browser console, I see the following error:

Bad server response: An exception occurred while executing a query: 
SQLSTATE[42703]: Undefined column: 7 ERROR: column t1.create_attribute_value_action does not exist
LINE 1: ...e_action, t1.stream_action AS atro_stream_action, t1.create_...

Has anyone else faced this issue or found a fix?

Thank you very much in advance.

Best regards,
Elio

Hello,

Sorry for the late response. Were you able to solve your issue?

Hello,

Thank you, not yet unfortunately.

I got this error both with the docker installation and the normal installation on debian with postgre.

Note that in both case I started from the last 1.XX version so maybe I should try a fresh install from 2.X.X directly if I don’t manage to find the issue.

I also tried to run the migration script from gitlab and run sql diff but It didn’t help aswell.

There’s no emergency as I’m just using 2.0.5 which work perfectly fine.

Best regards

Edwin

Hello,

I tried to reproduce your case and updated from version 1.13 to 2.0.6, but I don’t have this error. New scope was successfully added to the Role.

Please, try updating to the latest Core version (currently it’s 2.0.19), and the problem may disappear. If not, I recommend referring to section Troubleshooting, where you can find solutions to common problems in AtroCore.