Databasejoin join el can't join to users table anymore!

[koolaid2]

The Databasejoin join element can't join to users table anymore.


I just get "can find" this value when trying to join the databasejoin element to the Joomla users table.

I nedd to be able to select user from my record.
Looks like the join to taeble is missing from the sql!

 

[koolaid2]

Ok, this is working again. It's releated to the fact that sometimes a Join reference is left in the fabrik join table after a user element has been deleted.

I'm not shure if the join references are left in the fabrik table always or exactly when this happen. But I have seen leftovers in the Fabrik join table many times and deleting them often solves problems and I'm pretty shure it was the problem here.

"making a new fabrik admin-table whit the fabrik_joins as data, then changing all the element in the fabik_joins table to be correct databasejoins elements. Then it's easy to see whitch join that has an element/ table or not."