What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    Error message when trying to save changes

    Asked by tellerin on July 23, 2012 at 12:54 PM

    Error on query: INSERT INTO `form_properties` (`form_id`, `item_id`, `type`, `prop`, `value`) VALUES (2166797793917, 0, '', 'styles', 'nova'), (2166797793917, 0, '', 'font', 'Comic Sans MS'), (2166797793917, 0, '', 'fontsize', '14'), (2166797793917, 0, '', 'fontcolor', '#9900ff'), (2166797793917, 0, '', 'optioncolor', '#9900ff'), (2166797793917, 0, '', 'lineSpacing', '12'), (2166797793917, 0, '', 'formWidth', '650'), (2166797793917, 0, '', 'labelWidth', '150'), (2166797793917, 0, '', 'alignment', 'Left'), (2166797793917, 0, '', 'highlightLine', 'Enabled'), (2166797793917, 0, '', 'activeRedirect', 'default'), (2166797793917, 0, '', 'sendpostdata', 'No'), (2166797793917, 0, '', 'unique', 'None'), (2166797793917, 0, 'formStrings', 'alphabetic', 'This field can only contain letters'), (2166797793917, 0, 'formStrings', 'alphanumeric', 'This field can only contain letters and numbers.'), (2166797793917, 0, 'formStrings', 'confirmClearForm', 'Are you sure you want to clear the form'), (2166797793917, 0, 'formStrings', 'confirmEmail', 'E-mail does not match'), (2166797793917, 0, 'formStrings', 'email', 'Enter a valid e-mail address'), (2166797793917, 0, 'formStrings', 'incompleteFields', 'There are incomplete required fields. Please complete them.'), (2166797793917, 0, 'formStrings', 'lessThan', 'Your score should be less than'), (2166797793917, 0, 'formStrings', 'numeric', 'This field can only contain numeric values'), (2166797793917, 0, 'formStrings', 'pleaseWait', 'Please wait...'), (2166797793917, 0, 'formStrings', 'required', 'This field is required.'), (2166797793917, 0, 'formStrings', 'uploadExtensions', 'You can only upload following files:'), (2166797793917, 0, 'formStrings', 'uploadFilesize', 'File size cannot be bigger than:'), (2166797793917, 0, 'emails', 'body', '\n \n \n \n \n \n \n \n \n \n \n
    \n \n \n \n \n \n

    \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n\n\n\n\n Question Answer
    What do you want me to call you? {whatDo}
    E-mail {email4}
    Tell me all about you! I want to know everything! {tellMe}


    \n'), (2166797793917, 0, 'emails', 'from', 'default'), (2166797793917, 0, 'emails', 'html', '1'), (2166797793917, 0, 'emails', 'name', 'Notification'), (2166797793917, 0, 'emails', 'subject', 'New submission: {form_title}'), (2166797793917, 0, 'emails', 'to', 'erin@tellerin.com'), (2166797793917, 0, 'emails', 'type', 'notification'), (2166797793917, 0, '', 'defaultEmailAssigned', 'Yes'), (2166797793917, 0, '', 'id', '2166797793917'), (2166797793917, 0, '', 'sendEmail', 'Yes'), (2166797793917, 0, '', 'stopHighlight', 'Yes'), (2166797793917, 0, '', 'style', 'Default'), (2166797793917, 0, '', 'theme', 'nova'), (2166797793917, 0, '', 'hash', '4n6v1aei92')
    Error returned:Cannot add or update a child row: a foreign key constraint fails (`jotform_new`.`form_properties`, CONSTRAINT `form_properties_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `forms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

    Page URL:

  • Profile Image
    JotForm Founder

    Answered by aytekin on July 23, 2012 at 01:14 PM

    I don't see a form with that form ID (2166797793917) in your account. It might be a form that was deleted previously. Do you get this error by going to your My Forms page, selecting a form and then clicking on "edit" and then click on save when the form is open on the form builder? 

    Can you describe how we can replicate the error? 

  • Profile Image

    Answered by tellcharles on July 24, 2012 at 03:05 PM

    The form ID is 21667977939174 -- you left off the last number.

    It seems you have fixed it -- it does not do it today.

    The Heading is used for the record address and this may cause the error.

    The editing was changing a heading that had been used for some time.