MySql Error: 1364 Field ‘display_name’ doesn’t have default value

by

MySQL is most likely in STRICT mode.

Try running SET GLOBAL sql_mode="" or edit your my.cnf to make sure you aren’t setting STRICT_ALL_TABLES or the like.

More Related Contents:

  1. Create PHP timestamp to insert into mysql databse [duplicate]
  2. Why shouldn’t I use mysql_* functions in PHP?
  3. PHP – Using PDO with IN clause array
  4. How to get ID of the last updated row in MySQL?
  5. Invoking a PHP script from a MySQL trigger
  6. When should I use MySQLi instead of MySQL?
  7. How to repair a serialized string which has been corrupted by an incorrect byte count length?
  8. Fatal error: Uncaught Error: Call to undefined function mysql_connect()
  9. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result [duplicate]
  10. PDO mysql: How to know if insert was successful
  11. php / Mysql best tree structure
  12. PHP & MySQL Pagination
  13. How to write a REST API?
  14. Prevent InnoDB auto increment ON DUPLICATE KEY
  15. PHP inserting multiple checkbox AND textbox arrays into MySQL Database
  16. How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?
  17. Updating from MYSQL to MYSQLI [duplicate]
  18. How to convert these strange characters? (ë, Ã, ì, ù, Ã)
  19. PDO error: SQLSTATE[HY000]: General error: 2031
  20. How to display image from database using php [duplicate]
  21. Simple PHP SQL login troubleshooting
  22. php warning mysql_fetch_assoc
  23. Check if row exists in the database before inserting
  24. MySQL Table does not exist error, but it does exist
  25. How does “do something OR DIE()” work in PHP?
  26. adding 1 day to a DATETIME format value
  27. Query on a many-to-many relationship using Doctrine with Symfony2
  28. UTF-8 not working in HTML forms
  29. Using mysql concat() in WHERE clause?
  30. Connect to a MySQL server over SSH in PHP

Leave a Comment