CODEWITHSUNDEEP
mysqlcpanel
roy naufal
roy naufal

Reputation: 399

mysql issue inserting with mysql strict mode off

I have strict mode off, but still getting the below error and it's really puzzling me, would greatly appreciate some help!

I am using mysql 5.6, on a cpanel/whm centos server

Warning: #1366 Incorrect integer value: '' for column `articles`.`link_contributor_id` at row 1

SHOW VARIABLES LIKE "innodb_strict_mode" = off

SHOW VARIABLES LIKE "sql_mode" = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Upvotes: 0

Views: 201

Answers (1)

Monkybomb Studios
Monkybomb Studios

Reputation: 1

I had the same problem what i did was go to the WHM account, go to :

WHM -> SQL Services -> Edit SQL Configuration

Once on this page find the field "SQL MODE" and Remove Strict Transport, this is the line that worked for me.

ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Maybe this will help someone else in the future.

Upvotes: 0

Related Questions