Widget Parse Error
- David Boggs
-
Topic Author
- Offline
- New Member
-
- Posts: 16
Thank You fixed that issue.
Please Log in or Create an account to join the conversation.
- Daniel
-
- Offline
- Administrator
-
Hello,
The issue has been fixed in the latest version i.e. 2.9.18. Please download and install it on your website.
Thanks
Daniel
Please Log in or Create an account to join the conversation.
- David Boggs
-
Topic Author
- Offline
- New Member
-
- Posts: 16
You got to be kidding me, never going to happen with any of my systems. This is a simple count against a known Joomla database table.
Please Log in or Create an account to join the conversation.
- Daniel
-
- Offline
- Administrator
-
Hello,
Please share your backend & FTP login credentials via Contact us form, We'll look into it.
Thanks
Daniel
Please Log in or Create an account to join the conversation.
- David Boggs
-
Topic Author
- Offline
- New Member
-
- Posts: 16
Yes did that still get a parse error.
select count(group_id) AS BP from #__user_usergroup_map
The {BP} value is in the editor:
<div class="t_user">
<p><span class="t_user_pic vdata_img">Image</span><span class="hex_value">{BP}</span></p>
<h3>Total BP</h3>
</div>
I have attempted it with and without the {} around BP. I have also done the same with group_id.
Please Log in or Create an account to join the conversation.
- Daniel
-
- Offline
- Administrator
-
Hello,
You don't need to use {} if you are writing the custom query. That's for predefined profiles. You can write the query as you write it anywhere else e.g. select count(group_id) AS BP from #__user_usergroup_map
Thanks
Daniel
Please Log in or Create an account to join the conversation.
- David Boggs
-
Topic Author
- Offline
- New Member
-
- Posts: 16
Really wondering, I am attempting to add a simple widget, one that does a simple count of group_id in the #__user_group_map table. It saves OK but I get a parse error when returning to the dashboard. I have tried the belong sql statements.
select count(group_id) AS BP from {tablename #__user_usergroup_map}
select count(group_id) AS BP from __user_usergroup_map
select count(group_id) AS BP from {tablename #__user_usergroup_map} where group_id="14"
select count(group_id) AS BP from {tablename #__user_usergroup_map} where group_id='14'
get_object_vars() expects parameter 1 to be object, array given in /opt/rh/httpd24/root/var/www/html/joomdle/administrator/components/com_vdata/views/vdata/tmpl/default.php on line 534
image{BP}
Please Log in or Create an account to join the conversation.