40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

Account form not showing

This topic contains 6 replies, has 2 voices, and was last updated by  Anthony Booth 7 years ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: , ,

  • Author
    Posts
  • October 31, 2017 at 6:09 pm #910
    October 31, 2017 at 6:20 pm #911

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Anthony,

    Can you try checking the setting of the fields in the form builder, make sure they are active and not set to private.

    If you still have problems please post wp-admin details in a private reply (only staff can see) and we will take a look.

    Thanks,

    Stiofan

    October 31, 2017 at 6:29 pm #912

    Anthony Booth
    Free User
    Post count: 7

    Hello Stiofan,

    I have found the issue for some reason your $wpdb-prepare statement didn’t like the array on line 79 and 81 in /includes/helpers/forms.php

    I took out the array and replaced it with comma separated values “‘account’, $extra_where” and now it works:

    $fields = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM ” . $table_name . ” WHERE form_type = ‘%s’ AND is_active = ‘1’ AND is_register_only_field = ‘0’ ” . $extra_where . ” ORDER BY sort_order ASC”, ‘account’, $extra_where ) );

    October 31, 2017 at 6:33 pm #913

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Anthony,

    There was a change in WP 4.8.3 to the prepare function, i will look into it now to see if its something we need to change at out end.

    Thanks for the feedback.

    Stiofan

    October 31, 2017 at 6:50 pm #914

    Anthony Booth
    Free User
    Post count: 7

    Hello Stiofan,

    I think your problem is with the placeholder I always use %f %d or %s I have now amended it to the following which works fine:

    $fields = $wpdb->get_results($wpdb->prepare(“SELECT * FROM ” . $table_name . ” WHERE form_type = %s AND is_active = ‘1’ AND for_admin_use != ‘1’ AND is_register_only_field = ‘0’ %s ORDER BY sort_order ASC”, array(‘account’, $extra_where)));

    October 31, 2017 at 7:05 pm #915

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Anthony,

    Thanks for bringing this to our attention, you will be happy to learn i have released an update to resolve the issue.

    Thanks again!

    Stiofan 🙂

    October 31, 2017 at 7:12 pm #916

    Anthony Booth
    Free User
    Post count: 7

    Hello Stiofan,

    Thank you for your quick response.

    Anthony

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket