Moved to https, now how to update db internal links in posts??

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Scam Warning
User avatar
Lumpy Burgertushie
Registered User
Posts: 63643
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Moved to https, now how to update db internal links in posts??

Post by Lumpy Burgertushie » Fri Apr 07, 2017 3:26 pm

I would assume it is not too much of a strain on the server since there are sites with millions of pages that have been doing this for many years.

robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

User avatar
LP-1
Registered User
Posts: 7
Joined: Fri Apr 07, 2017 6:53 pm

Re: Moved to https, now how to update db internal links in posts??

Post by LP-1 » Fri Apr 07, 2017 8:29 pm

Lumpy Burgertushie wrote:
Thu Apr 06, 2017 3:53 pm
or, just leave it alone and use the htaccess redirect. nobody but you will ever know the difference.


robert
This is exactly why I'm coming for you. You don't know it yet, but one day soon you're gonna be my web guy. I'm one relevant post away from sending you a pm. And it's tough to say something relevant five different times on a board too advanced for my simple mind. One to go.

I think. Now I've lost count. Damn.
"Men show their character in nothing more clearly than by what they think laughable.

User avatar
3Di
Registered User
Posts: 12135
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT), Frankfurt (DE)
Name: Marco
Contact:

Re: Moved to https, now how to update db internal links in posts??

Post by 3Di » Fri Apr 07, 2017 8:34 pm

LP-1 wrote:
Fri Apr 07, 2017 8:29 pm
I think. Now I've lost count. Damn.
Because in some forum the user's post count doesn't increase. call it "settings on a per forum basis". ;)
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades

User avatar
LP-1
Registered User
Posts: 7
Joined: Fri Apr 07, 2017 6:53 pm

Re: Moved to https, now how to update db internal links in posts??

Post by LP-1 » Fri Apr 07, 2017 8:42 pm

I'm never gonna get to on that guy. But I'm gonna keep trying. :)
"Men show their character in nothing more clearly than by what they think laughable.

User avatar
Lumpy Burgertushie
Registered User
Posts: 63643
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Moved to https, now how to update db internal links in posts??

Post by Lumpy Burgertushie » Fri Apr 07, 2017 11:53 pm

I believe the rules also state that you have to be a member for 24 hours as well as have 5 approved posts before you can use the PM system.

if you really want to get in touch with me, you can go here:
http://phpbbace.com and register. you can then post in the support forum or just PM me there as you wish.

thanks,
robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

User avatar
LP-1
Registered User
Posts: 7
Joined: Fri Apr 07, 2017 6:53 pm

Re: Moved to https, now how to update db internal links in posts??

Post by LP-1 » Sun Apr 09, 2017 2:45 am

It's not from lack of trying. I can't find the register form on your site. Maybe my iPhone is blocking the link or something? That would be weird, but I can't think of another reason why it's not showing up?
"Men show their character in nothing more clearly than by what they think laughable.

User avatar
Lumpy Burgertushie
Registered User
Posts: 63643
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Moved to https, now how to update db internal links in posts??

Post by Lumpy Burgertushie » Sun Apr 09, 2017 3:59 am

boy do I feel like an idiot. I have registration turned off on that board because I never got around to upgrading it from 3.0.12
:oops: :oops:

try here: http://phpbbusers.com/3.1/

sorry about that.
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

User avatar
Froddelaar
Registered User
Posts: 586
Joined: Tue Mar 29, 2016 3:45 am
Location: Aalst (Belgium)
Name: Andy Dm
Contact:

Re: Moved to https, now how to update db internal links in posts??

Post by Froddelaar » Fri Apr 14, 2017 8:19 pm

Run database query to change URL's in forum posts

Code: Select all

update phpbb_posts set post_text = replace(post_text, 'http://www.froddelpower.be, 'https://www.froddelpower.be');
update phpbb_posts set post_text = replace(post_text, 'http://www.froddelpower.be', 'https://www.froddelpower.be');
Replace froddelpower be with your domain.
And always make a database backup before editing your database.
Wij promoten UW muziek in ons forum & delen alles via Sociale media!
Muziek wordt ook toegevoegd in de playlist van
textradio.be!
Mail uw single + hoesje + info naar: info@muziekpromo.net of Solidjeuh@textradio.be
===============
Onze Website: https://www.muziekpromo.net

Swanny
Registered User
Posts: 412
Joined: Sun Apr 14, 2002 2:11 am
Location: Canada

Re: Moved to https, now how to update db internal links in posts??

Post by Swanny » Fri Apr 14, 2017 9:55 pm

Froddelaar wrote:
Fri Apr 14, 2017 8:19 pm
Run database query to change URL's in forum posts...
Thanks

Post Reply

Return to “phpBB Discussion”

Who is online

Users browsing this forum: No registered users and 15 guests