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;
We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.
Topic Author
