Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Setup not working #18

Open
nekocari opened this issue May 8, 2023 · 3 comments
Open

Setup not working #18

nekocari opened this issue May 8, 2023 · 3 comments
Assignees
Labels
help wanted Extra attention is needed

Comments

@nekocari
Copy link
Owner

nekocari commented May 8, 2023

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: 46e634a

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

@nekocari nekocari added the help wanted Extra attention is needed label May 8, 2023
@nekocari nekocari self-assigned this May 8, 2023
@nekocari nekocari pinned this issue May 8, 2023
@Deilex
Copy link

Deilex commented Jul 23, 2023

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
Copy link
Owner Author

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

@nekocari nekocari unpinned this issue Aug 6, 2023
@gavintfn
Copy link

gavintfn commented Oct 30, 2023

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(),

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

3 participants