1. Error information
2. Edit file
# open the configuration file
vim /etc/my.cnf
# add this line in the end
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
3. Restart MySQL
systemctl restart mysqld
4. Test
# Start
nohup java -jar xxx.jar &
# Checnk the console
tail -f nohup.out
Read More:
- MYSQL gruop by Error: this is incompatible with sql_mode=only_full_group_by
- [Solved] MYSQL 5.7 gruop by eRROR: this is incompatible with sql_mode=only_full_group_by
- [Solved] MySQL Error: ERROR 1055 (42000)sql_mode=only_full_group_by
- How to Solve MySQL version 5.7+ Group by group error
- [Solved] MySQL Error: “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”
- [Solved] ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
- [Solved] Sequelize DatabaseError: ER_WRONG_FIELD_WITH_GROUP: Expression #2 of SELECT list is not in GROUP
- [MySQL] The principle of group by aggregation function and the reason for aggregation limitation SELECT list is not in GROUP BY clause and contains nonaggregated column
- SQL Server Group sort de duplication row_ number() over ( PARTITION BY t1.col_ 2 ORDER BY 1 )
- MySQL 8.0.12 runs SQL error #1055 [How to Solve]
- Mysql ERROR 1067: Invalid default value for ‘date’ [How to Solve]
- [Solved] MySQL: Syntax error or access violation: 1055 Expression #1 of SELECT list is not …
- java.sql.SQLException: Disk full (/tmp/#sql_1eaa2_60.MAI); waiting for someone to free some space
- [Solved] MySQL5.6.44 [Err] 1067 – Invalid default value for create_date settlement programme
- [Linux Docker Mirror] MYSQL Run sql Script Error: Failed to open file ‘/home/mydatabase.sql‘, error: 2
- MYSQL Create TIMESTAMP and Save Error: ERROR 1067 (42000): Invalid default value for ‘last_updated_on’
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- How to Solve mysql [Err] 1067-Invalid default value for
- Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 – Connection is not available, request timed out after 30005ms.