Hi -
This issue should now be resolved.
Regards,
Dave
> On Nov 28, 2018, at 2:16 AM, Carlo Salvagno <ca.sa...@libero.it.INVALID>
> wrote:
>
> I confirm this issue in Italian forum.
>
> ciao
>
> charlie
>
>
> Il 28/11/18 09:15, David Robley ha scritto:
>> There is an issue with Search and returning topics. To reproduce:
>> Go to advanced search
>> Enter a search term(s) - I used spell check error
>> Scroll down and choose Display results as: Topics
>> Leave all other settings and click Search
>>
>> Result:
>>
>> 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 ('+spell
>> +check +error ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY
>> t.topic_last_post_time DESC LIMIT 250
>>
>> BACKTRACE
>>
>> FILE: x1/var_lib_phpBB/com309/includes/db/mysqli.php
>>
>> LINE: 163
>>
>> CALL: dbal->sql_error()
>>
>> FILE: x1/var_lib_phpBB/com309/includes/db/mysqli.php
>>
>> LINE: 205
>>
>> CALL: dbal_mysqli->sql_query()
>>
>> FILE: x1/var_lib_phpBB/com309/includes/db/dbal.php
>>
>> LINE: 170
>>
>> CALL: dbal_mysqli->_sql_query_limit()
>>
>> FILE: x1/var_lib_phpBB/com309/includes/search/fulltext_mysql.php
>>
>> LINE: 472
>>
>> CALL: dbal->sql_query_limit()
>>
>> FILE: x1/var_lib_phpBB/com309/search.php
>>
>> LINE: 508
>>
>> CALL: fulltext_mysql->keyword_search()
>>
>> -------------------------
>>
>> As an aside, would it be possible to have the search default to Display as
>> Topics? This returns a more compact listing of the results which seems to me
>> to be easier to work through.
>>
>> On 27/11/18 10:40 am, Dave Fisher wrote:
>>> Hi Hagar / Forum Admins,
>>>
>>> We must do a forum migration to new VMs by Friday, November 30th.
>>>
>>> It turns out that many of the errors we had in June testing are due to
>>> incompatibilities between PHP 7 and phpBB 3.0.x and 3.1.x. Specifically
>>> BBCodes use a php method that is no longer supported in PHP 7.
>>>
>>> In order for me to better perform the migration I need you to grant my ID
>>> (dave2wave) full admin rights on both the current production and also forum
>>> test.
>>>
>>> Also, please provide to me the email addresses to each forums admins so
>>> that I can provide any setup instructions.
>>>
>>> I am in the San Francisco area and will be online by 16:00 UTC.
>>>
>>> Regards,
>>> Dave
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>>>
>>>
>>
>> Cheers
>
>
> ---------------------------------------------------------------------
> 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
