Update went wrong

Benito

Thanks I tried but get this:
n Connection.php line 712:

SQLSTATE[HY000]: General error: 1005 Can't create table arxxxxxx_xxxxxxx87.post_mentions_tag (errno: 150 "Foreign key co
nstraint is incorrectly formed") (SQL: alter table post_mentions_tag add constraint post_mentions_tag_mentions_tag_id_foreign foreign key (mentions_tag_id) references tags (id) on delete cascade)

In Exception.php line 18:

SQLSTATE[HY000]: General error: 1005 Can't create table arxxxxxx_xxxxxxx87.post_mentions_tag (errno: 150 "Foreign key co
nstraint is incorrectly formed")

In PDOStatement.php line 117:

SQLSTATE[HY000]: General error: 1005 Can't create table arxxxxxx_xxxxxxx87.post_mentions_tag (errno: 150 "Foreign key co
nstraint is incorrectly formed")

Based on this error I have found this:
https://mazer.dev/en/laravel/troubleshooting/laravel-migration-foreign-key-incorrectly-formed/#:~:text=Sometimes%20when%20running%20a%20Laravel,key%20column%20on%20source%20table.

Are you sure the migration is correctly written? I will check it out now.

luceos

Please post your MySQL Version.

Benito

luceos

Ok I have found the issue, I had a mix of MyISAM and Innodb tables. No idea why because I have always followed your installations perfectly(and I work with Laravel too)

I had to change all these tables:

Make sure you first delete the table causing the issue first if you see something like "table already exists"

ALTER TABLE post_mentions_user ENGINE = InnoDB;
ALTER TABLE tags ENGINE = InnoDB;
ALTER TABLE tag_user ENGINE = InnoDB;
ALTER TABLE post_mentions_user ENGINE = InnoDB;
ALTER TABLE post_likes ENGINE = InnoDB;
ALTER TABLE flags ENGINE = InnoDB;
ALTER TABLE discussion_tag ENGINE = InnoDB;
ALTER TABLE post_mentions_post ENGINE = InnoDB;

I deleted the table and reran the migration, all good.

I am not 100% sure about your file organisation as I did recognise it was not 100% a pure Laravel app but in Laravel usually I would add this in:
/config/database.php to force InnoDB for every migration(just in case a host DB does not process the tables properly
'engine' => 'InnoDB',

This is my DB:
Server version: 10.6.13-MariaDB - MariaDB Server

Hope this helps!

Ben

luceos

Benito thanks Ben. Glad you figured it out. Seems somewhere we need to add a fix migration to force the table type.

dandan

Benito Thank you, Your solution worked after updating from 1.4 to 1.8 🙂

Benito

luceos Yes it looks like, Thanks again for your help!

Circa

This happened to me multiple times before as well, I ended up reverting to a backup each time. I'll have to try this solution next time I update.

luceos

Circa I ran into this with another instance and used Ben's queries to fix it. Make sure to delete the given table if it mentions "table already exists" after running the alter table queries.

xiahuan710

luceos I also have this question. Do you fix the error of this upgrade in the new upgrade program?

luceos

xiahuan710 I don't understand your question.

xiahuan710

luceos
Click on the update prompt as follows

Something went wrong: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'post_mentions_tag' already exists (SQL: create table post_mentions_tag (post_id int unsigned not null, mentions_tag_id int unsigned not null, created_at datetime default CURRENT_TIMESTAMP null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)

luceos

xiahuan710 drop the table in your database: post_mentions_tag using a database manager or run the query there (drop table post_mentions_tag;) then try again from the commandline using php flarum migrate.

Hadious15

luceos After dropping the table and running php flarum migrate
I am receiving this error :
SQLSTATE[HY000]: General error: 1005 Can't create table post_mentions_tag (errno: 150 "Foreign k
ey constraint is incorrectly formed") (SQL: alter table post_mentions_tag add constraint post_me ntions_tag_post_id_foreign foreign key (post_id) references posts (id) on delete cascade)

Benito

dandan you are welcome :-)