Flarum Migration to 1.1.0 - SQL Error

caleb

I'm migrating Flarum 1.0.3 to 1.1.0 and hitting the following error:

Something went wrong: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'FUBAR_upload_files_actor_id_hide_from_media_manager_index' is too long (SQL: alter table FUBAR_upload_files add index FUBAR_upload_files_actor_id_hide_from_media_manager_index(actor_id, hide_from_media_manager))

(where 'FUBAR' is obfuscation since I'm posting publicly)

Is Opalstack running this latest version? Did you get hit by this issue and found a way around it?

sean

caleb this forum is running Flarum 1.1.0 and we did not encounter any problems with the upgrade from 1.0.

You might be able to work around it like so:

Uninstall the upload extension.
Upgrade Flarum.
Re-install the upload extension.

Be sure to back up your database prior to doing any of this!

caleb

Thanks sean that did the trick! I'm not able to re-install and turn on that extension without that issue. But it's a small forum and we can live without Upload for now.

sean

caleb That's weird because this forum is hosted on the Opalstack platform in the same manner as our customer sites, and we're using the upload extension with no trouble.

caleb

sean certainly weird, but considering I'm not quite devops, I'm willing to chalk it up to some quirk with how I installed. Not entirely sure what that would be - I don't think I did anything special...
If it's concerning to you, I'm happy to dive deeper into this, but I also don't want to waste your time on my small, hobby-project forum. I appreciate the help I've gotten already!

sean

caleb my best guess is that you've used a longer table name prefix when you set up Flarum and that's causing you to hit the identifier name length limit mentioned in the error message.

caleb

Closing the loop on this. Yup! the longer table name appears to have been the culprit. I rebuilt the database without the prefix and the upgrade went smooth.

Thanks again @sean !