Most enterprise environments will not give super user privileges and will enforce strict level on MySQL/MariaDB that can only be changed at runtime or session level by issuing a command such as sql-mode=""
This can be done in Wappler by appending : $this->pdo->exec("set session sql_mode = ''");
to
$this->pdo = new PDO($dsn, $user, $password, $pdo_options);
$this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
in dmxConnectLib/lib/db/Connection.php
, but everytime the dmxConnectLib folder needs to be recreated (a very frequent instance since the latest wappler updates), the change is lost.
Could we have a check box in the Database Connection Options of a connection file to check, that will enable this option?
Community Page
Last updated:
Last updated: