I'm using the wpForo Advanced Attachments plugin. I like it, but all of the attachments get stored in the MySQL database which is starting to bog things down.
For my regular WordPress posts, I use a plugin that automatically stores any Media in my Amazon S3 bucket, keeping them out of my database which is really nice. It still stores all the metadata in MySQL, just not the files themselves which are the bulky part.
I'm trying to accomplish something similar with wpForo Advanced Attachments. I thought that maybe I could write a script to move files into my Amazon S3 bucket and then just change the wp_wpforo_attachments.fileurl value to the Amazon S3 value. But it's not working 🙁
I have a file that is currently sitting in two places:
But when I try updating the wp_wpforo_attachments.fileurl value in the database to the 2nd place like this ...
... the attachment no longer appears in the post. Any ideas how I can accomplish this?