+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Error when specific SQL Mode is set - mysqli::real_connect(): (42S22/1054) (/showthread.php?tid=66396)
Error when specific SQL Mode is set - mysqli::real_connect(): (42S22/1054) - mstojanov - 10-19-2016
Hi guys.
I have some strange problem that i don't know how to solve/handle..
When i set the following SQL Mode "REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI" this problem occurs.
When the default mode (NO_ENGINE_SUBSTITUTION) is used there is no such a problem and everything is working as expected.
Code:
Severity: Warning
Message: mysqli::real_connect(): (42S22/1054): Champ 'STRICT_ALL_TABLES,' inconnu dans field list
Filename: mysqli/mysqli_driver.php
Line Number: 202Any ideas what can cause this issue?
I'm using Codeigniter 3.1.0
Appreciate the help.
RE: Error when specific SQL Mode is set - mysqli::real_connect(): (42S22/1054) - InsiteFX - 10-19-2016
It would help if you showed us your query.
RE: Error when specific SQL Mode is set - mysqli::real_connect(): (42S22/1054) - mstojanov - 10-19-2016
Hello InsiteFX.
Thank you for your reply.
There is no query, this happens when Codeigniter initialize the database.
After call parent::__construct() is calleded in some of my controllers the error occurs.
https://s10.postimg.org/9q0p70quh/error_codeigniter.png
Any ideas?
Thanks.