Page 1 of 1

postimage.org

Posted: Wed Apr 11, 2018 5:53 pm
by VeganFanatic
postimage.org had their domain blocked without notice, this has resulted massive problems with broken links

postimage has had to changed to the .cc to get images back in business

does phpBB have a tool or way to fix this kind of problem? I use wordpress and it alerted me to the problem immediately with a plugin

Re: postimage.org

Posted: Thu Apr 12, 2018 12:00 am
by stevemaury
Are you asking how to change all the postimage .org links in your database to postimage.cc links?

Magic urls (ones that go hot without [URL] tags) appear in the posts_text like this:

Code: Select all

http://www.old_domain.com
Those in the [URL] tags appear like this:

Code: Select all

http://www.old_domain.com
So, this query will fix both types:

Code: Select all

update phpbb_posts set post_text = replace(post_text, 'postimage.org', 'postimage.cc');
update phpbb_posts set post_text = replace(post_text, 'postimage.org', 'postimage.cc');
It may be necessary to then reparse the BBCode using the CLI. Backup the posts_text table first. If your table prefix is not [phpbb_ replace appropriately.

Re: postimage.org

Posted: Thu Apr 12, 2018 4:53 am
by KYPREO
The embedded postimage.org links on my board appear to be working. Perhaps they have since put a redirect in place?

Re: postimage.org

Posted: Thu Apr 12, 2018 5:25 am
by potku
On our site, old links (from just last week) do not work.

Their support has been lazy, so we are looking for an alternative anyway. Yes, phpBB has a good system for uploading this and that, but we have reserved that for registered members: only they can see uploads via the phpBB system.

Could anyone recommend an alternative? :)

Re: postimage.org

Posted: Thu Apr 12, 2018 5:49 pm
by postimage
Correct query to fix image URLs

Code: Select all

UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg.org', 'postimg.cc');
UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg.org', 'postimg.cc');

Re: postimage.org

Posted: Fri Apr 13, 2018 7:30 am
by AmigoJack
postimage wrote:
Thu Apr 12, 2018 5:49 pm
Correct query to fix image URLs
That was the least helpful post and it's also wrong in the majority of cases.

You'd also have to consider to update user signatures and PM texts. Also said website was accessible thru http://postimage.io/ and http://postimages.org/ long before (even http://postimage.org/ is accessible unlike the topic title indicates, only http://postimg.org/ is denied) - not sure why nobody mentioned that.

Re: postimage.org

Posted: Mon May 07, 2018 10:42 am
by kevin08
Does anyone have a suggestion on other free/anonymous services for posting board images?

Re: postimage.org

Posted: Mon May 07, 2018 10:53 am
by AmigoJack

Re: postimage.org

Posted: Mon May 07, 2018 8:35 pm
by </Solidjeuh>
postimage wrote:
Thu Apr 12, 2018 5:49 pm
Correct query to fix image URLs

Code: Select all

UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg.org', 'postimg.cc');
UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg&#46;org', 'postimg&#46;cc');

Code: Select all

UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg&#46;org', 'postimg&#46;cc');
This one is not working.

#1064 - There is something wrong with the used syntax ''postimg&#46)' in line 1

Re: postimage.org

Posted: Mon May 07, 2018 11:25 pm
by thecoalman
Froddelaar wrote:
Mon May 07, 2018 8:35 pm
This one is not working.

#1064 - There is something wrong with the used syntax ''postimg&#46)' in line 1
On the left hand bottom side of the window for the query is setting for the delimiter, change to something other than a semicolon that is not used in the query. ! should work, at the end of the query change the semicolon to a !

Re: postimage.org

Posted: Mon May 07, 2018 11:44 pm
by </Solidjeuh>
thecoalman wrote:
Mon May 07, 2018 11:25 pm
Froddelaar wrote:
Mon May 07, 2018 8:35 pm
This one is not working.

#1064 - There is something wrong with the used syntax ''postimg&#46)' in line 1
On the left hand bottom side of the window for the query is setting for the delimiter, change to something other than a semicolon that is not used in the query. ! should work, at the end of the query change the semicolon to a !
And that works! Thank you :)

Re: postimage.org

Posted: Tue Mar 26, 2019 11:47 am
by paulvill76
Thanks , I ran this

UPDATE
phpbb_posts
SET
post_text =
REPLACE
(
post_text,
'postimage.org',
'postimage.cc'
);
UPDATE
phpbb_posts
SET
post_text =
REPLACE
(
post_text,
'postimage&#46;org',
'postimage&#46;cc'
);

but nothing was replaced . in my case the old signature image was
https://postimg.org/RN8LDJkM

and should be replaced by
https://postimg.cc/RN8LDJkM

Can I add the whole line :

UPDATE
phpbb_posts
SET
post_text =
REPLACE
(
post_text,
'postimage.org',
'postimage.cc'
);
UPDATE
phpbb_posts
SET
post_text =
REPLACE
(
post_text,
'https://postimg.org/RN8LDJkM',
'https://postimg.cc/RN8LDJkM'
);

Re: postimage.org

Posted: Tue Mar 26, 2019 1:14 pm
by .m.
@paulvill76 , you can try using below queries [DB table is phpbb_users & field is user_sig]

Code: Select all

UPDATE `phpbb_users` SET `user_sig` = replace(user_sig, 'postimg.org', 'postimg.cc');
UPDATE `phpbb_users` SET `user_sig` = replace(user_sig, 'postimg&#46;org', 'postimg&#46;cc');