Appnitro Software Forums » MachForm

mail error

(4 posts)
  • Started 3 years ago by thomasmagee
  • Latest reply from yuniar

  1. thomasmagee
    Member

    I followed the upgrade instructions and I am getting the following error when trying to add/update an email address to a form:

    Query failed: Out of range value adjusted for column 'esl_plain_text' at row 1

    Posted 3 years ago #

  2. yuniar
    MachForm Founder

    What version is your MySQL? Is it version 5?

    It seems that your MySQL is running under Strict Mode, which caused this error.
    Strict mode might also affect another script.

    Is it possible for you to turn off Strict Mode?
    Open your "my.ini" file within the MySQL installation directory (eg: C:\Program Files\MySQL\MySQL Server 5.0\my.ini), and look for the text "sql-mode".
    Find:

    # Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"


    Replace with:

    # Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"


    Windows users can also simply uncheck the "Enable Strict Mode" option while going through the pages of "MySQL Server Instance Configuration Wizard".

    If that's not possible. Login to customer area and redownload the new package again.
    Update your email_settings.php file. I've included a fix to overcome this issue.

    However, if possible, try to turn off strict mode. I think it's the better solution.

    Posted 3 years ago #

  3. thomasmagee
    Member

    It appears to correct itself when I check the box to 'Send emails in simple text format' If that box is left unchecked I get the original error.

    Posted 3 years ago #

  4. yuniar
    MachForm Founder

    Have you tried the above solution?

    Posted 3 years ago #

RSS feed for this topic

Reply

You must log in to post.