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

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.

neoblizz

Is there any suggested work around? Like, say, can I create tables manually and update the local tables to InnoDB (and not change the global settings).

Kyrne

neoblizz I would have to know your host to give you detailed instructions, but as far as I know as long as the tables database/tables themselves are innodb you should be fine.

neoblizz

Kyrne I am using GoDaddy, it is unfortunate that they don't allow such a simple change. But it would be of immense help if you can tell me how I can get this working -- I am excited to use Flarum!

Kyrne

neoblizz It may take quite a few steps, come join us at https://flarum.org/chat and I'd be more than happy to walk you through it!

neogeo

What about this error?

PHP: 7.1.8
Database: MariaDB 5.5.60
Database is: utf8mb4_unicode_ci
default_storage_engine: InnoDB

Toby

neogeo Upgrade to MariaDB 10.0.5+

« Previous Page