Error on demo page - anywhere builder

  • narenberacah
    Asked on May 6, 2014 at 5: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"}
  • Welvin Support Team Lead
    Replied on May 6, 2014 at 8: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

  • narenberacah
    Replied on May 6, 2014 at 8: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.

    ...
  • TitusN
    Replied on May 6, 2014 at 9: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.