https://www.machform.com/forums/ MachForm Community Forums Topic: mail error en Wed, 06 May 2026 04:32:46 +0000 https://www.machform.com/forums/topic/mail-error#post-2609 Fri, 08 Aug 2008 14:25:58 +0000 yuniar 2609@https://www.machform.com/forums/ <p>Have you tried the above solution? </p> https://www.machform.com/forums/topic/mail-error#post-2602 Thu, 07 Aug 2008 23:20:19 +0000 thomasmagee 2602@https://www.machform.com/forums/ <p>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. </p> https://www.machform.com/forums/topic/mail-error#post-1572 Thu, 01 May 2008 09:41:50 +0000 yuniar 1572@https://www.machform.com/forums/ <p>What version is your MySQL? Is it version 5?</p> <p>It seems that your MySQL is running under Strict Mode, which caused this error.<br /> Strict mode might also affect another script.</p> <p>Is it possible for you to turn off Strict Mode?<br /> 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".<br /> Find:</p> <pre><code># Set the SQL mode to strict sql-mode=&quot;STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION&quot;</code></pre> <p><code></code><br /> Replace with:</p> <pre><code># Set the SQL mode to strict sql-mode=&quot;NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION&quot;</code></pre> <p><code></code><br /> Windows users can also simply uncheck the "Enable Strict Mode" option while going through the pages of "MySQL Server Instance Configuration Wizard".</p> <p>If that's not possible. Login to customer area and redownload the new package again.<br /> Update your <strong>email_settings.php</strong> file. I've included a fix to overcome this issue.</p> <p>However, if possible, try to turn off strict mode. I think it's the better solution. </p> https://www.machform.com/forums/topic/mail-error#post-1561 Thu, 01 May 2008 01:05:19 +0000 thomasmagee 1561@https://www.machform.com/forums/ <p>I followed the upgrade instructions and I am getting the following error when trying to add/update an email address to a form:</p> <p>Query failed: Out of range value adjusted for column 'esl_plain_text' at row 1 </p>