Unknown column 'hr5i3_fb_options.name' in 'field list'

[RobertG]

Hi,

I'm using a table "hr5i3_fb_options" to provide a list of options, in a "stay options" group/tab (databasejoin element). The table contains a column "name". All works fine in that tab.
The "stay option" group is repeatable.

Now I want to provide in the "stay" group/tab of my form another list from the same table some selected rows based on a "transfer" column of the table, using another databasejoin element and a where selection.
I don't want that this list will be repeatable but unique.

As soon I publish the element, I get an error (Unknown column 'hr5i3_fb_options.name' in 'field list') and don't understand what is my mistake.

Could you help me? Thanks!

 

[troester]

At least when you use multiple dbjoin elements pointing to the same lookup table you must use
{thistable}.your-column (literally {thistable}) in Data-where and Concat etc. because then you need table aliases which are created automatically by Fabrik.
Best is to use it always.

http://fabrikar.com/forums/index.php?wiki/database-join-element/#data-where

 

[RobertG]

Thanks troester, I will try to remember.