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
>>>
>>>
>
signature.asc
Description: Message signed with OpenPGP
