Hello !
I just migrate the forum, and copy past the attachment too.
I have a problem.
The attachments are in media gallery ( dashboard > Media > forum Attachment ), but not in personnal windows attachment.
Why ?
Notifications
Clear all
Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed. We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
wpForo Advanced Attachments
5
Posts
2
Users
1
Reactions
1,769
Views
Oct 21, 2018 9:01 pm
4 Replies
Oct 21, 2018 9:50 pm
The problem is for old attachments files, not for new.
New files are fine.
Oct 21, 2018 11:00 pm
I found the problem, but I need a fastest solution for repair it.
In SQL Table, the table "wp_wpforo_attachments"
I need to change the name of "fileurl"
The last name was
fileurl = //domaine1/wp-content/uploads/wpforo/attachments/nomdufichier
And I need to be :
fileurl = //domaine2/wp-content/uploads/wpforo/attachments/nomdufichier
Do you know a sql request for change name of 5000 files faster ? and not 1 by 1 ?
Thank you !
Oct 22, 2018 2:19 pm
Just backup this table and execute this SQL in the database > SQL tab. Make sure wp_ prefix matchs to your table prefix and change the "olddomain.com" and "newdomain.com" to your original domains:
UPDATE `wp_wpforo_attachments` SET `fileurl` = REPLACE( `fileurl`, '//olddomain.com/', '//newdomain.com/' );
Oct 23, 2018 3:29 am
Thank you very much, I will try it soon.