CF7DB error 1064

  • Resolved iontulburedev

    (@iontulburedev)


    1 year, 4 months ago

    Error message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'm based in Europe";}s:15:"gdpr-accept-elp";s:1:"1";s:5:"track";s:0:"";s:10:"u...' at line 2

    Component: Plugin: contact-form-cfdb7

    Caller: CFDB7_Form_Details->form_details_page()

    Query: UPDATE?wp_db7_forms
    SET?form_value = 'a:21:{s:12:"cfdb7_status";s:4:"read";s:14:"first-name-elp";s:4:"test";s:13:"last-name-elp";s:4:"test";s:9:"email-elp";s:13:"[email protected]";s:9:"phone-elp";s:8:"11111111";s:16:"organization-elp";s:9:"Amogus";s:10:"region-elp";a:1:{i:0;s:19:"I'm based in Europe";}s:15:"gdpr-accept-elp";s:1:"1";s:5:"track";s:0:"";s:10:"utm_source";s:0:"";s:10:"utm_medium";s:0:"";s:12:"utm_campaign";s:0:"";s:11:"utm_content";s:0:"";s:8:"utm_term";s:0:"";s:7:"persona";s:0:"";s:3:"sdr";s:0:"";s:7:"company";s:0:"";s:7:"product";s:0:"";s:5:"gclid";s:0:"";s:6:"utm_id";s:0:"";s:12:"containerURL";s:0:"";}'
    WHERE?form_id = '14'
    LIMIT?1

    PHP: 8.1.20?

    DB : 10.6.14-MariaDB

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Arshid

    (@arshidkv12)

    Please share complete shortcodes.

    Example [text your-name]

    Thread Starter iontulburedev

    (@iontulburedev)

    @arshidkv12 This error is generated at wp-admin/admin.php?page=cfdb7-list.php&fid=XXX&ufid=XXX – when you click on a form submission’s full detail page in admin.

    I don’t use any shortcodes.

    Plugin Author Arshid

    (@arshidkv12)

    I want create your form clone in my localhost.

    Please give me contact form 7 complete shortcodes.

    Example: [text your-name]

    Thread Starter iontulburedev

    (@iontulburedev)

    @arshidkv12 Here is a form body example: 

    <p class="fs19 uppercase text-center bold">Use new data and venue insights to learn about customization request processes</p><br>

<div class="form-group h-fgf">

    [text* first-name-elp class:form-control default:get placeholder "First Name*" ]

</div>

<div class="form-group h-fgl">

    [text* last-name-elp class:form-control  default:get placeholder "Last Name*"]

</div>

<div class="form-group form-group-last h-fge">

    [email* email-elp class:form-control  default:get placeholder "Work Email*"]

</div>

<div class="form-group h-fgp">

    [text* phone-elp class:form-control class:h-fcp default:get placeholder "Phone number*" ]

</div>

<div class="form-group h-fgo">

    [text* organization-elp class:form-control class:h-fco default:get placeholder "Organization*" ]

</div>

<div class="form-group h-fgo">

    [select* region-elp "I'm based in US" "I'm based in EU"]

</div>

<div class="form-group h-fgp">

    <div class="gdpr-accept">

        [acceptance gdpr-accept-elp] I hereby consent to the collection[/acceptance]

    </div>

</div>

[text track class:d-none default:get]

[text utm_source class:d-none default:get]

[text utm_medium class:d-none default:get]

[text utm_campaign class:d-none default:get]

[text utm_content class:d-none default:get]

[text utm_term class:d-none default:get]

[text persona default:get class:d-none]

[text sdr default:get class:d-none]

[text company default:get class:d-none]

[text product default:get class:d-none]

[text gclid default:get class:d-none]

[text utm_id default:get class:d-none]

<div class="form-group form-group-submit send-btn">

    [submit class:btn class:btn-orange class:btn-large "Download"]

</div>
    Plugin Author Arshid

    (@arshidkv12)

    Update plugin. Then submit new data and check it.

    Thread Starter iontulburedev

    (@iontulburedev)

    @arshidkv12 Thanks, i updated the plugin. Upon checking form submission details Query Monitor doesn’t show DB related errors.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘CF7DB error 1064’ is closed to new replies.