Setup not working

[nekocari]

Depending on the configurations, different errors were reported but could not yet be reproduced.

If you are having these issues, you might want to try the updated setup files from this commit: https://github.com/nekocari/miniTCG/commit/46e634a6efd0d29362b1ceccffbccc6a5830e70f

In case of an error, there should now be a more detailed entry in your app_error.log

[Deilex]

Hi @nekocari, I have a problem once installed, it has successfully connected me to the database and created the user for me. But when trying to login or any of the options in the main menu, it gives an error that it does not locate the object and from what I see in the URL it tries to search for a directory that is not correct. Do you know if it could be something in the configuration?

[nekocari]

The code depends on redirects via the .htaccess file. I guess your host might not support that? @Deilex

[gavintfn]

If 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"

1. make a backup.... cp /etc/mysql/mysql.cnf /etc/mysql/mysql.cnf.bk
2. nano /etc/mysql/mysql.cnf
3. scroll down to [mysqld] or add, if it does not exist.
4. under [mysqld] , add sql-mode = "ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
5. use ctrl+o > enter > ctrl+x > enter to save and exit
6. 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(),