Error 500

[robertbrandes]

i am getting an error 500 with the message

COM_FABRIK_ERR_JOIN_TO_OTHER_DB

after upgrading Fabrik to 3.0.6.3

Help

 

[rob]

I would check that your connection details are the same as your Joomla db config settings

 

[robertbrandes]

i found it. it was that the connection record was #2 and only #1 works. i think you should consider that a but to fix.

 

[cheesegrits]

The assumption that the default site database is on connection ID 1 is fairly deeply ingrained in Fabrik, not something we are likely to fix. In fact, I'm not sure it's something we can really "fix". For various reasons, we have to make that assumption. Unless we add Yet Another Option, to allow you to designate which connection is the site default, but then we'd still have that issue with sites installed prior to adding such an option, as we'd have to default #1 to be the site connection.

-- hugh

 

[robertbrandes]

Should remove the ability to have a different connection number

 

[troester]

You can have multiple connections pointing to different databases (even external ones), but the connection #1 has to point to the Joomla database.

But you can't use multiple connections in one list/form, i.e.
joining fabrik lists which are using different connections or
use dbjoin elements pointing to a list with a different connection or
use user elements (=databasejoin to a Joomla database table) in a list with an other connections

 

[robertbrandes]

if that is the case, number 1 should not be an option. it should be automatic and not be changeable/option

 

[cheesegrits]

On a typical install, #1 is automatically the site database. It's clearly marked as "Site Database". We can't make it unchangeable, for a variety of reasons.

What I have just done is to make the language of the notice you get when you edit #1, to make it clearer that it MUST match your default J! site connection details.

-- hugh

 

[robertbrandes]

That sounds Good, Thanks