Hi Marcus
I'm trying to do as you explained here and have gotten as far as having my view created within the database. I can see my view as an option when I go to create a data storage from existing table.
Here's the issue:
I begin the process in CB of choosing my view corpview_3 to create a Data Storage from existing table and receive this warning:
Warning: You choose to use an existing table. Please be aware that if you save this data storage, ContentBuilder will add the following columns to that table if not existing: id, user_id, created, created_by, modified_user_id, modified, modified_by. If the column id already exists, please make sure it is of type integer and auto_increment. All columns will be added in the end.
When I click Save then I receive this error:
An error has occurred.
1347 'u487341956_dev2020.corpview_3' is not of type 'BASE TABLE'
I can see that a new Data Storage has been created and I can see my existing fields named
Then I publish that Data Storage and try to create a CB View based on that data storage...
Suddenly all my pages within my site throw this error: 1054 Unknown column 'r.id' in 'field list'
The requested page can't be found.
An error has occurred while processing your request.
You may not be able to visit this page because of:
an out-of-date bookmark/favorite
a mistyped address
a search engine that has an out-of-date listing for this site
you have no access to this page
Go to the Home Page
Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below.
1054 Unknown column 'r.id' in 'field list'
I was able to quickly restore functionality by deleting the new data storage from the table t905v_iriscontentbuilder_storages via PHPMyAdmin.