Beta8 install - SQLSTATE[HY000]: General error: 1005

naj

Attempting to install beta8 using composer create-project flarum/flarum . --stability=beta
No issues installing beta 7 prior, but having issues with beta 8. Likely due to 10.2.19-MariaDB
Any tips/ideas/solutions?

VPS
Apache 2.4.37
PHP 7.2.12
MySQL 10.2.19-MariaDB

Error during Flarum install:

Something went wrong: SQLSTATE[HY000]: General error: 1005 Can't create table stest_flarum.#sql-22fa_2236 (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table posts add constraint posts_user_id_foreign foreign key (user_id) references users (id) on delete set null)

Running SHOW ENGINE INNODB STATUS
LATEST FOREIGN KEY ERROR

2018-11-28 21:33:26 0x7f5ad4b98700 Error in foreign key constraint of table stest_flarum.posts:
Alter table stest_flarum.posts with foreign key constraint failed. Referenced table stest_flarum.users not found in the data dictionary near ' foreign key (user_id) references users (id) on delete set null'.

Resolved: Check mysql default engine. If MyISAM, change default to innodb.
Default engine was MyISAM, Changed my.cnf --> default-storage-engine=innodb

Toby

naj ralphskie Can you please check the following things for me:

Table engine of posts and users (InnoDB?)
Column types of posts.user_id and users.id

ralphskie

same here:
PHP 7.2
MySQL 5.7+
Database is utf8mb4_unicode_ci

ralphskie

Toby
posts = innodb
users = myisam

posts.user_id = int
users.id = int

Toby

ralphskie What is your default MySQL table engine?

ralphskie

Toby
set default engine was MyISAM, I commented it so it will use the default engine on MySQL version 5.7+ which is INNODB.
test install again, and it works fine.

so I guess INNODB must be the Database engine before installing 👍️

naj

ralphskie Thanks! Fixed the issue.

set default engine was MyISAM, I commented it so it will use the default engine on MySQL version 5.7+ which is INNODB.
test install again, and it works fine.

Pirat

It is probably worth fixing the errors associated with the version of PHP 7.2 people sometimes do not read the installation document completely

Or make a version check before installing

luceos

Pirat beta 8 works perfectly fine on php 7.2: I'd even recommend it over any previous versions.

Qiaeru

I confirm, InnoDB have to be set as default engine, because MyISAM don't work.

HalilEsen

i having the same problem.

and I did not backup db 😢

Toby

HalilEsen You'll need to manually change the tables in your database to use the InnoDB engine. Backup your database before you do this. Always backup your database before upgrading Flarum, especially while it's still in beta.

HalilEsen

Toby thank you.

only users table engine problem. 😅 now work forum and backup database

Chris89

Toby Just did that and it fixed the error. I managed to update to Beta 8, but getting a core.views.content.load_error_message on the homepage now, together with a header. Everything else is blank.

Kyrne

Chris89 please start a new discussion so we can separate the issues for lurkers.

dodancs

Chris89 How did you please solve this issue? I'm getting the same error, nothing in the PHP error log, only the header is displayed and a message core.views.content.load_error_message.

neoblizz

Having the same problem, I am trying to set up my Flarum install on a shared web hosting service, and I am not sure if I have the leverage to edit the mysql settings to use InnoDB as the default. Is there a work around to this? If not, can I possibly use the older version instead (beta7 -- assuming I won't run into this issue)?

My provider has the following settings:

default storage engine=  MyISAM
default tmp storage engine=  InnoDB

Kyrne

neoblizz You will need to use InnoDB in order for the migrations to run and for you to update to beta 8.

neoblizz

I am not migrating from anything though, it is a new install entirely. Would I still need InnoDB for that?

Kyrne

neoblizz Yes, Innodb is required for beta 8, regardless or whether you are updating or installing anew.