TEMA:

Hello,

I have been working on setting up a content builder environment. I have built the data sources and created a view, but now I cannot enter the front of the site with a 1054 error (see attached). I cannot get into the Content Builder component in the back end either. How can I untangle this?

Many thanks

Peter

Hi,

does the same happen with new data storages + views?

Please have a look into joomla database and check if table:
#_contentbuilder_records has column r.id

Have you changed the name of the storage or something before the error occured first?

Basically, if your table has an ID field, and you name it as 'r.id' instead of 'id', contenbuilder will still think the field name is 'id' at some point. That caused the 1054 error.

Regards,
Tihana

Hi Tihana,

I cannot get into the component to create a new view, and I did not change the name of the data storage before the error happened.

There are no records in #_contentbuilder_records.

shall I delete my id fields?

Thanks

Peter

Hi,

please try to reinstall content builder?

Regards,
Tihana

still getting the error

Hi,

could I access to your page, that I can find from where this error comes from?

If yes, please send me login information and backend link.

Use this tag:
Regards,
Tihana