Error message when trying to save changes

  • Profile Image
    tellerin
    Asked 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







    \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)
    OK

  • Profile Image
    aytekin
    Answered 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
    tellcharles
    Answered 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.