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 > > >>> > > >>> > > > > > > > >
