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
