Hi i have been having this error Something went wrong: SQLSTATE[HY000]: General error: 1005 Can't create table boluwatife_flarumdb.#sql-5e8_4a7 (errno: 121 "Duplicate key on write or update") (SQL: alter table tpnotifications add constraint tpnotifications_user_id_foreign foreign key (user_id) references tpusers (id) on delete cascade) thou i followed all above step, still same issue NOTE: This is a fresh installation

    KolaBilewu hi! Can you share details on your SQL server (MySQL/MariaDB) and version?

    Knowing the operating system/webserver or managed hosting name might also help us diagnose the issue.

        KolaBilewu great news! Can you maybe share what the issue was in case somebody else find this discussion in the future?

          I think the Xampp am using is too old to handle the new Flarum Version because when i installed on a live server the errors dissapeared

            KolaBilewu would you please share the database version of that XAMPP version so that we are able to better assist people in the future with a similar issue? That would be awesome!

              KolaBilewu I think the Xampp am using is too old to handle the new Flarum Version because when i installed on a live server the errors dissapeared

              I am using Xampp too and don't have any problems, everything is working normal.
              Try to update Xampp to the latest version, there is always new version available.

                  bryantmilan How do i remove public from my domain example Domain.com/public
                  have done all suggestions and now my website is showing blank

                      KolaBilewu How do i remove public from my domain example Domain.com/public
                      have done all suggestions and now my website is showing blank

                      Try following this tutorial, it helped me a lot.

                          bryantmilan Thanks @luceos @clarkwinkelmann is there a way to remove newest, latest, top and oldest filter from the homepage and have my own filters. i installed the frontpage plugin and thats only what i want to show on the homepage.. is there anyway around that like a css trick

                              KolaBilewu you can use CSS to hide the selector.

                              However I don't think there's any way to set those alternative filters as default filters from the Frontpage extension.

                                  2 months later

                                  KolaBilewu
                                  Something went wrong: SQLSTATE[HY000]: General error: 1005 Can't create tablechillifyflarumdb.discussions(errno: 121 "Duplicate key on write or update") (SQL: alter tablediscussionsadd constraintdiscussions_user_id_foreignforeign key (user_id) referencesusers(id) on delete set null)
                                  I have the same problem as mentioned above with using the WinNMP Adminer 4.7.7 4.7.8. If you have solved your problem can you share it with me?
                                  MarailDB version:10.4.17
                                  PHP version: 7.4