Forum Outage. It is back online.

Forum Outage. It is back online.

Postby hagish » 17 Jun 2020, 21:00

A MySQL upgrade did not went as planned. We are now back to the old MySQL version. We will continue to investigate how we can upgrade without break think.
But for now the forum is back online.
It might go down for a shorter duration during the next days because one of the disks in the raid is starting to cause errors. We need to replace it.
User avatar
hagish
Global Moderator
 
Posts: 71
Joined: 08 Nov 2009, 22:53

Re: Forum Outage. It is back online.

Postby Julius » 17 Jun 2020, 21:11

Great! Thanks for fixing it. Sorry to hear that there are troubles with the MySQL version. Maybe the forum itself also needs an update for it to work with newer MySQL versions?
User avatar
Julius
Community Moderator
 
Posts: 3297
Joined: 06 Dec 2009, 14:02

Re: Forum Outage. It is back online.

Postby hagish » 17 Jun 2020, 21:14

We tried to move from 5. to 8. and this phpbb did not work with the 8. It would need to use a newer php version which itself probably means to upgrade to a recent phpbb version. So maybe we run 5. and 8. and figure out a way to migrate the pages that require 5. We will see.
User avatar
hagish
Global Moderator
 
Posts: 71
Joined: 08 Nov 2009, 22:53

Re: Forum Outage. It is back online.

Postby smcameron » 18 Jun 2020, 00:33

one of the disks in the raid is starting to cause errors. We need to replace it.


As someone who once upon a time worked on drivers for hardware RAID controllers and as someone who was once a system admin who stayed up all night restoring from tapes when a RAID rebuild did not go so well... I really hope you have a backup plan in case the RAID rebuild does not go so well.
smcameron
 
Posts: 377
Joined: 29 Oct 2010, 23:44

Re: Forum Outage. It is back online.

Postby freem » 18 Jun 2020, 02:35

I just want to thank you for the work. Can't do much more, but still: than you.
freem
BN Moderator
 
Posts: 106
Joined: 18 May 2015, 19:38

Re: Forum Outage. It is back online.

Postby GunChleoc » 20 Jun 2020, 09:50

Check if the forum uses mysql or mysqli as a backend. mysql will not work with modern versions of PHP and is too vulnerable against SQL injection.

If you want to upgrade the forum software, it will have to be done in incremental steps, because it is so old. Take it from one major version to the next with a corresponding php/mysql update. (e.g. upgrade to the latest version of phpBB2, then upgrade to phpBB 3.0, then phpBB 3.1, phpBB 3.2, with a matching corresponding php/mysql upgrade for each step).

Do you have any mods? I could help with finding replacements. E.g. for the links on top, you could use the "Buttons Menu" extension.
User avatar
GunChleoc
 
Posts: 502
Joined: 20 Sep 2012, 22:45

Re: Forum Outage. It is back online.

Postby ffaf » 22 Jun 2020, 19:51

I will post here too just to document the issue. tl;dr:
- go here: https://forum.freegamedev.net/memberlis ... ile&u=7078 ;
- click on «search user’s post»;
- you get some weird SQL error.

This happens whether I am logged in or not.
ffaf
 
Posts: 97
Joined: 04 Dec 2019, 08:59

Re: Forum Outage. It is back online.

Postby hagish » 24 Jun 2020, 16:39

Ok so now the broken disk in the raid got replaced and the raid is synchronizing it. During that period the page is probably slow.
User avatar
hagish
Global Moderator
 
Posts: 71
Joined: 08 Nov 2009, 22:53

Re: Forum Outage. It is back online.

Postby benau » 05 Jul 2020, 01:41

General Error
SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in SELECT list, references column 'fgd_phpbb.p.post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


I cannot search any post...
Image
benau
STK Moderator
 
Posts: 505
Joined: 08 Dec 2015, 17:32

Re: Forum Outage. It is back online.

Postby hagish » 08 Jul 2020, 18:36

I will try to take a look as soon as I have the time. I will keep this thread updated.
User avatar
hagish
Global Moderator
 
Posts: 71
Joined: 08 Nov 2009, 22:53

Who is online

Users browsing this forum: No registered users and 1 guest

cron