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: 181
Joined: Mon Sep 08, 2008 8:27 pm
Location: Victoria, BC Canada
Contact:

postimage.org

Post by VeganFanatic » Wed Apr 11, 2018 5:53 pm

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: 50872
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: postimage.org

Post by stevemaury » Thu Apr 12, 2018 12:00 am

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.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

KYPREO
Registered User
Posts: 119
Joined: Fri Feb 02, 2018 9:56 am
Contact:

Re: postimage.org

Post by KYPREO » Thu Apr 12, 2018 4:53 am

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: 859
Joined: Wed Dec 22, 2004 10:26 pm
Location: Tampere, Finland
Contact:

Re: postimage.org

Post by potku » Thu Apr 12, 2018 5:25 am

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 » 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.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: 5639
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: postimage.org

Post by AmigoJack » Fri Apr 13, 2018 7:30 am

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.
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
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.

kevin08
Registered User
Posts: 1
Joined: Mon May 07, 2018 10:34 am

Re: postimage.org

Post by kevin08 » Mon May 07, 2018 10:42 am

Does anyone have a suggestion on other free/anonymous services for posting board images?
Dubai's Leading Doctor on Call Home Healthcare Services

User avatar
AmigoJack
Registered User
Posts: 5639
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: postimage.org

Post by AmigoJack » Mon May 07, 2018 10:53 am

The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
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.

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

Re: postimage.org

Post by </Solidjeuh> » Mon May 07, 2018 8:35 pm

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: 3341
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: postimage.org

Post by thecoalman » 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 !
“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: 1732
Joined: Tue Mar 29, 2016 3:45 am
Location: Aalst (Belgium)
Name: Andy Dm
Contact:

Re: postimage.org

Post by </Solidjeuh> » Mon May 07, 2018 11:44 pm

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: 78
Joined: Tue Dec 06, 2011 2:51 am
Location: Brno , Czech Republic
Name: Pablo Villaronga
Contact:

Re: postimage.org

Post by paulvill76 » Tue Mar 26, 2019 11:47 am

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: 438
Joined: Wed Nov 04, 2009 8:39 pm

Re: postimage.org

Post by .m. » Tue Mar 26, 2019 1:14 pm

@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”