Re: Flyer-Entwurf zur Ansicht und für Änderungsvorschläge [War: Flyer]
Hallo zusammen, das hat jetzt nicht so geklappt, daher hier nochmal... via Google-Drive. Ursprungsmail! Matthias und ich haben uns hoffentlich abschließend über den aktualisierten Flyer hergemacht und stellen diesen nun hier zur Verfügung. https://drive.google.com/open?id=1fZufU35UxoM7q1sFOJlukgUHIXfalT6H Änderungswünsche nehmen wir hier in der Liste an. Am Wochenende arbeiten wir diese ein. Danach nochmalige Korrekturvorlage bis nächsten Mittwoch, und dann geht es hoffentlich zur Übersetzung. So, und nun allen viel Spaß bei der Suche nach DEM Haken, dem Fehler, der unklaren Zeile oder was auch immer. Matthias und ich freuen uns auf Eure Rückmeldungen. -- Grüßle Detlef
Flyer-Entwurf zur Ansicht und für Änderungsvorschläge [War: Flyer]
Hallo zusammen, Matthias und ich haben uns hoffentlich abschließend über den aktualisierten Flyer hergemacht und stellen diesen nun hier zur Verfügung. https://www.nannen2.de/oc/index.php/s/MRqNebG8OurrRz1/download Der PDF-Download klappt über diesen Link bis zum 13. Juli. (So soll es sein) Änderungswünsche nehmen wir hier in der Liste an. Am Wochenende arbeiten wir diese ein. Danach nochmalige Korrekturvorlage bis nächsten Mittwoch, und dann geht es hoffentlich zur Übersetzung. So, und nun allen viel Spaß bei der Suche nach DEM Haken, dem Fehler, der unklaren Zeile oder was auch immer. Matthias und ich freuen uns auf Eure Rückmeldungen. -- Grüßle Detlef
Re: [FORUMS] Please test forums
Hi,
Any news? I thought it would have been migrated last week.
Hagar
Le 27/06/2018 à 23:23, Hagar Delest a écrit :
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=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-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
Register now for ApacheCon and save $250
Greetings, Apache software enthusiasts! (You’re getting this because you’re on one or more dev@ or users@ lists for some Apache Software Foundation project.) ApacheCon North America, in Montreal, is now just 80 days away, and early bird prices end in just two weeks - on July 21. Prices will be going up from $550 to $800 so register NOW to save $250, at http://apachecon.com/acna18 And don’t forget to reserve your hotel room. We have negotiated a special rate and the room block closes August 24. http://www.apachecon.com/acna18/venue.html Our schedule includes over 100 talks and we’ll be featuring talks from dozens of ASF projects., We have inspiring keynotes from some of the brilliant members of our community and the wider tech space, including: * Myrle Krantz, PMC chair for Apache Fineract, and leader in the open source financing space * Cliff Schmidt, founder of Literacy Bridge (now Amplio) and creator of the Talking Book project * Bridget Kromhout, principal cloud developer advocate at Microsoft * Euan McLeod, Comcast engineer, and pioneer in streaming video We’ll also be featuring tracks for Geospatial science, Tomcat, Cloudstack, and Big Data, as well as numerous other fields where Apache software is leading the way. See the full schedule at http://apachecon.com/acna18/schedule.html As usual we’ll be running our Apache BarCamp, the traditional ApacheCon Hackathon, and the Wednesday evening Lighting Talks, too, so you’ll want to be there. Register today at http://apachecon.com/acna18 and we’ll see you in Montreal! -- Rich Bowen VP, Conferences, The Apache Software Foundation h...@apachecon.com @ApacheCon - To unsubscribe, e-mail: dev-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-de-h...@openoffice.apache.org
Register now for ApacheCon and save $250
Greetings, Apache software enthusiasts! (You’re getting this because you’re on one or more dev@ or users@ lists for some Apache Software Foundation project.) ApacheCon North America, in Montreal, is now just 80 days away, and early bird prices end in just two weeks - on July 21. Prices will be going up from $550 to $800 so register NOW to save $250, at http://apachecon.com/acna18 And don’t forget to reserve your hotel room. We have negotiated a special rate and the room block closes August 24. http://www.apachecon.com/acna18/venue.html Our schedule includes over 100 talks and we’ll be featuring talks from dozens of ASF projects., We have inspiring keynotes from some of the brilliant members of our community and the wider tech space, including: * Myrle Krantz, PMC chair for Apache Fineract, and leader in the open source financing space * Cliff Schmidt, founder of Literacy Bridge (now Amplio) and creator of the Talking Book project * Bridget Kromhout, principal cloud developer advocate at Microsoft * Euan McLeod, Comcast engineer, and pioneer in streaming video We’ll also be featuring tracks for Geospatial science, Tomcat, Cloudstack, and Big Data, as well as numerous other fields where Apache software is leading the way. See the full schedule at http://apachecon.com/acna18/schedule.html As usual we’ll be running our Apache BarCamp, the traditional ApacheCon Hackathon, and the Wednesday evening Lighting Talks, too, so you’ll want to be there. Register today at http://apachecon.com/acna18 and we’ll see you in Montreal! -- Rich Bowen VP, Conferences, The Apache Software Foundation h...@apachecon.com @ApacheCon - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
