Usage Guide and Documentation

EN

MySQL Strict Mode Issue

With version 5.7+ of MySQL, some strict mode rules have been introduced as standard for SQL mode definitions. In some cases, these rules may interfere with the operation of softwares.

WISECP automation, like many other automation systems, is not compatible with the "SQL Strict Mode" rules.

Therefore, strict mode rules must be removed from the "SQL Mode" definitions of your MySQL server.

You can follow the steps below regarding how to do this.

---

1) Open the  /etc/my.cnf   file by accessing your server via SSH or SFTP with root authority.
(If you do not have root access, these process must be provided by people who are authorized to access the server root.)

2) Add the sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" definition to the bottom of the file "my.cnf" and save it.

  • If your server does not accept ", you can define without ". If this doesn't work, you can just define it as sql_mode=
  • The definition you add should be under the [mysqld] line. If your file does not contain the line [mysqld], you can add it manually.

3) Restart your MySQL server.

If you do not have knowledge or expertise in such matters, you can get information and support from your service provider or any server management professional.

Shared Server Settings

Do you have any questions?

Feel free to contact us
Contact Us
Copyright © 2021. All rights reserved.
Join Our Discord Channel
Top