DB backup from Beta 7 to Beta 8

saifcoder

Hi, i know its my mistake, but i love Flarum and i use it in a production project.

I have Beta 7 work fine, i backup DB, then i create new folder and install Beta 8.

So, when i tray to install Beta 8 on DB Beta 7, this error show :

Something went wrong: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'xxxx_migrations' already exists (SQL: create table xxxx_migrations (migration varchar(255) not null, extension varchar(255) null) default character set utf8mb4 collate utf8mb4_unicode_ci engine = InnoDB)

I know, the installation script did't support upgrade from old DB, so i delete the DB!.

Now, i have Beta 8 work fine, but the forum is empty !

How to backup forums and discussions from Beta 7 to Beta 8 ?

P.S : If not possible my boss will kill me tonight.

Thanks,

luceos

saifcoder run php flarum migrate now

saifcoder

1 - Rename Beta 7 folder to MyFlarum_beta7_Backup
2 - Create new folder MyFlarum_beta8
3 - install fresh Flarum inside MyFlarum_beta8
4 - Goto browser test.com/MyFlarum_beta8/public
5 - chose an new tables prefix lik MyTable_Beta8_ (the same DB contain Beta 7)
6 - goto browser test.com/MyFlarum_beta8/public to make sure Flarum beta 8 work fine (Empty)
7 - copy config.php and assets folder from MyFlarum_beta7_Backup to MyFlarum_beta8/public
8 - run "composer update"
9 - run "php flarum migrate"
10 - run "php flarum cache:clear"

saifcoder

The problem is nothing to migrate ! whats wrong ?

test.com/myforum/config.php --> prefix is beta8
test.com/myforum/public/config.php --> prefix is beta7

Migrating Flarum...
Nothing to migrate.
Migrating extension: flarum-approval
Nothing to migrate.
Migrating extension: flarum-emoji
Nothing to migrate.
Migrating extension: flarum-flags
Nothing to migrate.
Migrating extension: flarum-likes
Nothing to migrate.
Migrating extension: flarum-lock
Nothing to migrate.
Migrating extension: flarum-mentions
Nothing to migrate.
Migrating extension: flarum-sticky
Nothing to migrate.
Migrating extension: flarum-subscriptions
Nothing to migrate.
Migrating extension: flarum-suspend
Nothing to migrate.
Migrating extension: flarum-tags
Nothing to migrate.
Publishing assets...
DONE.

saifcoder

I tray another way !

1 - Rename Beta 7 folder to MyFlarum_beta7_Backup
2 - Create new folder MyFlarum_beta8
3 - install fresh Flarum inside MyFlarum_beta8
4 - copy config.php and assets folder from MyFlarum_beta7_Backup to MyFlarum_beta8/public
5 - run "composer update"
6 - run "php flarum migrate"
7 - run "php flarum cache:clear"

The problem is with "php flarum migrate" now show :

Command "migrate" is not defined.

OrdinaryJellyfish

saifcoder Did you put config.php in MyFlarum_beta8/public?? It needs to be put outside of public, so move it to just MyFlarum_beta8 and try again.

saifcoder

Please help, i need fix this today.

katos

saifcoder please be patient with support requests. We are all volunteers here 😃

Let me take a look over your request when I have a little more time to sit and read t properly, and I’ll edit this post with my suggestions

saifcoder

katos Understood 😅
OrdinaryJellyfish I will tray now

katos

OrdinaryJellyfish good spot!

saifcoder

its seem the migration has done, the problem its was the config.php, but its look like there another problem 😅

$ php flarum migrate
Migrating Flarum...
Migrated: 2018_01_11_093900_change_access_tokens_columns
Migrated: 2018_01_11_094000_change_access_tokens_add_foreign_keys
Migrated: 2018_01_11_095000_change_api_keys_columns
Migrated: 2018_01_11_101800_rename_auth_tokens_to_registration_tokens
Migrated: 2018_01_11_102000_change_registration_tokens_rename_id_to_token
Migrated: 2018_01_11_102100_change_registration_tokens_created_at_to_datetime
Migrated: 2018_01_11_120604_change_posts_table_to_innodb
Migrated: 2018_01_11_155200_change_discussions_rename_columns
Migrated: 2018_01_11_155300_change_discussions_add_foreign_keys
Migrated: 2018_01_15_071700_rename_users_discussions_to_discussion_user
Migrated: 2018_01_15_071800_change_discussion_user_rename_columns
Migrated: 2018_01_15_071900_change_discussion_user_add_foreign_keys
Migrated: 2018_01_15_072600_change_email_tokens_rename_id_to_token
Migrated: 2018_01_15_072700_change_email_tokens_add_foreign_keys
Migrated: 2018_01_15_072800_change_email_tokens_created_at_to_datetime
Migrated: 2018_01_18_130400_rename_permissions_to_group_permission
Migrated: 2018_01_18_130500_change_group_permission_add_foreign_keys
Migrated: 2018_01_18_130600_rename_users_groups_to_group_user
Migrated: 2018_01_18_130700_change_group_user_add_foreign_keys
Migrated: 2018_01_18_133000_change_notifications_columns
Migrated: 2018_01_18_133100_change_notifications_add_foreign_keys
Migrated: 2018_01_18_134400_change_password_tokens_rename_id_to_token
Migrated: 2018_01_18_134500_change_password_tokens_add_foreign_keys
Migrated: 2018_01_18_134600_change_password_tokens_created_at_to_datetime
Migrated: 2018_01_18_135000_change_posts_rename_columns

In Connection.php line 664:

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table xxxx_posts add constraint xxxx_posts_user_id_foreign foreign key (user_id) references xxxx_users (id) on delete set null)

In PDOStatement.php line 119:
SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint

In PDOStatement.php line 117:
SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint

migrate

OrdinaryJellyfish

saifcoder What MySQL/MariaDB version are you running, and do you have InnoDB as the default MySQL engine?

katos

I suspect the collation is the issue
To find the specific error run this:

SHOW ENGINE INNODB STATUS;
And look in the LATEST FOREIGN KEY ERROR section.

saifcoder

PHP 7.3.4 (cli)
MySQL 5.6.43 (Default is MyISAM)

OrdinaryJellyfish

saifcoder Change the default to InnoDB if you can and try again.

saifcoder

Now the migration is done, but when visiting /public
this error is shown :

An error occurred while trying to load this page.
core.views.error.404_return_link

I thing is because the old one is www.test.com/forum, and the new one is www.test.com/forum/public

how to deal with ?

OrdinaryJellyfish

saifcoder Follow these instructions to remove the public folder from your URL. If you're still experiencing the problem afterwards, check storage/logs/flarum.log and your webserver's logs and tell us what they say.

saifcoder

before i start the instructions to remove public folder.. i found that config.php still pointing to test.com/forum, so i change it to test.com/forum/public, now work fine.

( i will edit this topic to help any one have the same error in the future )
😅

katos

Glad to hear that this is now working! I’ll go ahead and mark this as solved for you, but if you have anything else don’t hesitate to create a thread! 😃