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 Wed, 27 Jun 2018 21:23:00 GMT
For the record, the custom search on the landing page works on the test forum (it is broken
since a while on the current page).

Some other comments here also: https://forum.openoffice.org/en/forum/viewtopic.php?f=102&t=94047
Problem with special characters in the password and sorting no applied (seems to affect several
features requiring a sorting).

Hagar

Le 25/06/2018 à 21:56, Hagar Delest a écrit :
> 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