However such things could (IMO should) be noted in upcoming maintenance (i.e. scheduled downtime)
On 10 January 2018 at 09:53, Greg Stein <gst...@gmail.com> wrote: > status.apache.org reports services that are *down*, rather than individual > bugs/problems. > > Thanks, > -g > > On Wed, Jan 10, 2018 at 2:03 AM, FR web forum <ooofo...@free.fr> wrote: >> >> I note that give you this information next time >> Why these outages are not reported in http://status.apache.org >> >> >> ----- Mail original ----- >> > De: "Chris Lambertus" <c...@apache.org> >> > À: priv...@infra.apache.org >> > Cc: "Andrea Pescetti" <pesce...@apache.org>, dev@openoffice.apache.org >> > Envoyé: Mercredi 10 Janvier 2018 03:22:04 >> > Objet: Re: ooo-forums downtime >> > >> > >> > I’ve pushed a change which fixes this on the database side. I also >> > saw the email about the forum being down yesterday, but it was a >> > transient problem. It would be helpful for me to know what the start >> > time and duration was for any future reports of slowness or outages. >> > >> > -Chris >> > >> > >> > >> > >> > >> > >> > >> > > On Jan 4, 2018, at 5:49 PM, Chris Lambertus <c...@apache.org> wrote: >> > > >> > > >> > > There may not be anything we can do about this until phpBB is >> > > upgraded. >> > > >> > > I put the wiki database move on hold until I can look into it more. >> > > >> > > >> > >> On Jan 4, 2018, at 2:42 PM, Andrea Pescetti <pesce...@apache.org> >> > >> wrote: >> > >> >> > >> CCing Chris for the two messages below. Maybe a SQL version issue? >> > >> Regards, >> > >> Andrea. >> > >> >> > >> On 04/01/2018 21:59, Hagar Delest wrote: >> > >>> Note: same for the other languages (Italian anf French tested). >> > >>> >> > >>> The DISTINCT 3065 thing seems a common one: >> > >>> >> > >>> In French forum: >> > >>> Erreur générale >> > >>> SQL ERROR [ mysqli ] >> > >>> >> > >>> Expression #1 of ORDER BY clause is not in SELECT list, >> > >>> references >> > >>> column 'forumaoo_fr.t.topic_last_post_time' which is not in >> > >>> SELECT list; >> > >>> this is incompatible with DISTINCT [3065] >> > >>> >> > >>> And in Italian: >> > >>> SQL ERROR [ mysqli ] >> > >>> >> > >>> Expression #1 of ORDER BY clause is not in SELECT list, >> > >>> references >> > >>> column 'forumaoo_it.t.topic_last_post_time' which is not in >> > >>> SELECT list; >> > >>> this is incompatible with DISTINCT [3065] >> > >>> >> > >>> Hagar >> > >>> >> > >>> >> > >>> Le 04/01/2018 à 21:33, Hagar Delest a écrit : >> > >>>> Hi, >> > >>>> >> > >>>> Since the move, we noticed that when performing an advanced >> > >>>> search >> > >>>> that should display the results as topics, then we get an error: >> > >>>> >> > >>>> General Error >> > >>>> SQL ERROR [ mysqli ] >> > >>>> >> > >>>> Expression #1 of ORDER BY clause is not in SELECT list, >> > >>>> references >> > >>>> column 'forumaoo_en.t.topic_last_post_time' which is not in >> > >>>> SELECT >> > >>>> list; this is incompatible with DISTINCT [3065] >> > >>>> >> > >>>> SQL >> > >>>> >> > >>>> SELECT DISTINCT SQL_CALC_FOUND_ROWS t.topic_id FROM >> > >>>> phpbb_en_topics t, >> > >>>> phpbb_en_posts p WHERE MATCH (p.post_subject, p.post_text) >> > >>>> AGAINST >> > >>>> ('+solved ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER >> > >>>> BY >> > >>>> t.topic_last_post_time DESC LIMIT 250 >> > >>>> >> > >>>> The same search is fine when set to display results as posts. >> > >>>> >> > >>>> Could you have a look please? >> > >>>> Thanks >> > >>>> >> > >>>> Hagar >> > >>>> >> > >>>> >> > >>>> Le 04/01/2018 à 03:30, Chris Lambertus a écrit : >> > >>>>>> On Jan 1, 2018, at 2:24 PM, Chris Lambertus <c...@apache.org> >> > >>>>>> wrote: >> > >>>>>> >> > >>>>>> Hi folks, >> > >>>>>> >> > >>>>>> At 0100 UTC on Thursday January 4th, I will be moving the >> > >>>>>> OpenOffice >> > >>>>>> PHPBB forum databases to a new server. The forums will be >> > >>>>>> offline >> > >>>>>> during this process, and is expected to take about 2 hours. >> > >>>>>> >> > >>>>>> -Chris >> > >>>>>> ASF Infra >> > >>>>>> >> > >>>>>> >> > >>>>> >> > >>>>> Hi all, >> > >>>>> >> > >>>>> This move has been completed. Spot checks on the forums look >> > >>>>> good. >> > >>>>> >> > >>>>> -Chris >> > >>>>> >> > >>>> >> > >>> >> > >>> >> > >>> >> > >>> --------------------------------------------------------------------- >> > >>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org >> > >>> For additional commands, e-mail: dev-h...@openoffice.apache.org >> > >>> >> > >>> >> > > >> > >> > > > --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
