Uploaded image for project: 'Forms'
  1. Forms
  2. FORMS-97

Inconsistency between database and form

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 1.0.1, 1.1
    • 1.0
    • Back Inline editor
    • None

      The form in the editor has the following code

      <form type="cms" label="Votre%20texte" id="form_04201549284317475" receipt_to="Ametys_Gen_2" receipt_from="webmaster.medecine@contact.univ-angers.fr" receipt_subject="Accus%C3%A9%20de%20reception" receipt_body="Madame%2C%20Monsieur%2C%0A%0ANous%20accusons%20r%C3%A9ception%20de%20votre%20soumission%20sur%20notre%20site%20web.%0AVotre%20demande%20va%20%C3%AAtre%20trait%C3%A9e%20dans%20les%20meilleurs%20d%C3%A9lais.%0A%0AVeuillez%20agr%C3%A9er%2C%20Madame%2C%20Monsieur%2C%20l'expression%20de%20nos%20salutations%20distingu%C3%A9es.%0A%0ALe%20Webmestre" processing_emails="stephane.amiard%40univ-angers.fr" layout="table-2col">
        <table style="width: 100%;" class="invisible" marker="marker">
          <tbody>
            <tr>
              <td style="vertical-align: top;">
                <p style="text-align: right;">
                  <label for="Ametys_Gen_2">Votre adresse e-mail :
                  </label>
                </p></td><td>
                <p>
                  <input type="text" name="text1" id="Ametys_Gen_2" mandatory="true" width="220" confirmation="false" value="" maxvalue="" minvalue="" regexptype="email" regexp=""/>
                </p></td>
            </tr>
            <tr>
              <td style="vertical-align: top;">
                <p style="text-align: right;">
                  <label for="Ametys_Gen_5">Objet :
                  </label>
                </p></td><td>
                <p>
                  <input type="text" name="text2" id="Ametys_Gen_5" mandatory="true" width="220" confirmation="false" value="Inscrivez ici l'objet de votre message" maxvalue="" minvalue="" regexptype="custom" regexp=""/>
                </p></td>
            </tr>
            <tr>
              <td style="vertical-align: top;">
                <p style="text-align: right;">
                  <label for="Ametys_Gen_3">Texte :
                  </label>
                </p></td><td>
                <p>
      <textarea name="textarea1" id="Ametys_Gen_3" mandatory="true" width="220" height="80">Inscrivez%20ici%20le%20contenu%20de%20votre%20message</textarea>
                </p></td>
            </tr>
            <tr>
              <td style="vertical-align: top;">
                <p style="text-align: right;">
                  <label for="Ametys_Gen_4">Captcha :
                  </label>
                </p></td><td>
                <p>
                  <captcha id="Ametys_Gen_4" width="100" height="60" />
                </p></td>
            </tr>
            <tr>
              <td style="vertical-align: top;" colspan="2">
                <p style="text-align: center;">
                  <input type="submit" name="submit1" id="Ametys_Gen_1" width="100" value="Valider"/>
                </p></td>
            </tr>
          </tbody>
        </table>
      </form>
      

      but the database has the following code

      CREATE TABLE "Ametys_CMS"."FORMS_FORM_04201549284317475"(
      ID NUMBER PRIMARY KEY not null,
      CREATIONDATE TIMESTAMP(6) not null,
      AMETYS_GEN_2 VARCHAR2 default 'NULL',
      AMETYS_GEN_3 CLOB default 'NULL')
      

      The column AMETYS_GEN_5 is missing (even after resaving the content)
      But creating a new content and pasting the form will create a correct form.
      Maybe this is due the modification of the form ?

      (note the database is oracle)

            ngavalda Nicolas Gavalda (Inactive)
            raphael Raphaƫl Franchet
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: