donate: disable mysql strict mode

[chef.git] / cookbooks / donate / templates / default / db-connect.inc.php.erb

diff --git a/cookbooks/donate/templates/default/db-connect.inc.php.erb b/cookbooks/donate/templates/default/db-connect.inc.php.erb
index 302a21c9ae1e73b90e7e95e00cc4fc16968bfe56..c4cea1f935a30c1a369fdad68123fab895bb0f36 100644 (file)
--- a/cookbooks/donate/templates/default/db-connect.inc.php.erb
+++ b/cookbooks/donate/templates/default/db-connect.inc.php.erb
@@ -3,5 +3,6 @@ $_DB_H = new mysqli('localhost','donate','<%= @passwords['database'] %>','donate
 if ($_DB_H->connect_errno) {
     die('DB Connect Error: ' . $_DB_H->connect_errno);
 }
-$_DB_H->report_mode = MYSQLI_REPORT_ALL ^ MYSQLI_REPORT_STRICT;
+$_DB_H->report_mode = MYSQLI_REPORT_ERROR;
+$_DB_H->query('set @@sql_mode = \'\'');
 $_DB_H->query('SET NAMES \'utf8\'');