1. Hugh (cheesegrits) here. Thank you for all the good wishes. My back surgery was a success, post-op recovery is going well, and I'm getting stronger and feeling better every day. I hope to be getting back in the saddle and working support again over the next few days.
  2. IMPORTANT NOTE - we have made some changes in our github branch naming. The 'master' branch no longer exists, and is now called 'joomla25' (which is Fabrik 3.0). The 'joomla3' branch (which is Fabrik 3.2) remains unchanged. We have also removed all the other testing branches which had accuulated over the last few years. I have posted a thread in the Community forum for 3.0 with some more information, feel free to as questions there.

Table Join not working with Fabrik 3.X

Discussion in 'Fabrik 3.x Testing' started by ritesh123, May 6, 2012.

  1. ritesh123 Member

    Level: Community
    I have a "table 1" with its primary key as "id"
    and "table 2" with foreign key as "table1_id"

    I have done table join like this

    left JOIN table2 ON table1.id = table2.table1_id

    On Edit i am not getting any joined details as the foreign key in table is not updated in table2 in database
  2. troester Well-Known Member

    Level: Standard
    In fabrik3 it's "lists". Did you add a join to the list "table1" in fabrik?
    Is the joined group set to repeatable?
    What is your Joomla and fabrik version?

    What are the fabrik element types (plungins) of id and table1_id? published? edit access?
    1 person likes this.
  3. ritesh123 Member

    Level: Community
    Hi

    I am using Joomla 2.5
    Fabrik 3.x ( Latest updated today from Github)

    Yes, joined group is set to repeatable

    All tables are list , i know. Since I am a old Fabrik user so designated list as tables.

    All the ids are published and editable.

    I am using "table1.id" as primary key which is having element as internalid which is integer(11)

    table2.table1_id as field which is a integer(11)

    Then also after saving the Records through Form it is not updating the foreign key table2.table1_id

    I have used Join condition

    left JOIN table2 ON table1.id = table2.table1_id

    "table2.table1_id" value should be equivalent to "table1.id"
  4. troester Well-Known Member

    Level: Standard
    It's weekends, even for Silver subscribers support is ...48h excluding weekend...

    It's working on my site without problem.

    Does table2 have a primary key?
    Check all your element settings in table1-[table2] group (id, table1_id)
    Enable fabrikdebug to check the query.
  5. rob Administrator

    Level: Community
    check the foreign key is published in the joined group
  6. bichu10 New Member

    Level: Community
    Fabrik 3. table join issue

    Same issue happend to me as well , using joomla 2.5.7 with fabrik 3.0.7.
    Join table FK not get updated with the PK value of Main table after form subission. Only main table updated. joint group's elements type changed to text as well.

    Any solution ???
  7. cheesegrits Support Gopher

    Level: Community
    Testing this now on a couple of my join torture test forms.

    -- hugh
  8. cheesegrits Support Gopher

    Level: Community
    I'm unable to replicate this.

    Can someone with this issue catch me on Skype ('cheesegrits') and get me logged in to their system, so I can do some hands on work.

    -- hugh
  9. bichu10 New Member

    Level: Community
    Hugh , thanks for your initiative . scenario probably help to replicate the same .
    i have two list ,Main and sub . each had its own PK with auto increment field which is [id] and on the sub table a id_ref field to which the table join from main to sub.
    Once after i setup the join , notice the following
    1. The join group's field type different from the orginal sub table
    2. Backend mySql main table appended with the fields of sub table .
    3. the form of main list appended with join group as it should be , however the PK value of main list not get populated to FK of the sub list.

    The issue 2: eventually gone off after i delete the appended fileds from mysql and delete the rejoin the lists.
    However it recreate the same fileds in mysql of main table as soon as the form submitted.
    Hopefully above gave a better picture of the issue.
    Am also uploading some screes as well.

    Attached Files:

    • 1.JPG
      1.JPG
      File size:
      74.3 KB
      Views:
      48
    • 2.JPG
      2.JPG
      File size:
      67.7 KB
      Views:
      55
    • 3.JPG
      3.JPG
      File size:
      74.1 KB
      Views:
      43
  10. bichu10 New Member

    Level: Community
    Fabrik 3. table join issue : Solved

    Hugh , Just an update . The Issues 2 and 3 managed to resolve by clearing the cache . the steps as follows
    1. Delete the existing join
    2. delete the mysql Main table appended fields
    3. cleared the browser cache
    4. restart the Apache and mySql ]
    5.recreate the join
    May not required all the steps , but after this steps i managed to make the join works . However my point 1 is still an issue as the field type of the join group reset back to text field as my previous uploaded screen.

    Any direction to TS path.

Share This Page