luceos sazib what error? Please I cannot help you if you do not provide information that lets me debug the issue!
sazib luceos when i enter my db password, error showing this Something went wrong: SQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-9f3_ec29' (SQL: alter table group_permission add constraint group_permission_group_id_foreign foreign key (group_id) references groups (id) on delete cascade)
sazib ☹️ trying to install since 2018 but still can't install. can anyone help me to install, please . i don't want to use other forum software, i only like flarum so please help me
sazib here's my site when i enter db password showing error Something went wrong: SQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-9f3_ed3a' (SQL: alter table group_permission add constraint group_permission_group_id_foreign foreign key (group_id) references groups (id) on delete cascade)
luceos Please don't double post, let's stick to this discussion. Looks like the permissions are wrong, somehow you have a duplicate entry in group_permission. You can try truncating that table and then - once the upgrade succeeded - update the permissions again in the admin.
luceos sazib should i drop group_permission TABLE No truncate. Truncating empties the table and resets the auto increment. Dropping a table deletes the whole table.
clarkwinkelmann sazib the TRUNCATE option should be found under Operations in phpMyAdmin. Do not DROP. That will remove the table completely. TRUNCATE just deletes the content of the table.
sazib clarkwinkelmann i did as you said but still showing error Something went wrong: SQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-9f3_f757' (SQL: alter table group_permission add constraint group_permission_group_id_foreign foreign key (group_id) references groups (id) on delete cascade)
sazib still showing error Something went wrong: SQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-9f3_f25d' (SQL: alter table group_permission add constraint group_permission_group_id_foreign foreign key (group_id) references groups (id) on delete cascade)
luceos sazib my recommendation would be the following: In case you have no posts/discussions/users ; create a new forum, if the issue occurs again after a clean installation report back here. In case this is an existing, active forum I recommend getting assistance as you've shown no clear ability to resolve this yourself. Your use case is exactly why Flarum is in beta and states "do not use in production unless you can get your hands dirty to fix some issues". Last option would be to clear (truncate) all tables except those that hold important information like posts, discussions, users and discussion_tag; to know which ones would require information on all the tables in the database, therefor see previous item.