User plugin errors after migrating to Fabrik 3

[lulz]

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?

 

[troester]

Does your fabrik3 database have the same prefix as your fabrik2 database?
Did you try to re-save
- your fabrik connection (check all parameters)
- your user element

 

[lulz]

Yes, it does have the same prefix.
I also tried to re-save the fabrik connection and the user element.
Still the same error.

 

[troester]

How did you migrate?

(#_users in the query is ok in Fabrik3 )

 

[lulz]

I upgraded according to the guide on wiki: jUpgrade + Upgrade from 2.1.

 

[lulz]

Right, it turned out something was wrong with the associated group after the migration. Resaving the group solved the problem.