Hello
I am on Joomla 3.8.6. I installed php-rgraph.
When I use the sql request below for bar graph:
"SELECT i.catid catid_item, u.name name_user FROM lths2e_flexicontent_items_tmp i INNER JOIN lths2e_users u ON u.id = i.created_by"
the chart don't display and I have this message below:
*** php-rgraph - invalid/missing parameter:
- SQL-statement not allowed: SELECT i.catid catid_item, u.name name_user FROM lths2e_flexicontent_items_tmp i INNER JOIN lths2e_users u ON u.id = i.created_by
However if I use the request sql directly with phpmyadmin I don't have mistake.
Why ????
with next release i'll add option to allow for access of this kind of tablename. With current release you must edit code of ../plugins/content/rgraph/helper.php and put this code
if (stripos($check, "_users") != false)
$error_string .= JText::_('SQL_NOTALLOWED') . $check;