Information, problems and conversation on anything and everything to do with Aura and these here boards.
Wed Jan 25, 2017 11:31 pm
Anti-Hero
User avatar
  • Joined: Sat Jun 12, 2004 3:51 pm
  • Posts: 3502
  • Location: Edinburgh, Scotland

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.

Fri Apr 14, 2017 5:31 pm
Noble Warrior
User avatar
  • Joined: Mon Jun 14, 2004 3:09 pm
  • Posts: 4087
  • Location: Atlanta, Ga

I dont see any dates on posts...

but im not even sure we ever had them.

Edit: Oh there they are

Tue Apr 25, 2017 3:09 pm
Mik
Born under a bad sign
User avatar
  • Joined: Mon Jun 14, 2004 8:44 am
  • Posts: 3390
  • Location: Beyond your borders

top left above the avatar on each post.

Sat Jan 13, 2018 12:38 pm
Anti-Hero
User avatar
  • Joined: Sat Jun 12, 2004 3:51 pm
  • Posts: 3502
  • Location: Edinburgh, Scotland

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.

Sat Jan 13, 2018 8:53 pm
Mik
Born under a bad sign
User avatar
  • Joined: Mon Jun 14, 2004 8:44 am
  • Posts: 3390
  • Location: Beyond your borders

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.

Wed Jan 24, 2018 10:44 pm
Noble Warrior
User avatar
  • Joined: Mon Jun 14, 2004 3:09 pm
  • Posts: 4087
  • Location: Atlanta, Ga

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.

Thu Jan 25, 2018 10:44 am
Anti-Hero
User avatar
  • Joined: Sat Jun 12, 2004 3:51 pm
  • Posts: 3502
  • Location: Edinburgh, Scotland

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

Sun Jan 28, 2018 7:59 am
Not-A-Deserter
User avatar
  • Joined: Mon Jun 14, 2004 5:09 am
  • Posts: 811
  • Location: Stuck in a coffee cup at the bottom of the sea.

phpbb still needa add a note pad tho, those were fun.

Wed Feb 07, 2018 12:13 am
Noble Warrior
User avatar
  • Joined: Mon Jun 14, 2004 3:09 pm
  • Posts: 4087
  • Location: Atlanta, Ga

Chewi wrote:
kaos wrote:or IRC if you know where to look. :P


Porn channels

Fri Feb 09, 2018 2:41 pm
Mik
Born under a bad sign
User avatar
  • Joined: Mon Jun 14, 2004 8:44 am
  • Posts: 3390
  • Location: Beyond your borders

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.

Fri Feb 09, 2018 9:51 pm
Noble Warrior
User avatar
  • Joined: Mon Jun 14, 2004 3:09 pm
  • Posts: 4087
  • Location: Atlanta, Ga

you can apply.
it wont mean anything, but you can do it.

Return to The Site


Who is online
  • Users browsing this forum: No registered users and 2 guests
cron