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 when saving form - changes has been lost

    Asked by xtechpl on February 12, 2013 at 03:20 AM

    Hello, i've been trying to save form and got errror message: 

    Error on query: DELETE FROM `form_expiration` where `form_id` = '30296509354962'
    Error returned:Lock wait timeout exceeded; try restarting transaction

    When i reopend the form some part of already saved changes on form where lost. Can you recover this data?

    For now form looks like i has been reset to default settings.

    PK

  • Profile Image
    JotForm Support

    Answered by Welvin on February 12, 2013 at 06:27 AM

    Hi,

    We're truly sorry for that! What particular form this happen by the way? On your last form ID, this is what I see: http://screencast.com/t/CrEfs28MdjvE (Last Form ID: http://www.jotform.com/30296509354962).

    What particular changes that is gone on the form? Please let us know!

    Thanks

  • Profile Image

    Answered by xtechpl on February 12, 2013 at 06:55 AM

    Hello,

    Yes, this is the right form.

    I've recovered some changes from my memory (what took me some time) while awaiting your replay. At the moment i would be glad if you could clone this form in version from time before error occured. Can you overwrite this one http://form.jotformpro.com/form/30421490910949?

    I have lost:

    styling - already recoverd it "by hand"

    thank your message

    notfication message

    custom messages for validation - already restored

  • Profile Image
    JotForm Support

    Answered by Welvin on February 12, 2013 at 07:52 AM

    Hi,

    Unfortunately, I am not sure if I can recover that from my end. One thing can solved that is to retry the changes on your end while I note this to our developers for further investigations.

    I just cleared your forms cache, I hope this will help you not to get that error again. If not, please let us know.

    Thanks

  • Profile Image

    Answered by xtechpl on February 12, 2013 at 07:54 AM

    Ok, i'll let you know if i ran into troubles.