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 on save

    Asked by logunov98 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)

    email style size alignment
  • Profile Image

    Answered by AtacanC 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

    Answered by logunov98 on June 18, 2012 at 12:57 PM

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

  • Profile Image

    Answered by AtacanC on June 18, 2012 at 01:14 PM

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

  • Profile Image

    Answered by magustin 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

    Answered by jeanettebmz 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

    Answered by ethicalfashionforum 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
    JotForm Support

    Answered by Mike_T on June 10, 2014 at 03:48 PM

    @Ethicalfashionforum,

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