By Pardis


2015-05-14 07:07:29 8 Comments

  1. few weeks ago we upgraded mysql server from 5.5 to 5.6

  2. on 1st server few days ago (5May) I reboot mysql server , after this customer reported that some database data table not load to their site . (mostly phpfox - also few in other scripts) - also new data not submitted to database

  3. I was reinstall mysql - disable cloudlinux - cagefs ... but problem not resolve. also rebuild php

  4. after above , I move that database to remote-mysql-test-server with same Mysql version (5.6) and problem resolved. So I found this problem mysql related

  5. yesterday in an other server like above (server B - that mysql upgraded from 5.5 - 5.6 few weeks ago) when mysql server restart , same problem occurred . for example when I answer ticket (WHMCS) , this date not submitted to ticket ... some clients can't update their site .

few website error like this : SQL] [1364] Field 'stat_time' doesn't have a default value STRING: INSERT INTO pn_statistics (stat_name,stat_value) VALUES ('Day-1394-02-24','0')

also in this server when I move database to remote-mysql-test-server this problem resolved.

  1. I speak with few system admin and they can't find my issue .

Any suggestion ?

1 comments

@RolandoMySQLDBA 2015-05-14 10:22:45

PROBLEM

I think your problem stems from a change in sql_mode.

SOLUTION

Run this command

SET GLOBAL sql_mode = '';

Then, add this to my.cnf to keep sql_mode blank should you restart mysqld

[mysqld]
sql_mode = ''

You do not need to restart mysqld since you set it globally

GIVE IT A TRY !!!

@Rick James 2015-05-14 22:09:40

Seems like it would be better to figure what was wrong with the data (or whatever) and fix that. Turning off sql_mode may be "sweeping it under the rug".

@Pardis 2015-05-17 06:24:23

Hello ... thanks ...you help me resolve this problem. but putting new config to mysql config file not work and need run : SET GLOBAL sql_mode = ''; after every restart.

Related Questions

Sponsored Content

2 Answered Questions

1 Answered Questions

[SOLVED] Issues with mysqldump after upgrade 5.5 -> 5.6

1 Answered Questions

[SOLVED] Tickets created and resolved (or merged) per year

1 Answered Questions

[SOLVED] MySQL Dying After a Few Days

  • 2015-09-23 02:25:53
  • PaulELI
  • 73 View
  • 1 Score
  • 1 Answer
  • Tags:   mysql-5.6

1 Answered Questions

1 Answered Questions

[SOLVED] Strange Availability Problem with MySQL

  • 2015-04-20 16:01:35
  • Kokako
  • 217 View
  • 2 Score
  • 1 Answer
  • Tags:   mysql

1 Answered Questions

1 Answered Questions

2 Answered Questions

[SOLVED] Changing the mysql.proc table directly after upgrade

Sponsored Content