My webhost says there must be something wrong with the index.php to trigger an Internal Server Error.
My error log gives also unexpected results.

2020/05/28 11:43:05 [error] 81183#81183: *93536 open() "/NAS1/vhosts/JZ2037/verygood.pt/public_www404" failed (2: No such file or directory), client: 85.138.213.54, server: verygood.pt, request: "GET /favicon.ico HTTP/2.0", host: "verygood.pt", referrer: "https://verygood.pt/install/"
2020/05/28 12:05:21 [error] 81183#81183: *108968 open() "/NAS1/vhosts/JZ2037/verygood.pt/public_www404" failed (2: No such file or directory), client: 85.138.213.54, server: verygood.pt, request: "GET /login.php HTTP/2.0", host: "verygood.pt"
2020/05/28 13:06:47 [error] 107222#107222: *147565 open() "/NAS1/vhosts/JZ2037/verygood.pt/public_www404" failed (2: No such file or directory), client: 45.137.22.84, server: verygood.pt, request: "GET /wp-includes/css/css.php HTTP/1.1", host: "verygood.pt"

Looks like it's looking for wp-includes/css and there is no wordpress installed, cause I deleted all wp files before install.
I also cannot find login.php.

Hello,

The log you posted is the access log not error log. If you check the error logs, that would be very helpful to find the cause.

You can enable app logs by changing the `log_threshold` to 1 in `app/config/config.php` and then visit the pages again to produce errors. Lastly check the latest log in `app/logs/` directory.

500 are internal server errors and would be due to various reason including bad code, wrong versions and configuration.

Once you have the error details, please let me know so that I can suggest solution.

Thank you

Thank you for your response.

Here is the log that hopefully produces a solution.

ERROR - 2020-05-29 13:55:47 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'JZ2037_LDH.tec_topics.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT `tec_topics`.*, `tec_categories`.`name` as `category`, `subcategories`.`name` as `child_category`, `tec_users`.`id` as `user_id`, `tec_users`.`username`, `tec_users`.`avatar`, `tec_users`.`gender` as `user_gender`, `tec_posts`.`body`, COUNT(tec_posts.id) as total_posts
FROM `tec_topics`
LEFT JOIN `tec_posts` ON `tec_posts`.`topic_id`=`tec_topics`.`id`
LEFT JOIN `tec_categories` ON `tec_categories`.`id`=`tec_topics`.`category_id`
LEFT JOIN `tec_categories` `subcategories` ON `subcategories`.`id`=`tec_topics`.`child_category_id`
LEFT JOIN `tec_users` ON `tec_users`.`id`=`tec_topics`.`created_by`
WHERE `tec_categories`.`active` = 1
AND `protected` = 0
AND `tec_topics`.`status` = 1
GROUP BY `tec_posts`.`topic_id`
ORDER BY `sticky` DESC, `tec_posts`.`created_at` DESC
LIMIT 10
ERROR - 2020-05-29 13:55:47 --> Severity: error --> Exception: Call to a member function num_rows() on boolean /NAS1/vhosts/JZ2037/verygood.pt/public_www/app/models/Forums_model.php 161


Thank you,
regards
Hans

Hello,

Please disable MySQL `only_full_group_by ` mode. It's mentioned on the item page that this item is not compatible with only_full_group_by mode.

Thank you

Thank you for this answer. Apparently my version of SQL does not give me the option to disable the mode. Therefore I asked my host to do so, but that costs time again.
Google gives many solutions but it is not clear to me in which file to make the changes in case my host cannot disable the mode.
Can you give me more directions as to where in the script to make the changes?
Also what about the last error on Forums_model.php line 161 that value is set to "0" Must I change that to what value?
Thank you, I'll keep you posted

Hello,

To change it globally, you need root privileges. This suggest this article [https://tableplus.com/blog/2018/08/mysql-how-to-turn-off-only-full-group-by.html](https://tableplus.com/blog/2018/08/mysql-how-to-turn-off-only-full-group-by.html)

If you are on shared hosting, you need to check with your host.

Thank you

Hello, well they changed me to an earlier version MySql and I now get passed the last page.
But I only see an login page without any css, which after login with the given user and pw, I get back to the login.
Also noticed that after setting lo_threshold to "1", I get nomore errors updated.

My last error after a new install is:

<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

ERROR - 2020-06-01 14:03:24 --> Severity: Warning --> mysqli::real_connect(): (HY000/2002): No such file or directory /NAS1/vhosts/JZ2037/verygood.pt/public_www/lib/database/drivers/mysqli/mysqli_driver.php 203
ERROR - 2020-06-01 14:03:24 --> Unable to connect to the database
ERROR - 2020-06-01 14:03:24 --> Severity: Warning --> mysqli::real_connect(): (HY000/2002): No such file or directory /NAS1/vhosts/JZ2037/verygood.pt/public_www/lib/database/drivers/mysqli/mysqli_driver.php 203
ERROR - 2020-06-01 14:03:24 --> Severity: Warning --> session_start(): Failed to initialize storage module: user (path: ) /NAS1/vhosts/JZ2037/verygood.pt/public_www/lib/libraries/Session/Session.php 143
ERROR - 2020-06-01 14:03:24 --> Severity: Warning --> mysqli::real_connect(): (HY000/2002): No such file or directory /NAS1/vhosts/JZ2037/verygood.pt/public_www/lib/database/drivers/mysqli/mysqli_driver.php 203
ERROR - 2020-06-01 14:03:24 --> Unable to connect to the database
ERROR - 2020-06-01 14:03:24 --> Query error: No such file or directory - Invalid query: SELECT *
FROM `tec_settings`
ERROR - 2020-06-01 14:03:24 --> Severity: error --> Exception: Call to a member function num_rows() on boolean /NAS1/vhosts/JZ2037/verygood.pt/public_www/app/models/Settings_model.php 220

What is strange to me is when I try the login , it points to:
verygood.pt/login?wp-checked=1#register.

It gets me nowhere. and what is wp-checked. I have nothing with wordpress, but I had wordpress before and deleted all files from the server.
I still have faith we will get there., but I am running out of clues.

Wait wait wait,
I changed some stuff in config.php as per install docs.
Apparently after so many reinstalls, the revised config file was not uploaded.
So now I have my css . So for now it works and I can start building a site.
Thanks for all the help and I hope I don't have too many other questions.
Thanks again
Hans

So you are saying that it's working for now. I am glad to listen.

No. It's totally fine. You can ask questions, id you have any issue or don't understand any part of the app.

Thank you

Hello,
Yes the site is working apart from the following:
I made 5 categories, identical setup (checked in the dbase)
When I enter the website verygood.pt , also without login, and I select one of the three categories wich do have a thread, I can see the threads in only one of the cats (kookclub) while the other two show there are no threads to display. I cannot figure out why. Hope you can.
I also have a few more issues, but I think one at a time.
Thank you.