Racmitch
Member
Hi Guys,
Trying to set up a database join in the new version of fabrik. I have access to the old system and fabrik configuration i used before to make this work, however after adding the same statements and such I am getting this error
"
1054
Unknown column 'goal_planning_sheets.userid' in 'where clause' SQL=SELECT DISTINCT(`goal_planning_sheets`.`goal`) AS value, `goal` AS text FROM `goal_planning_sheets` AS `goal_planning_sheets` WHERE `goal_planning_sheets`.userid = '815' ORDER BY text ASC"
I configured the dbase join with the proper table, connection, value and label and it does work, showing the information from the specific table i want to join to, the issue/error occurs when I try to add the old fabrik "where" statement "where {thistable}.userid = '{$my->id}' " to the "joins where and/ororder by statement (SQL) so that a logged in user can only see their input to the table I'm trying to join to.
did something change, or what am I doing wrong in that new version that did work in the older versions of Fabrik?
Trying to set up a database join in the new version of fabrik. I have access to the old system and fabrik configuration i used before to make this work, however after adding the same statements and such I am getting this error
"
1054
Unknown column 'goal_planning_sheets.userid' in 'where clause' SQL=SELECT DISTINCT(`goal_planning_sheets`.`goal`) AS value, `goal` AS text FROM `goal_planning_sheets` AS `goal_planning_sheets` WHERE `goal_planning_sheets`.userid = '815' ORDER BY text ASC"
I configured the dbase join with the proper table, connection, value and label and it does work, showing the information from the specific table i want to join to, the issue/error occurs when I try to add the old fabrik "where" statement "where {thistable}.userid = '{$my->id}' " to the "joins where and/ororder by statement (SQL) so that a logged in user can only see their input to the table I'm trying to join to.
did something change, or what am I doing wrong in that new version that did work in the older versions of Fabrik?