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
--
David Robley
A bird in the hand can be messy.
