1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

Databasejoin element return error on list & detail view

Discussion in 'Community' started by Aurore, May 17, 2019.

  1. Aurore

    Aurore New Member

    Level: Community
    Hello !
    I need help, i might miss something !
    I try to create a databasejoin element connecting to another database (which is entered in Connection tab)
    My form is on DB A, my databasejoin connect to DB B and choose my regions table.

    Everything working great on form : The databasejoin's dropdown showing me every regions.

    But on list & details view, i got a 500 and a 1146 error, even if there is no raw on the table.

    I just want to be sure : Can i create a databasejoin element to another database ?
    If not, do you have an idea of how can i get those values ?

    I tried in case to create List's Join and related data but i didn't made it work.
    Thanks in advance !
  2. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    We don't support cross database joins. So your joined table has to be on the same database as your form.

    The only workaround for this would be to create a MySQL view on your form's database, which does something like ...

    DEFINE VIEW regions AS SELECT * FROM dbB.regions

    ... so you essentially have a copy of the regions table on dbA. It would be "read only", so you couldn't add rows to it, but would work as a simple lookup table.

    -- hugh

Share This Page