Error userpermissionviewattributeaccesslist doesn't exist
Permalink 1 user found helpful
Hi
When I click on Userpermissions, I get the following errormessage:
An exception occurred while executing 'select permission from UserPermissionViewAttributeAccessList where paID = ? and peID = ?' with params ["4", "1"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname.userpermissionviewattributeaccesslist' doesn't exist
There is really no userpermissionviewattributeaccesslist in the db, only userpermissionviewattributeaccesslistcusom.
Any idea what is wrong? I use concrete 5.7.3.1
Regards
Matthias
When I click on Userpermissions, I get the following errormessage:
An exception occurred while executing 'select permission from UserPermissionViewAttributeAccessList where paID = ? and peID = ?' with params ["4", "1"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname.userpermissionviewattributeaccesslist' doesn't exist
There is really no userpermissionviewattributeaccesslist in the db, only userpermissionviewattributeaccesslistcusom.
Any idea what is wrong? I use concrete 5.7.3.1
Regards
Matthias
Do you have advanced permissions enabled by chance?
No I had no time to go that for. It is basically a fresh install and then updated to 5.7.5. he first thing I did however was install the migration tool from 5.6 which did not properly migrate some pages so I stopped in the process. But that should only migrate pages not permissions or tables.
I somehow fixed it by creating the table myself but I think that should not have been the right approach.
I somehow fixed it by creating the table myself but I think that should not have been the right approach.
Your right in that the migration tool should have worked right out the box. I think mentioning the problem you encountered to someone might help them fix that. There was a post on the forums announcing it at some point but I don't have the link off hand.
So in this case, making the table yourself was the right thing to do. Out the box, those tables are empty anyways, so adding them yourself was the way to go.
So in this case, making the table yourself was the right thing to do. Out the box, those tables are empty anyways, so adding them yourself was the way to go.
I updated from 5.7.3.1 to 5.7.5.9 and the table is also missing