Forums

I have created a MySQL view by joining a couple of tables and used as CC data source. The backend works fine and shows data accordingly. But the frontend generates a corrupted HTML. The HTML includes only Header/Title and Header I defined in Connection View Settings section. That’s it, no Body data, even no Joomla template.

The funny thing is when I make the frontend available for public users, it works. But after logging in, I see a corrupted code again.

I have Community Builder installed. This might be the reason?

Can someone help me?

Hi nori,

Sorry but our mind-reading doesn't work this late at night. The only thing I can tell you is that your code is broken.

ChronoConnectivity only usually supports simple single table queries so this coudl be the problem. But you say it works OK for guests so it sound more like either a permission problem or something wrong with code using the User Object?

If you post the code you are using we might be able to say more.

Bob

> or something wrong with code using the User Object?

I didn't write any code.
The site is still under beta operation, so I will uninstall Community Builder and see what happens.

I found out that frontend edit/delete permissions cause the problem. After removing all these permissions, the site generates proper pages.

Now I have a new problem. I wanted to do the suggestion in the old topics
http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=12&t=11033&p=33478&hilit=multiple+tables#p33969
But I cannot use {edit_record} without the edit permission to call my target ChronoForm. Maybe the spec has been changed since then.

So I’m thinking to call the Form directory by href links. I would like to know how I can call the populated ChronoForm and then how I can update the database. I have primary key data of the target table in my original ChronoConnectivity result table.

Thanks.

Hi nori,

I add the cf-id to the url used to call the ChronoForm, then in the Form HTL check the value from the URL, load the appropriate date and set the values in the form.

Bob