SQLSTATE[HY000]: General error: 1005 Can't create table

KolaBilewu

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

clarkwinkelmann

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.

Chimi

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

KolaBilewu

clarkwinkelmann Thanks it has been fixed from my end

clarkwinkelmann

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

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

luceos

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!

bryantmilan

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.

KolaBilewu

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

bryantmilan

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.

KolaBilewu

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

clarkwinkelmann

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.

KolaBilewu

clarkwinkelmann Thanks for the reply
how do i do it as i am not a pro in css

clarkwinkelmann

KolaBilewu something like .IndexPage-toolbar .item-sort { display: none; } should do it.

KolaBilewu

clarkwinkelmann thanks