Error on demo page - anywhere builder

  • Profile Image
    narenberacah
    Asked 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"}
  • Profile Image
    Welvin
    Answered 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
    narenberacah
    Answered 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
    TitusN
    Answered 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.