[SOLVED] Error Code: 1292 Incorrect Datetime Value | ERROR 1067 (42000): Invalid Default Value MySQL

The error code 1292 in MySQL "Incorrect datetime value," usually occurs when there's a problem with the format of the datetime value you're trying to insert or update.

The error message "ERROR 1067 (42000): Invalid default value for 'created_at'" typically indicates an issue with the default value assigned to the 'created_at' column in a MySQL database table.

To resolve the issue for cPanel users you can follow the below steps:

Solution 1: Using WHM User Interface:

In cPanel v102 and above, cPanel has added the "SQL Configuration" interface, allowing you to adjust many common MySQL values.

1. Login to your WHM panel:
2. Search for the Edit SQL Configuration option.
3. Then on the page look for the SQL Mode option and remove NO_ZERO_IN_DATE, NO_ZERO_DATE value from the input field.
4. After that click on the Save button below on the page.

Please note modifications made in the SQL configuration page will prompt a MariaDB or MySQL service restart as soon as you Save the changes.

Solution 2: Using Command Line Interface:

1. Log into your server as root, then use your favorite text editor to open the file.

2. In my case I'm using Vim Text Editor. Use the below command:

OR

3. On the file press I to enter the insert mode.

4. In the last line paste the below code under [mysqld]:

sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

In the above command, I have removed (NO_ZERO_IN_DATE,NO_ZERO_DATE) already.

5. Now press ESC key to exit input mode.

6. Then type :wq to save and close vim.
7. Then you need to restart MySQL, use the below commands to restart:
# sudo service mysqld restart

OR
# /scripts/restartsrv_mysql

That's it. Done!

This error can arise with different messages and has its own way of fixing it.

Thanks for watching the video. Don't forget to LIKE, COMMENT, and SUBSCRIBE the channel.