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 demo page - anywhere builder

    Asked by narenberacah on May 06, 2014 at 05:24 AM

    The following error occurs, on using the demo anywhere builder,

     

    {"error":"Error on query: INSERT INTO `forms` (`id`, `username`, `title`, `height`, `status`, `created_at`, `updated_at`, `new`, `count`, `slug`) VALUES (41252033015437, '', 'Ask a Question Form', '', 'ENABLED', NOW(), NOW(), 0, 0, '41252033015437')
    Error returned:Cannot add or update a child row: a foreign key constraint fails (`jotform_new`.`forms`, CONSTRAINT `forms_ibfk_1` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE ON UPDATE CASCADE)","success":false,"duration":"0.020"}
    the above happened in firefox ( i also noticed that in form builder - drag and drog of form elements and swapping order of form elements wont work in firefox)
    i used a sample page and i got the same error in chrome and firefox (the following error)
    {"error":"Error on query: INSERT INTO `forms` (`id`, `username`, `title`, `height`, `status`, `created_at`, `updated_at`, `new`, `count`, `slug`)  VALUES (41252255108446, '', 'Ask a Question Form', '', 'ENABLED', NOW(), NOW(), 0, 0, '41252255108446')
    Error returned:Cannot add or update a child row: a foreign key constraint fails (`jotform_new`.`forms`, CONSTRAINT `forms_ibfk_1` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE ON UPDATE CASCADE)","success":false,"duration":"0.016"}
    builder height status div
  • Profile Image
    JotForm Support

    Answered by Welvin on May 06, 2014 at 08:05 AM

    Hi,

    You mean our own demo page, right? This link: http://www.jotform.com/anywhere/demo/site_editor.php.

    I am using FireFox v29 and I am unable to replicate the issue. If you still remember on how that error appears, please let us know so we can re-check further.

    If you are using your own demo page, then please let us know the link so we can troubleshoot the cause.

    Thanks

  • Profile Image

    Answered by narenberacah on May 06, 2014 at 08:21 AM
    Hi,

    I am using a local http server (for .net web pages, using iis) to check my page.

    I am using firefox v29 as well.

    Also I am unable to drag and drop and swap form elements in firefox (it works fine in chrome)

    Following is the code I use in my web page,




    Add Form










    Regards,
    Narendran R.

    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on May 06, 2014 at 09:34 AM

    Hello,

    Following testing, the demo on our webpage works Ok -

    Is this error occuring on the app that you have embedded on your website?

    If so, we would like to examine it, kindly share the URL to the location where you have embedded the app.

    Looking forward to your response.