Hi,
after upgrading to Fabrik 3, the user element throws errors
Warning: Invalid argument supplied for foreach() in C:\xampp_old\htdocs\joomla25\plugins\fabrik_element\databasejoin\databasejoin.php on line 1226
When I unpublish the user element, the errors stop.
I tried to use fabrikdebug and learned that the SQL query was wrong.
list GetData:
SELECT SQL_CALC_FOUND_ROWS DISTINCT ... LEFT JOIN `#__users` AS `jos_users` ON `jos_users`.`id` = ...
instead of
SELECT SQL_CALC_FOUND_ROWS DISTINCT ... LEFT JOIN `jos_users` AS `jos_users` ON `jos_users`.`id` = ...
The prefix is configured properly in configuration.php.
Can the prefix be changed in the SQL query fabrik makes?
after upgrading to Fabrik 3, the user element throws errors
Warning: Invalid argument supplied for foreach() in C:\xampp_old\htdocs\joomla25\plugins\fabrik_element\databasejoin\databasejoin.php on line 1226
When I unpublish the user element, the errors stop.
I tried to use fabrikdebug and learned that the SQL query was wrong.
list GetData:
SELECT SQL_CALC_FOUND_ROWS DISTINCT ... LEFT JOIN `#__users` AS `jos_users` ON `jos_users`.`id` = ...
instead of
SELECT SQL_CALC_FOUND_ROWS DISTINCT ... LEFT JOIN `jos_users` AS `jos_users` ON `jos_users`.`id` = ...
The prefix is configured properly in configuration.php.
Can the prefix be changed in the SQL query fabrik makes?