Project

General

Profile

Actions
Copy link

Evolution #587

closed

Fix mysql 5.6 issue related to "doesn't have a default value" error

Added by Simon over 7 years ago. Updated over 7 years ago.

Status:
Fermé
Priority:
Normal
Assignee:
Simon
Category:
general
Target version:
2.0
Start date:
10/10/2016
Due date:
% Done:

100%

Estimated time:
2.00 h
Resolution:

Description

See : http://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values

This is caused by the STRICT_TRANS_TABLES SQL mode defined in the %PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini file. Removing that setting and restarting MySQL should fix the problem.

Related issues 1 (0 open — 1 closed)

Related to Anomalie #588: Fix mysql 5.6 issue related to "doesn't have a default value" error in tagFerméSimon10/10/2016

Actions
Actions
Copy link
 #1

Updated by Simon over 7 years ago

  • Related to Anomalie #588: Fix mysql 5.6 issue related to "doesn't have a default value" error in tag added
Actions
Copy link
 #2

Updated by Simon over 7 years ago

check each table / associated php class to see if default value is set

Actions
Copy link
 #3

Updated by Simon over 7 years ago

  • Tracker changed from Anomalie to Evolution
  • Status changed from Nouveau to Fermé
  • % Done changed from 0 to 100
Actions
Copy link

Also available in: Atom PDF