Troubles with installation

[Aotherfuckingusername]

Hey Everyone, may i found some Help here ..

First i got this Text when i try to setup:
Could not create database! Error Message: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'join_date'

So i simply "outcode" the Part on the Setup File, now i got this Issue.
Could not create database! Error Message: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'utc'

I run it on a Webhosting with MySQL.

Thanks for your Reply and a happy 2024

[Aotherfuckingusername]

Found This :)

f using MySQL instead of MariaDB, make sure to remove STRICT_TRANS_TABLES from sql-mode in your /etc/mysql/mysql.cnf
or /etc/my.ini file.
If you do not have sql-mode set in that file,
default value for reference, though not actually in the file is:
sql-mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

make a backup.... cp /etc/mysql/mysql.cnf /etc/mysql/mysql.cnf.bk
nano /etc/mysql/mysql.cnf
scroll down to [mysqld] or add, if it does not exist.
under [mysqld] , add
sql-mode = "ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
use ctrl+o > enter > ctrl+x > enter to save and exit
then service mysql restart
As well, 'utc' default value throws an error from line 596 in file "setup\structure_v1_3beta.sql"

you will want to replace line 596:
varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT current_timestamp(),
with
datetime COLLATE utf8_unicode_ci NOT NULL DEFAULT current_timestamp(),