SQL queries on every page load codeigniter

Question

On all page loads, I have these queries running on my MYSQL server :

      155 Query SET SESSION sql_mode =
                REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
                @@sql_mode,
                "STRICT_ALL_TABLES,", ""),
                ",STRICT_ALL_TABLES", ""),
                "STRICT_ALL_TABLES", ""),
                "STRICT_TRANS_TABLES,", ""),
                ",STRICT_TRANS_TABLES", ""),
                "STRICT_TRANS_TABLES", "")
      155 Query SET NAMES utf8
      155 Quit  

How can I prevent these requests from running? I tried to deactivate "char_set" and "dbcollat" in config/database.php but this has no effect

Answer 1

Codeigniter is turning MySQL's strict sql mode off. In the database.php set the strickton parameter to true to enable strict mode.

However, codeigniter wants to make sure that the settings configured for every connection. If you want to take care of these settings in the MySQL config files, then you need to remove (well, comment out) these options from the database.php.