wpFluent QueryBuilder fieds not inserted or updated

  • Resolved traxhat

    (@traxhat)


    4 months, 1 week ago

    I use fluent form in wordpress and want to update or insert values in the table fluentform_entry_details

    I can see changes in database but if I refresh my form on wordpress nothing changed

    What did I miss ?

    Thank you for your help

    I tried things like

    wpFluent()->table('fluentform_entry_details')
    		->where('form_id', registrationFormId)
    		->where('submission_id', $submissionId)
    		->where('field_name', 'member_card_id')
    		->update(['field_value' => $cardId]);
    			
    			
    do_action('fluentform/entry_updated', $entryId, $data);

    OR

    $data = [
    	'form_id'        => $registrationFormId,
    	'field_name' => 'member_card_id',
    	'submission_id' => $submissionId,
    	'field_value' => $cardId
    	];

    $entryId = wpFluent()->table('fluentform_entry_details')->insertGetId($data);
    do_action('fluentform/entry_updated', $entryId, $data);

    On a select on database my field is updated or inserted but on wordpress, on the entriy of my form it is not

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Amimul Ihsan Mahdi

    (@amimulihsanmahdi)

    Hello there,

    In your query, can you please update the table name with prefixes? If your WordPress database has a prefix of wp, you can try using the below code:

    wpFluent()->table('wp_fluentform_entry_details')
    		->where('form_id', registrationFormId)
    		->where('submission_id', $submissionId)
    		->where('field_name', 'member_card_id')
    		->update(['field_value' => $cardId]);

    Hopefully, this will resolve the issue.

    Thank you

    Thread Starter traxhat

    (@traxhat)

    Hi Amimul,

    The prefix is automatically added and the table is well updated, I can see that if I make a manual select but Fields aren’t updated on the form by interface : if I go on wordpress / Fluentform / Entries

    Plugin Support Amimul Ihsan Mahdi

    (@amimulihsanmahdi)

    Hello there,

    Yes, you do not need to add the prefix. Apologies for the inconvenience. To update an entry as shown in the screenshot you need to update the data on two tables. I have listed them below:

    1. fluentform_entry_details
    2. fluentform_submissions

    If you update the data on both table, the updated data will be listed in the Fluent Forms entries.

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.