Database Error with Copy
-
Hello,
I have updated to 4.2.2 and when I try Copying a form (like I have in the past)
I am getting a blank form and my error log has the following:
[24-Jun-2015 13:26:04 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'text/javascript'>if (typeof(ecfconfig) == 'undefined'){var ecfconfig={};}ecfconf' at line 1 for query UPDATE wp_easycontactforms_customforms SET HTML = '<script type='text/javascript'>if (typeof(ecfconfig) == 'undefined'){var ecfconfig={};}ecfconfig[2]={};ecfconfig[2].fadeDelay='100';ecfconfig[2].messageDelay='100';var ufobaseurl = 'https://blog.woodardcurran.com/wp-admin/admin-ajax.php';if (typeof(ufoFormsConfig) == 'undefined') {var ufoFormsConfig = {};ufoFormsConfig.submits = [];ufoFormsConfig.resets = [];ufoFormsConfig.validations = [];}ufoFormsConfig.phonenumberre = /^(\+{0,1}\d{1,2})*\s*(\(?\d{3}\)?\s*)*\d{3}(-{0,1}|\s{0,1})\d{2}(-{0,1}|\s{0,1})\d{2}$/;</script><link href='https://blog.woodardcurran.com/wp-content/plugins/easy-contact-forms/forms/styles/easyform/css/std.css?ver=1.4.5' rel='stylesheet' type='text/css'/><div class='ufo-form' style='width:266px' id='ufo-form-id-2'><noscript><form method='post'><input type='hidden' name='cf-no-script' value='1'/></noscript><input type='hidden' value='ufo-form-id-2' name='hidden-2' id='ufo-form-hidden-2'/><input type='hidden' value='{__pagename}' name='ufo-form-pagename' id='ufo-form-pagename'/>{preview}<input type='hidden' value='{ufosignature}' name='ufo-sign' id='ufo-sign'/><div></div><div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-627' style='margin-top:2px;{display-627}'><div class='ufo-cell-627-2-row' id='ufo-cell-627-2'><span class='ufo-cell-center' id='ufo-cell-627-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","default"],"focus":["default"]},"Required":true,"Validate":true,"RequiredMessage":"Your first name is required","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"First Name","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-627","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-627' value='{id-627}' name='id-627' /></span><span class='ufo-cell-right' id='ufo-cell-627-2-right'><div id='ufo-field-id-627-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-647' style='margin-top:2px;{display-647}'><div class='ufo-cell-647-2-row' id='ufo-cell-647-2'><span class='ufo-cell-center' id='ufo-cell-647-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","minmax","default"],"focus":["default"]},"Required":true,"Validate":true,"RequiredMessage":"Your last name is required","AbsolutePosition":true,"RequiredMessagePosition":"right","min":"2","max":"45","DefaultValue":"Last Name","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-647","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-647' value='{id-647}' name='id-647' /></span><span class='ufo-cell-right' id='ufo-cell-647-2-right'><div id='ufo-field-id-647-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-5 ufo-customform-row ufo-row-625' style='margin-top:2px;{display-625}'><div class='ufo-cell-625-2-row' id='ufo-cell-625-2'><span class='ufo-cell-center' id='ufo-cell-625-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","default","email"],"focus":["default"]},"Required":true,"Validate":true,"RequiredMessage":"Please enter you email","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"Your email","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-625","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-625' value='{id-625}' name='id-625' /></span><span class='ufo-cell-right' id='ufo-cell-625-2-right'><div id='ufo-field-id-625-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-680' style='margin-top:2px;{display-680}'><div class='ufo-cell-680-2-row' id='ufo-cell-680-2'><span class='ufo-cell-center' id='ufo-cell-680-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","default"],"focus":["default"]},"Required":true,"Validate":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"Phone Number","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-680","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-680' value='{id-680}' name='id-680' /></span><span class='ufo-cell-right' id='ufo-cell-680-2-right'><div id='ufo-field-id-680-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-677' style='margin-top:2px;{display-677}'><div class='ufo-cell-677-2-row' id='ufo-cell-677-2'><span class='ufo-cell-center' id='ufo-cell-677-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","default"],"focus":["default"]},"Required":true,"RequiredMessage":"Company Name is required","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"Company Name","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-677","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-677' value='{id-677}' name='id-677' /></span><span class='ufo-cell-right' id='ufo-cell-677-2-right'><div id='ufo-field-id-677-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-678' style='margin-top:2px;{display-678}'><div class='ufo-cell-678-2-row' id='ufo-cell-678-2'><span class='ufo-cell-center' id='ufo-cell-678-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["default"],"focus":["default"]},"Validate":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"Website URL","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-678","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-678' value='{id-678}' name='id-678' /></span><span class='ufo-cell-right' id='ufo-cell-678-2-right'><div id='ufo-field-id-678-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-6 ufo-customform-row ufo-row-630' style='margin-top:2px;{display-630}'><div class='ufo-cell-630-2-row' id='ufo-cell-630-2'><span class='ufo-cell-center' id='ufo-cell-630-2-center'><script type='text/javascript'>var c = {};c.id = 'ufo-field-id-630';c.form = 'ufo-form-id-2';c.Label = 'Submit >';ufoFormsConfig.submits.push(c);</script><span id='ufo-field-id-630-span'><noscript><button type='submit' id='ufo-field-id-630' name='id-630' >Submit ></button></noscript></span></span></div></div></div><div id='ufo-form-id-2-message'></div><noscript></form></noscript></div>', ShortCode = '[easy_contact_forms fid=2]' WHERE id = '2' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wp-bold110/page-custom.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, easycontactforms_formentrypoint, EasyContactFormsCustomForms::getForm, EasyContactFormsBase->save, EasyContactFormsCustomForms->update, EasyContactFormsCustomForms->updateTemplate, EasyContactFormsDB->update, EasyContactFormsDB->query [24-Jun-2015 13:26:31 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 're now on the path to understanding background conditions, defining them for you' at line 1 for query UPDATE wp_easycontactforms_customforms SET id = '2', Description = 'River Runs Through It Whitepaper', NotificationSubject = 'New download request received (Local Conditions)', SendFrom = 'Woodard & Curran', SendConfirmation = '1', ConfirmationSubject = 'Thanks for downloading our free whitepaper!', ConfirmationText = '<p>Hey {627.FirstName},</p> <p>Thanks for downloading our free whitepaper! If you find this kind of thing useful, you can subscribe to our blog via email, add us to your <a href="https://blog.woodardcurran.com/feed/" target="_blank">RSS</a> reader of choice, or <a href="https://visitor.r20.constantcontact.com/d.jsp?llr=juzrcxcab&p=oi&m=1102433543817">join our mailing list</a>.</p> <p>If you have any questions about the whitepaper, please let us know!</p> <p>- Woodard & Curran</p>', Redirect = '0', RedirectURL = 'https://blog.woodardcurran.com/download-thank-you/', ShortCode = '[easy_contact_forms fid=2]', Template = '0', ObjectOwner = '225', SubmissionSuccessText = '<p>Thank you for downloading our free whitepaper! </p> <p>You're now on the path to understanding background conditions, defining them for your site, and determining how they impact your project.</p> <p>Click the button below to begin the PDF download.</p> <a class="button" title="Download" href="https://blog.woodardcurran.com/wp-content/uploads/A_River-_Runs_Through_It_Whitepaper.pdf" target="_blank">Download ></a>', HTML = '<script type='text/javascript'>if (typeof(ecfconfig) == 'undefined'){var ecfconfig={};}ecfconfig[2]={};ecfconfig[2].fadeDelay='100';ecfconfig[2].messageDelay='100';var ufobaseurl = 'https://blog.woodardcurran.com/wp-admin/admin-ajax.php';if (typeof(ufoFormsConfig) == 'undefined') {var ufoFormsConfig = {};ufoFormsConfig.submits = [];ufoFormsConfig.resets = [];ufoFormsConfig.validations = [];}ufoFormsConfig.phonenumberre = /^(\+{0,1}\d{1,2})*\s*(\(?\d{3}\)?\s*)*\d{3}(-{0,1}|\s{0,1})\d{2}(-{0,1}|\s{0,1})\d{2}$/;</script><link href='https://blog.woodardcurran.com/wp-content/plugins/easy-contact-forms/forms/styles/easyform/css/std.css?ver=1.4.5' rel='stylesheet' type='text/css'/><div class='ufo-form' style='width:266px' id='ufo-form-id-2'><noscript><form method='post'><input type='hidden' name='cf-no-script' value='1'/></noscript><input type='hidden' value='ufo-form-id-2' name='hidden-2' id='ufo-form-hidden-2'/><input type='hidden' value='{__pagename}' name='ufo-form-pagename' id='ufo-form-pagename'/>{preview}<input type='hidden' value='{ufosignature}' name='ufo-sign' id='ufo-sign'/><div></div><div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-627' style='margin-top:2px;{display-627}'><div class='ufo-cell-627-2-row' id='ufo-cell-627-2'><span class='ufo-cell-center' id='ufo-cell-627-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","default"],"focus":["default"]},"Required":true,"Validate":true,"RequiredMessage":"Your first name is required","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"First Name","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-627","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-627' value='{id-627}' name='id-627' /></span><span class='ufo-cell-right' id='ufo-cell-627-2-right'><div id='ufo-field-id-627-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-647' style='margin-top:2px;{display-647}'><div class='ufo-cell-647-2-row' id='ufo-cell-647-2'><span class='ufo-cell-center' id='ufo-cell-647-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","minmax","default"],"focus":["default"]},"Required":true,"Validate":true,"RequiredMessage":"Your last name is required","AbsolutePosition":true,"RequiredMessagePosition":"right","min":"2","max":"45","DefaultValue":"Last Name","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-647","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-647' value='{id-647}' name='id-647' /></span><span class='ufo-cell-right' id='ufo-cell-647-2-right'><div id='ufo-field-id-647-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-5 ufo-customform-row ufo-row-625' style='margin-top:2px;{display-625}'><div class='ufo-cell-625-2-row' id='ufo-cell-625-2'><span class='ufo-cell-center' id='ufo-cell-625-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","default","email"],"focus":["default"]},"Required":true,"Validate":true,"RequiredMessage":"Please enter you email","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"Your email","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-625","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-625' value='{id-625}' name='id-625' /></span><span class='ufo-cell-right' id='ufo-cell-625-2-right'><div id='ufo-field-id-625-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-680' style='margin-top:2px;{display-680}'><div class='ufo-cell-680-2-row' id='ufo-cell-680-2'><span class='ufo-cell-center' id='ufo-cell-680-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","default"],"focus":["default"]},"Required":true,"Validate":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"Phone Number","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-680","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-680' value='{id-680}' name='id-680' /></span><span class='ufo-cell-right' id='ufo-cell-680-2-right'><div id='ufo-field-id-680-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-677' style='margin-top:2px;{display-677}'><div class='ufo-cell-677-2-row' id='ufo-cell-677-2'><span class='ufo-cell-center' id='ufo-cell-677-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["required","default"],"focus":["default"]},"Required":true,"RequiredMessage":"Company Name is required","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"Company Name","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-677","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-677' value='{id-677}' name='id-677' /></span><span class='ufo-cell-right' id='ufo-cell-677-2-right'><div id='ufo-field-id-677-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-4 ufo-customform-row ufo-row-678' style='margin-top:2px;{display-678}'><div class='ufo-cell-678-2-row' id='ufo-cell-678-2'><span class='ufo-cell-center' id='ufo-cell-678-2-center'><script type='text/javascript'>ufoFormsConfig.validations.push({"events":{"blur":["default"],"focus":["default"]},"Validate":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","DefaultValue":"Website URL","IsBlankValue":true,"DefaultValueCSSClass":"dummy","id":"ufo-field-id-678","form":"ufo-form-id-2"});</script><input type='text' id='ufo-field-id-678' value='{id-678}' name='id-678' /></span><span class='ufo-cell-right' id='ufo-cell-678-2-right'><div id='ufo-field-id-678-invalid' style='display:none'></div></span></div></div><div class='ufo-fieldtype-6 ufo-customform-row ufo-row-630' style='margin-top:2px;{display-630}'><div class='ufo-cell-630-2-row' id='ufo-cell-630-2'><span class='ufo-cell-center' id='ufo-cell-630-2-center'><script type='text/javascript'>var c = {};c.id = 'ufo-field-id-630';c.form = 'ufo-form-id-2';c.Label = 'Submit >';ufoFormsConfig.submits.push(c);</script><span id='ufo-field-id-630-span'><noscript><button type='submit' id='ufo-field-id-630' name='id-630' >Submit ></button></noscript></span></span></div></div></div><div id='ufo-form-id-2-message'></div><noscript></form></noscript></div>', SendFromAddress = '[email protected]', ShowSubmissionSuccess = '1', Width = '266', WidthUnit = 'px', LineHeight = '2', LineHeightUnit = 'px', Style = 'easyform', TotalEntries = '62', TotalProcessedEntries = '2', Impressions = '1537', NotificationText = '<p>{627.FirstName}{647.LastName}</p> <p>{625.Email}</p> <p>{680.PhoneNumber}</p> <p>{677.CompanyName}</p> <p>{678.WebsiteURL}</p>', IncludeVisitorsAddressInReplyTo = '1', ReplyToNameTemplate = '{627.FirstName} {647.LastName}', ConfirmationReplyToAddress = '[email protected]', SendConfirmationAsText = '0', SendNotificationAsText = '0', FadingDelay = '100', MessageDelay = '100', IncludeIntoReporting = '1' WHERE id = '2' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wp-bold110/page-custom.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, easycontactforms_formentrypoint, EasyContactFormsCustomForms::getForm, EasyContactFormsBase->save, EasyContactFormsCustomForms->update, EasyContactFormsBase->update, EasyContactFormsDB->update, EasyContactFormsDB->query
https://www.ads-software.com/plugins/easy-contact-form-solution/
- The topic ‘Database Error with Copy’ is closed to new replies.