Install of Flarum asks for Table Prefix

[MrCaspan]

After some testing it seems that Flarum no longer uses FLA_ as default for their table prefixes. You get to choose (See below screen grab of installer) you might need to add the table prefix as a flag option for target and source. I did a test and removed FLA_ form the src/Target/Flarum.php in the few different spots and it seems to have worked. Sorry to find all these issues man... Just want to help others make sure they can port away from Vanilla easily. Either that you need to tell users to make sure they use FLA_ as their table prefix during install!

[Unresponsive]

I just tried porting my forum to Flarum and was wondering why NitroPorter creates a bunch of tables with FLA_ prefix if my Flarum tables don't have it.

[MrCaspan]

What is the command you are using to run Nitro Porter and what version are you running

[MrCaspan]

Sorry... so it seems the porter creates FLA_ tables by default and it's hard coded in.

Because of this, you have two options

1: install your Flarum with a FLA_ table prefix
2: If you are like me and you didn't want ANY table prefix, you will need to do global search the src folder for FLA_ and remove it, or replace it with the table prefix that you want.

I'm just getting started for the day so give me a bit and I will let you know what files and line numbers need to be updated.

Linc has been doing a great job managing this project but seems like that have a bunch going on and have not got around to this!

[MrCaspan]

src\Target\Flarum.php (5 hits)
	Line  24:         'prefix' => 'FLA_',
	Line  65:             'FLA_posts_discussion_id_number_unique' => [
	Line  69:             'FLA_posts_id_primary' => [
	Line  98:             'FLA_discussions_id_primary' => [
	Line 419:                 'FLA_discussion_user_discussion_id_foreign' => [

If you update those lines to be

src\Target\Flarum.php (5 hits)
	Line  24:         'prefix' => '',
	Line  65:             'posts_discussion_id_number_unique' => [
	Line  69:             'posts_id_primary' => [
	Line  98:             'discussions_id_primary' => [
	Line 419:                 'discussion_user_discussion_id_foreign' => [

This should port with no FLA_ table prefixes.. I cannot guarantee you that this might break something else but I ported my Vanilla3 to Flarum with only some small issues. I did have an issue that the post that shows under a discission title was off and I have no idea if this was the cause but it was more important to get the data over and ill fix small issues like that later!

There is a also a src\source\Flarum.php that also has FLA_ in it but that is when you choose Flarum being the source of the migration, in this case we only care about Flarum being the target of the migration

Hope this helps.. I just did a major migration of my forum so please feel free to ask questions if you have any!

[Unresponsive]

Thanks, @MrCaspan! Yes, I figured I just need to remove FLA_ from target files. Thanks for confirming that worked for you!

[Unresponsive]

Actually table structures for Flarum 1.8.9 created tables and NitroPorter FLA_ tables differ significantly, so I will probably leave the prefix and then carefully move the data between these using queries.

[MrCaspan]

I just did a port like 3 weeks ago to 1.8.9 and so far I have had no real large issues other then the one thing which was on the discussion page it should show you the last post unread under a the title of the discussion . It was more important to get my data off Vanilla3.

What has changed that you see?