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
