openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hagar Delest <delest.ha...@gmail.com>
Subject Re: [FORUMS] Please test forums
Date Mon, 25 Jun 2018 19:56:42 GMT
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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org


Mime
View raw message