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

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

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.

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 )

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

Any ideas?

Theme © iAndrew 2016 - Forum software by © MyBB