postimage.org

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
VeganFanatic
Registered User
Posts: 191
Joined: Mon Sep 08, 2008 8:27 pm
Location: Victoria, BC Canada
Contact:

postimage.org

Post 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
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: postimage.org

Post 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.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
KYPREO
Registered User
Posts: 392
Joined: Fri Feb 02, 2018 9:56 am
Contact:

Re: postimage.org

Post by KYPREO »

The embedded postimage.org links on my board appear to be working. Perhaps they have since put a redirect in place?
phpBB user since 2002
www.AusRotary.com
User avatar
potku
Registered User
Posts: 980
Joined: Wed Dec 22, 2004 10:26 pm
Location: Tampere, Finland
Contact:

Re: postimage.org

Post 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? :)
Potku.net

"Before I speak, I have something important to say."

- Groucho Marx
postimage
Registered User
Posts: 29
Joined: Sat Jul 02, 2016 11:32 am

Re: postimage.org

Post 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');
Last edited by postimage on Sat Apr 14, 2018 6:54 am, edited 1 time in total.
User avatar
AmigoJack
Registered User
Posts: 6108
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: postimage.org

Post by AmigoJack »

postimage wrote: Thu Apr 12, 2018 5:49 pmCorrect 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.
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
kevin08
Registered User
Posts: 1
Joined: Mon May 07, 2018 10:34 am

Re: postimage.org

Post by kevin08 »

Does anyone have a suggestion on other free/anonymous services for posting board images?
Aquí hay una lista de frases de día de muertos que puede considerar escribir en el interior de las tarjetas Día de los muertos
User avatar
AmigoJack
Registered User
Posts: 6108
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: postimage.org

Post by AmigoJack »

  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
User avatar
</Solidjeuh>
Registered User
Posts: 1788
Joined: Tue Mar 29, 2016 3:45 am
Location: Aalst (Belgium)
Name: Andy Dm
Contact:

Re: postimage.org

Post 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
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 5871
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: postimage.org

Post 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 !
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
User avatar
</Solidjeuh>
Registered User
Posts: 1788
Joined: Tue Mar 29, 2016 3:45 am
Location: Aalst (Belgium)
Name: Andy Dm
Contact:

Re: postimage.org

Post 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 :)
User avatar
paulvill76
Registered User
Posts: 83
Joined: Tue Dec 06, 2011 2:51 am
Location: Brno , Czech Republic
Name: Pablo Villaronga
Contact:

Re: postimage.org

Post 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'
);
.m.
Registered User
Posts: 539
Joined: Wed Nov 04, 2009 8:39 pm

Re: postimage.org

Post 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');
Post Reply

Return to “[3.2.x] Support Forum”