I tried a search with "spell*" keyword and got the following error when display
results as topics (works fine as posts), no author specified:
General Error
SQL ERROR [ mysqli ]
Expression #1 of ORDER BY clause is not in SELECT list, references column
'forumaoo_en.u.username_clean' 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_users u, phpbb_en_posts p WHERE MATCH (p.post_subject, p.post_text)
AGAINST ('+spell ' IN BOOLEAN MODE) AND u.user_id = t.topic_poster AND
t.topic_id = p.topic_id ORDER BY u.username_clean ASC 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()
If I add an author, I get a slightly different one:
General Error
SQL ERROR [ mysqli ]
Expression #1 of ORDER BY clause is not in SELECT list, references column
'forumaoo_en.u.username_clean' 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_users u, phpbb_en_posts p WHERE MATCH (p.post_subject, p.post_text)
AGAINST ('+spell* ' IN BOOLEAN MODE) AND u.user_id = t.topic_poster AND
t.topic_id = p.topic_id AND p.forum_id NOT IN (5, 7, 8, 9, 10, 11, 12, 13, 18,
19, 20, 21, 25, 29, 30, 39, 40, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 54, 60,
61, 62, 64, 66, 67, 68, 69, 70, 71, 73, 74, 75, 76, 82, 83, 84, 85, 87, 88, 90,
91, 93, 94, 95, 96, 97, 98, 99, 100, 102, 103, 104, 105, 106, 107) AND
p.poster_id IN (62, 54431) ORDER BY u.username_clean ASC 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()
Note: in both cases, the wildcard * leads to the same result.
Hagar
Le 25/06/2018 à 17:15, Reizinger Zoltán a écrit :
Hi Dave,
Another problems:
The filters on forums not working:
Go to "View your posts" try to filter it. The filters not working in HU, EN
forum
Zoltan
2018.06.25. 13:33 keltezéssel, Reizinger Zoltán írta:
Hi Dave,
I run some test, on HU forum. I tried to create new post. I meet same isse as
Hagar, can not post.
Allways get the error, independently from post text lenght:
Your message contains too few characters.
My tests were on HU and EN forum, same errors.
Thanks,
Zoltan
2018.06.22. 21:18 keltezéssel, Dave Fisher írta:
Hi -
The new Forum VM is ready for testing at https://forum-test.openoffice.org/
The data on this update to date to roughly Noon EDT. 17:00 UTC.
Please make sure that you can do all the usual activity.
If all goes well this phase of testing will end on Tuesday at Noon EDT.
Regards,
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
