Joomla Plugin results in 1054 Unknown column ----- in 'order clause'

When I add the Joomla Plugin function to a connection, then save and preview I get the following error:
​
1054 Unknown column 'capmarr.Groom:Groom' in 'order clause'
​
Previously this connection was working. I then delete the joomla plugin and save but the error persists. I did try clearing the cache but that did not seem to help?
​
not sure what I am doing wrong here?
​
FOLLOWUP:
If I delete the order field Groom:Groom from the list function the connection begins working again but when I re-add the order field the connection once again throws the error. All of this happens with the joomla plugin removed.
​
Admiral

The error occurs when you "view" the connection ? if yes then please check your "Read data" settings ?

Yes, when I view the connection. The connection worked correctly until I added the joomla plugin. the read data settings are unchanged from before I added the plugin to after I added the plugin.

So it looks like the title of the column in the list view is no longer valid. When I changed capmarr.groom:groom to capmarr.groom the connection works again. This is an easy fix for me, though I don't know why adding the joomla plugin sets this off?
​
Also, could you provide context in how to implement the joomla plugin? for example using phocagallery I need to call {Phocagallery view= some text} from database field capmarr.Pimage
​
Thanks so much!
​
Admiral

I'm not sure why the problem occurred, do you have a screenshot of that title setting ?
​
You need to call the function in your event: {fn:joomla_plugin_name} and have the text with the plugin shortcode in the function settings, so just add {Phocagallery view= some text} there.
​
Best regards

I place the function call in my event {fn:joomla_plugin_phoca} and then place {Phocagallery view= some text} in the content of the plugin function and the joomla plugin is working! However the"{Phocagallery view= some text}" is unique to each record so I really need a way to call the field data from the record.
​
​
Thanks!
Admiral

I do not understand, please explain how its unique to each record ?

Sure, sorry I am not being very clear. Each record has a field called 'PImage' with the plugin code for phoca gallery. For example {phocagallery view=category|categoryid=44|imageid=863} where imageid is a specific image . The code in the field record is unique to that record. In chornoforms 4 the form just called the field name, for example {PImage} and it retrieved the phoca code from the field it displayed perfectly.
​
With CCv6 I put {fn:joomla_plugin_name} in the event and then I put the phocagallery code for a specific image in the content of the function and it displays perfectly. However, it displays the same image for EVERY record. What I am looking for is a way to have the phocagallery code pulled from the record instead of the content portion of the function.

{phocagallery view=category|categoryid=44|imageid={var:table_view_name.model.row.PImage}} ? I doubt it will work but give it a try eh?

Thanks healyhatman. Unfortunately the entire string between the brackets is in the field and I am not able to break it up. but is there a way to use what you suggest to call up the entire phocagallery view string rather than just the image id# from the table?
​
-Admiral

Hi Admiral,
​
Please give an example of 2 records values of that phoca string ?
​
Best regards

Sure:
{phocagallery view=category|categoryid=44|imageid=867|detail=5|displayname=0}
{phocagallery view=category|categoryid=42|imageid=345|detail=5|displayname=0}
​
Where categoryid and or imageid may change. Regardless, the entire phoca string is in the field 'PImage' This includes the curley braces {}
​
Thanks
-Admiral

Good, so if you place the field value shortcode in the Joomla Plugins content box then it should work, where do you call the plugin ?

I am not sure exactly what you are asking, I placed {fn:joomla_plugin_phoca} in the view EVENT. Perhaps I don't know how/what to write as the field value shortcode?

So, thinking about what you just asked, I added {var:read_capbirthdetail.sometable.PImage} and it does then display the phoca code correctly and I am able to see the correct image for the record! Is this correct?!
​
Admiral