Parent/child Relationship issue

  • Resolved trebair

    (@trebair)


    4 years, 8 months ago

    Hi,
    First I must say this is a great plugin and simple to understand. I seem to be having an issue with the parent child pages as no data is showing up from the child entries.

    I have a (Caldera)form on my site, which when sent, sends it’s content to 2+ tables, created with your plugin. this works great and I can see the data in the table using explorer. Field ‘u_donor’ is the wordpress user ID which is passed to all required tables and an index of ‘u_donor’ is made of the column.

    A parent/child page has been created with the 1:n relationship but no data is showing in the tabs? It seems to be looking at the ID key column for the relationship instead of the ‘u_donor’

    screenshots here… https://rebair.co.uk/wpdata/

    I’m stuck, any help would be great.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi,

    Is this a 1:n relationship? Or a 1:1?

    Can you export your data project and tables (if allowed with some test data) and send it to me in private? You can use the contactform on the plugin website (wpdataaccess.com) to send me a message. I’ll reply with my email address.

    Thanks,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Tony,

    Thank you for the export! I was able to import your scripts and reproduce the error.

    You’re not doing anything wrong, the plugin just doesn’t handle your relationship correctly! Amazing no one ever reported this bug before. I have not run into this problem before myself as well. I think most people are using the primary key of the parent table in a relationship, which works fine. But the plugin does not handle a non primary key column on the parent table correctly.

    I’m working on this problem, but it is taking more time than I expected. For now, I just wanted to let you know I’m working on it. I’ll drop a message if it is fixed.

    Thank you for reporting this bug! You’re helping to improve the stability and quality of the plugin I appreciate that! ??

    Best regards,
    Peter

    Thread Starter trebair

    (@trebair)

    Hi Peter,
    Thank you for looking at this, I was convinced I was doing something obviously wrong and just couldn’t see it.

    Regards,
    Tony

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Tony,

    Here is a link to a patch of version 3.0.2 which allows to create relationships on non-primary key columns:
    https://wpdataaccess.com/wp-content/uploads/2020/03/wp-data-access.zip

    You need to delete your current installation of the plugin first and use the attached zip file to reinstall. Please follow these steps before you delete the plugin to make sure you’re not losing your work:
    – Click on menu Setttings
    – Sub menu WP Data Access
    – Tab Uninstall
    – Uncheck both checkboxes
    – Save your settings

    After that you can delete the plugin and use the patch to reinstall. You can safely update to the next version when it becomes available.

    Thank you for being so co-operative! ??

    Best regards,
    Peter

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Parent/child Relationship issue’ is closed to new replies.