Hi,
I wonder if you can shed some light on the following problem.
One month ago I migrated my forum from a simple:Press platform to the wpForo platform. I used the Go2wpForo plugin to achieve the migration.
Everything went smoothly and the wpForo system was working.
However I've noticed I have been left with one problem
Although all my previous attachments under the simple:press installation show in the wpForo posts, they are non-clickable thumbnails, in other words they are no longer single click to-view. What my members and guests have to do now is "Right-Click" | "View Image" to see the enlarged image.
Obviously any new attached images to posts are fine as they are controlled by the wpForo attach image plugin and are simple click-to-view.
So to my question :
Is there any way to make all the old migrated images single click-to-view. I'm not expecting them to be available via the wpForo plugin, just a way to make them easy to view rather than the "Right-Click" | "View Image" method.
Hope that I've explained that if not here is a post on the form to demonstrate. The images cannot be clicked on to view only "Right-Click" | "View Image".
If there's nothing I can do then I will live with it but it would be nice to fix as then the migration would have been 100% instead of 99%.
Ok, I see the problem. We're going to find some solution for such cases. I'll update soon.
Thanks Tom, appreciate that.
p.s.
Since the migration I dare not delete or uninstall the simple:press installation as the Go2wpForo plugin did not import the images into wpForo. It appears to have just left them in place and linked the images to the simple:press file system.
Yes, those are linked. The migrator tool doesn't move files. This is not a database data to migrate, files can be left in the same folder. This folder is located in /wp-content/uploads/ directory, it's safe. They should not be deleted if you deactivate Simple:Press and delete Simple:Press database.
Please backup _wpforo_posts table, or the whole database. Then download attached tool. Install it in Dashboard > Plugins admin page (use plugin uploading method).
Then navigate to wpForo Img2Link menu and click on [Start Conversion] button. It may take a few minutes. Please, don't run this converter twice.
Hi Tom,
wow that was quick!
Can I just check that this will only effect changes to the images that are/were simple:press images without links, and not any images that have since been added via the wpForo advanced attachments add-on.
Yes, the wpForo Advance Attachment addon doesn't add image or image link in content, it only inserts bbcode like [ attach ] 888 [ / attach ]. So those will not be affected. Only single images will be replaced to images with links. In any case please don't forget to backup _wpforo_posts table.
Hi Tom,
that worked all the unlinked images are now linked. The only thing I've noticed is the posts that had unlinked images now have spurious \r\n tags in the posts any quoted comments have them too.
You can see for yourself from the link provided in post #1
Other than that, excellent! I'm very pleased, thanks.
Despite that post example above seeming OK with just the spurious characters, members have reported other older posts are total mess. I'm going to now have to recover.
I've not had to do this before Gulp! Now wishing I had left well alone, this is the trouble with chasing that final bit of perfection.
Thank god I had updraft installed as that made it very simple to do.
Hi radiostv,
It seems our time-zone is different and we couldn't check it on time. The tool I've provided doesn't have post deleting functions, it's just impossible. I think there was caching problem. Could you please send admin login details to support[at]gvectors.com? We'll do this conversion ourselves?
Hi radiostv,
It seems our time-zone is different [..]
Yes I'm in the U.K. I take it you're U.S.A.
Hi radiostv,
[..] The tool I've provided doesn't have post deleting functions, it's just impossible.
Hi Tom, not sure I understand, I did not suggest anything had been deleted.
What had occurred was the affected posts has spurious characters spread throughout them. These characters were "/r/r/n/r/n". The worst case being a thread had all its bullet points corrupted and formatting corrupted as a result. Also post quotes within posts were also full of the spurious characters too.
Hi radiostv,
I think there was caching problem.
I don't have any caching plugins installed, or do you mean wpForo caching?
Hi radiostv,
Could you please send admin login details to support[at]gvectors.com? We'll do this conversion ourselves?
I took a backup of the entire site Db as you suggested prior to running your php script/plugin. When it was clear I needed to recover, to my horror I discovered my hosts seem to be denying me ssh( telnet) access to my server. Equally scary was I could not run the Db recovery from the Cpanel as the dump I took was an unzipped sql dump and it exceeded the Cpanel limit.
Thankfully I have updraft installed so the only course I seemed to have open to me was a Db recovery to 09:00 of that morning. This meant I lost my members posts between 09:00 and 20:00 that evening. Thankfully it was a quiet day, had it been the previous day it would have been around 100 posts lost rather than just the handful I did lose.
As a result I've now installed a Database backup/recovery plugin Wp-Dbmanager which will make life easier for me to take quick Db backups and restore easily if needed.
I can certainly provide login details as you request, I'm just concerned I don't lose anything or cause any further disruption or loss of service to my members.
Please note, only wpforo_posts table is being used by this plugin. You don't need to backup and restore whole database. Other content is not affected. We'll check this plugin again to see what's wrong with \r\n symbols.
Please note, only wpforo_posts table is being used by this plugin. You don't need to backup and restore whole database.
Yep completely understand that, I was just taking a "belt and braces" approach. In hindsight that was not the correct approach in light of no terminal access and cpanel sql dump size restriction, but at the time I didn't know that.
I rolled back due to so many posts looking a mess. I'm a recent migration from simple:press to wpForo, so 90% of the forums posts have attachments unlinked and therefore would be affected by the script. I had little choice but to roll back.
If you want I can send you the Db to your support e-mail to have a look at it.
p.s.
The script did do what it was meant to do all the unlinked photos were linked but at the expense of post formatting. The spurious \r\n delimiters as I say seemed to effect post quotes, bullet points and other post formatting.
Please Deactivate and delete current version of wpForo - Image to Image Link Converter tool. Then backup the wpforo_posts table, then unzip the backup file (unzip it and check if the zip is not corrupted). Then install the attached tool and convert again. if you got the same problem please don't worry, we can clean this via dashboard. Just send admin login details or converted table backup file to support[at]gvectors.com email address.
Hi Tom,
Happy to report the new script has successfully completed and there is zero post corruption. Perfect!
Many thanks
Chris
Great!
Thank you for letting us know.