Install Flarum Error

nhok3296

The issue

Something went wrong: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (flarum.hehegroup_user, CONSTRAINT hehegroup_user_group_id_foreign FOREIGN KEY (group_id) REFERENCES hehegroups (id) ON DELETE CASCADE) (SQL: insert into hehegroup_user (user_id, group_id) values (1, 1))

Flarum information

Database: 10.11.6-MariaDB - Alpine Linux
PHP8.3

luceos

nhok3296 it seems the group doesn't exist in the database yet, is this a clean install using the web installer? If so, can you try installing using the php flarum install command through ssh/cli?

nhok3296

luceos
yes i installed cleanly by web, i see in database still have group table

nhok3296

luceos I use apache2 on windows, how can I access ssh?

nhok3296

luceos I used xampp to install and it was successful, then I uploaded the code to my home server, I changed the website url to my domain but when accessing it, it displays HTTP error 500, the home server only use https

luceos

nhok3296 use https://docs.flarum.org/troubleshoot; 500 errors are either logged in your webserver logs or in storage/logs of the flarum installation path. We will need the error to fully understand what's going on. However, a wild guess is that you used a different php version locally than on your remote server, or your file permissions are incorrect.

nhok3296

luceos yes your file permissions are incorrect, thankyou

nhok3296

luceos How should I set folder permissions to avoid unauthorized access? Currently I have to set it to 777 to be able to use it. When I try to set it to 775, the expansion doesn't work. Thank you

luceos

You need to chown the flarum directory and its contents to the user the website runs as from your webserver, sometimes this is www-data but it depends on the control panel, operating system and webserver software used.