Welcome Guest, Not a member yet? Register   Sign In
Error when specific SQL Mode is set - mysqli::real_connect(): (42S22/1054)
#1

(This post was last modified: 10-19-2016, 02:11 AM by mstojanov. Edit Reason: explanation improvements. )

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: 202

Any ideas what can cause this issue?
I'm using Codeigniter 3.1.0

Appreciate the help.
Reply
#2

It would help if you showed us your query.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply
#3

(This post was last modified: 10-19-2016, 11:06 AM by mstojanov.)

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.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB