phpBB 3.2 and PostgreSQL migration

Information, problems and conversation on anything and everything to do with Aura and these here boards.
Post Reply
User avatar
Chewi
Anti-Hero
Posts: 3505
Joined: Sat Jun 12, 2004 3:51 pm
Location: Edinburgh, Scotland

phpBB 3.2 and PostgreSQL migration

Post by Chewi » Wed Jan 25, 2017 11:31 pm

As you may have seen in the other thread, I'm going to get this place upgraded to phpBB 3.2. It's just been released and I'm now taking care of the phpBB package for Gentoo Linux.

I'd ideally like to only run PostgreSQL without MySQL in future, especially on the small ARM box I plan on using, so I've attempted to migrate the database. There's no official procedure for this so I just kinda winged it with FromMySqlToPostgreSql. I had to improve the code so that it would handle empty string values properly. I'll be submitting that change shortly. Yay open source. Upgrading over the years had also made the column order go slightly out of sync and the tool doesn't bother to check the column names so that needed fixing too. Only 3 tables were out. If I were to do it again, I'd reimport it into MySQL using the column names first.

So please scream if anything seems off. I don't want to do the 3.2 upgrade later and find it's all out of whack.
User avatar
kaos
Noble Warrior
Posts: 4088
Joined: Mon Jun 14, 2004 3:09 pm
Location: Atlanta, Ga

Re: phpBB 3.2 and PostgreSQL migration

Post by kaos » Fri Apr 14, 2017 5:31 pm

I dont see any dates on posts...

but im not even sure we ever had them.

Edit: Oh there they are
User avatar
Mik
Born under a bad sign
Posts: 3390
Joined: Mon Jun 14, 2004 8:44 am
Location: Beyond your borders
Contact:

Re: phpBB 3.2 and PostgreSQL migration

Post by Mik » Tue Apr 25, 2017 3:09 pm

top left above the avatar on each post.
User avatar
Chewi
Anti-Hero
Posts: 3505
Joined: Sat Jun 12, 2004 3:51 pm
Location: Edinburgh, Scotland

Re: phpBB 3.2 and PostgreSQL migration

Post by Chewi » Sat Jan 13, 2018 12:38 pm

Oookay so I may have broken the place for just shy of a whole year. I would have fixed it sooner but because the migration seemed to work initially and no one contacted me directly, I figured there was just some minor issue. It wasn't until I tried to post today that I realised how bad it was. :oops: I don't think any amount of breakages from Mik is ever going to top this so I will never accuse him of trying to feed the server with coke again. :mrgreen: He even correctly noted the issue in the Staff Forum, the database sequences hadn't been restored so it was trying to reuse old ID numbers.

The funny thing is that I've moved the forums across two machines since then, once back in May when I replaced my desktop with a new AMD Ryzen system (wooo fast!) and last night when I finally got around to moving the site to my Utilite Pro (wooo slow!) after years of talking about it. Despite being a major step down hardware-wise, I can't actually tell the difference.

Database breakage aside, you may have noticed (yeah, right) that the site was only available for hours at a time for the past few months. I had stopped leaving my desktop on 24/7 as there was no longer any great need for it. I'm not kidding when I say I have noticed the difference in my energy bills. Maybe less than £10 per month but still, it adds up. The Utilite only burns 8W at full pelt so this is being left on 24/7. It has already been my music player, IRC proxy, printer server, scanner server, time server, and a generally useful machine for a while now and it will be doing more soon. A great little workhorse!

Once I'm happy that it's definitely all working, I'll put out a fresh email to everyone.
User avatar
Mik
Born under a bad sign
Posts: 3390
Joined: Mon Jun 14, 2004 8:44 am
Location: Beyond your borders
Contact:

Re: phpBB 3.2 and PostgreSQL migration

Post by Mik » Sat Jan 13, 2018 8:53 pm

I break a lot of shit these days as I wear many hats in my company, so I got good at identifying how badly I fucked up and why.

I noticed it was offline a few months back but given that it's been dead for the best part of a decade I figured you'd just shuttered it forever, me and Kaos cybering in Discord was a fine substitute.
User avatar
kaos
Noble Warrior
Posts: 4088
Joined: Mon Jun 14, 2004 3:09 pm
Location: Atlanta, Ga

Re: phpBB 3.2 and PostgreSQL migration

Post by kaos » Wed Jan 24, 2018 10:44 pm

Mik wrote: me and Kaos....
Whoa....
I haven't been that guy in a very long time. almost didnt know who you were talking about.

Kaos and Killjoy Interactive...RIP

Plague and Plagueware....mostly Immortal.



Chewi wrote:no one contacted me directly
I wouldn't even know how. You're like an internet ghost.
User avatar
Chewi
Anti-Hero
Posts: 3505
Joined: Sat Jun 12, 2004 3:51 pm
Location: Edinburgh, Scotland

Re: phpBB 3.2 and PostgreSQL migration

Post by Chewi » Thu Jan 25, 2018 10:44 am

kaos wrote:Whoa....
I haven't been that guy in a very long time. almost didnt know who you were talking about.

Kaos and Killjoy Interactive...RIP

Plague and Plagueware....mostly Immortal.
That'll take some getting used to.
kaos wrote:I wouldn't even know how. You're like an internet ghost.
Pfft, just because I'm not on Facebook? Still on email, Hangouts, Skype, LinkedIn if you really must... or IRC if you know where to look. :P
User avatar
Shane
Not-A-Deserter
Posts: 811
Joined: Mon Jun 14, 2004 5:09 am
Location: Stuck in a coffee cup at the bottom of the sea.

Re: phpBB 3.2 and PostgreSQL migration

Post by Shane » Sun Jan 28, 2018 7:59 am

phpbb still needa add a note pad tho, those were fun.
User avatar
kaos
Noble Warrior
Posts: 4088
Joined: Mon Jun 14, 2004 3:09 pm
Location: Atlanta, Ga

Re: phpBB 3.2 and PostgreSQL migration

Post by kaos » Wed Feb 07, 2018 12:13 am

Chewi wrote:
kaos wrote:or IRC if you know where to look. :P
Porn channels
User avatar
Mik
Born under a bad sign
Posts: 3390
Joined: Mon Jun 14, 2004 8:44 am
Location: Beyond your borders
Contact:

Re: phpBB 3.2 and PostgreSQL migration

Post by Mik » Fri Feb 09, 2018 2:41 pm

I wish there was a "fuck off and die" option to Linkedin, too many random people from India want to add me, I think people take that with 22 more contacts you increase your job chances bullshit, it also told me I could apply to 200k a year jobs, sure I can linkedin, sure I can.
User avatar
kaos
Noble Warrior
Posts: 4088
Joined: Mon Jun 14, 2004 3:09 pm
Location: Atlanta, Ga

Re: phpBB 3.2 and PostgreSQL migration

Post by kaos » Fri Feb 09, 2018 9:51 pm

you can apply.
it wont mean anything, but you can do it.
User avatar
Chewi
Anti-Hero
Posts: 3505
Joined: Sat Jun 12, 2004 3:51 pm
Location: Edinburgh, Scotland

Re: phpBB 3.2 and PostgreSQL migration

Post by Chewi » Tue Jun 25, 2019 10:33 pm

Okay, so it only took me 2½ years to get around to the phpBB 3.2 bump. :lol: Now I can upgrade to phpBB 7. I'll do that tomorrow.... maybe.
User avatar
kaos
Noble Warrior
Posts: 4088
Joined: Mon Jun 14, 2004 3:09 pm
Location: Atlanta, Ga

Re: phpBB 3.2 and PostgreSQL migration

Post by kaos » Tue Jun 25, 2019 11:08 pm

Huzzah
User avatar
Chewi
Anti-Hero
Posts: 3505
Joined: Sat Jun 12, 2004 3:51 pm
Location: Edinburgh, Scotland

Re: phpBB 3.2 and PostgreSQL migration

Post by Chewi » Wed Jun 26, 2019 9:18 pm

Well damn, I actually did update to phpBB 7 when I said I would. It definitely seems faster. I've also fixed the all important smilies and added the two new ones we were missing. :geek: :ugeek: Made them look better with the dark theme too.
Post Reply