Error on save

  • Profile Image
    logunov98
    Asked on June 18, 2012 at 09:45 AM

    Error on query: INSERT INTO `form_properties` (`form_id`, `item_id`, `type`, `prop`, `value`) VALUES (2169398768036, 0, '', 'styles', 'nova'), (2169398768036, 0, '', 'font', 'Lucida Grande'), (2169398768036, 0, '', 'fontsize', '14'), (2169398768036, 0, '', 'fontcolor', '#555'), (2169398768036, 0, '', 'optioncolor', '#000'), (2169398768036, 0, '', 'lineSpacing', '12'), (2169398768036, 0, '', 'formWidth', '650'), (2169398768036, 0, '', 'labelWidth', '150'), (2169398768036, 0, '', 'alignment', 'Left'), (2169398768036, 0, '', 'highlightLine', 'Enabled'), (2169398768036, 0, '', 'activeRedirect', 'default'), (2169398768036, 0, '', 'sendpostdata', 'No'), (2169398768036, 0, '', 'unique', 'None'), (2169398768036, 0, 'formStrings', 'alphabetic', 'This field can only contain letters'), (2169398768036, 0, 'formStrings', 'alphanumeric', 'This field can only contain letters and numbers.'), (2169398768036, 0, 'formStrings', 'confirmClearForm', 'Are you sure you want to clear the form'), (2169398768036, 0, 'formStrings', 'confirmEmail', 'E-mail does not match'), (2169398768036, 0, 'formStrings', 'email', 'Enter a valid e-mail address'), (2169398768036, 0, 'formStrings', 'incompleteFields', 'There are incomplete required fields. Please complete them.'), (2169398768036, 0, 'formStrings', 'lessThan', 'Your score should be less than'), (2169398768036, 0, 'formStrings', 'numeric', 'This field can only contain numeric values'), (2169398768036, 0, 'formStrings', 'pleaseWait', 'Please wait...'), (2169398768036, 0, 'formStrings', 'required', 'This field is required.'), (2169398768036, 0, 'formStrings', 'uploadExtensions', 'You can only upload following files:'), (2169398768036, 0, 'formStrings', 'uploadFilesize', 'File size cannot be bigger than:'), (2169398768036, 0, '', 'emailAsked', 'Yes'), (2169398768036, 0, '', 'id', '2169398768036'), (2169398768036, 0, '', 'sendEmail', 'Yes'), (2169398768036, 0, '', 'style', 'Default'), (2169398768036, 0, '', 'theme', 'nova'), (2169398768036, 0, '', 'hash', '4ne31g7alt')
    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)

  • Profile Image
    AtacanC
    Answered on June 18, 2012 at 12:38 PM

    Are you experiencing problems while you are saving your form? Can you also tell us the form ID /URL?

    Thanks in advance.

  • Profile Image
    logunov98
    Answered on June 18, 2012 at 12:57 PM

    Why you got me banned after this message (I'm Russian, translator)

  • Profile Image
    AtacanC
    Answered on June 18, 2012 at 01:14 PM

    My colleagues have already responded to your other post and reactivated your account.

  • Profile Image
    magustin
    Answered on July 18, 2012 at 04:20 PM

    Hi. I'm having the same issue. I'm trying to save a new French form for our website. I have saved other French forms without any issue. Here is the error message: 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)

     

    I don't know the form ID because when I go to Embed to look at it, it starts to save, and I get the error message again.

     

    Thanks for your help!

  • Profile Image
    jeanettebmz
    Answered on July 18, 2012 at 07:48 PM

    @magustin

    Can you please login into the form builder, open any form and make a right click in a blanck space on the upper area ? you should be able to display a menu, look for the 3rd option "Disable auto save"

    Then try to get the form ID , just click on Preview and grab it from it

    If you still need assistance, please open a new thread so we can assist you better

    Jeanette

  • Profile Image
    ethicalfashionforum
    Answered on June 10, 2014 at 02:17 PM

    Hi I am having a similar problem - and the form is not submitting again please see error message below.

  • Profile Image
    Mike_T
    Answered on June 10, 2014 at 03:48 PM

    @Ethicalfashionforum,

    We will handle the issue via this thread. Thank you.