Re: ooo-forums downtime

2018-01-04 Thread Chris Lambertus 

There may not be anything we can do about this until phpBB is upgraded.

I put the wiki database move on hold until I can look into it more.


> On Jan 4, 2018, at 2:42 PM, Andrea Pescetti  wrote:
> 
> CCing Chris for the two messages below. Maybe a SQL version issue?
> Regards,
>  Andrea.
> 
> On 04/01/2018 21:59, Hagar Delest wrote:
>> Note: same for the other languages (Italian anf French tested).
>> 
>> The DISTINCT 3065 thing seems a common one:
>> 
>> In French forum:
>> Erreur générale
>> SQL ERROR [ mysqli ]
>> 
>> Expression #1 of ORDER BY clause is not in SELECT list, references
>> column 'forumaoo_fr.t.topic_last_post_time' which is not in SELECT list;
>> this is incompatible with DISTINCT [3065]
>> 
>> And in Italian:
>> SQL ERROR [ mysqli ]
>> 
>> Expression #1 of ORDER BY clause is not in SELECT list, references
>> column 'forumaoo_it.t.topic_last_post_time' which is not in SELECT list;
>> this is incompatible with DISTINCT [3065]
>> 
>> Hagar
>> 
>> 
>> Le 04/01/2018 à 21:33, Hagar Delest a écrit :
>>> Hi,
>>> 
>>> Since the move, we noticed that when performing an advanced search
>>> that should display the results as topics, then we get an error:
>>> 
>>> 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
>>> ('+solved ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY
>>> t.topic_last_post_time DESC LIMIT 250
>>> 
>>> The same search is fine when set to display results as posts.
>>> 
>>> Could you have a look please?
>>> Thanks
>>> 
>>> Hagar
>>> 
>>> 
>>> Le 04/01/2018 à 03:30, Chris Lambertus a écrit :
> On Jan 1, 2018, at 2:24 PM, Chris Lambertus  wrote:
> 
> Hi folks,
> 
> At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice
> PHPBB forum databases to a new server. The forums will be offline
> during this process, and is expected to take about 2 hours.
> 
> -Chris
> ASF Infra
> 
> 
 
 Hi all,
 
 This move has been completed. Spot checks on the forums look good.
 
 -Chris
 
>>> 
>> 
>> 
>> -
>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>> 
>> 



signature.asc
Description: Message signed with OpenPGP

Re: ooo-forums downtime

2018-01-04 Thread Andrea Pescetti 

CCing Chris for the two messages below. Maybe a SQL version issue?
Regards,
  Andrea.

On 04/01/2018 21:59, Hagar Delest wrote:

Note: same for the other languages (Italian anf French tested).

The DISTINCT 3065 thing seems a common one:

In French forum:
Erreur générale
SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in SELECT list, references
column 'forumaoo_fr.t.topic_last_post_time' which is not in SELECT list;
this is incompatible with DISTINCT [3065]

And in Italian:
SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in SELECT list, references
column 'forumaoo_it.t.topic_last_post_time' which is not in SELECT list;
this is incompatible with DISTINCT [3065]

Hagar


Le 04/01/2018 à 21:33, Hagar Delest a écrit :

Hi,

Since the move, we noticed that when performing an advanced search
that should display the results as topics, then we get an error:

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
('+solved ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY
t.topic_last_post_time DESC LIMIT 250

The same search is fine when set to display results as posts.

Could you have a look please?
Thanks

Hagar


Le 04/01/2018 à 03:30, Chris Lambertus a écrit :

On Jan 1, 2018, at 2:24 PM, Chris Lambertus  wrote:

Hi folks,

At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice
PHPBB forum databases to a new server. The forums will be offline
during this process, and is expected to take about 2 hours.

-Chris
ASF Infra




Hi all,

This move has been completed. Spot checks on the forums look good.

-Chris






-
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

Re: ooo-forums downtime

2018-01-04 Thread Hagar Delest 

Note: same for the other languages (Italian anf French tested).

The DISTINCT 3065 thing seems a common one:

In French forum:
Erreur générale
SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in SELECT list, references column 
'forumaoo_fr.t.topic_last_post_time' which is not in SELECT list; this is 
incompatible with DISTINCT [3065]

And in Italian:
SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in SELECT list, references column 
'forumaoo_it.t.topic_last_post_time' which is not in SELECT list; this is 
incompatible with DISTINCT [3065]

Hagar


Le 04/01/2018 à 21:33, Hagar Delest a écrit :

Hi,

Since the move, we noticed that when performing an advanced search that should 
display the results as topics, then we get an error:

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 ('+solved ' 
IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY t.topic_last_post_time 
DESC LIMIT 250

The same search is fine when set to display results as posts.

Could you have a look please?
Thanks

Hagar


Le 04/01/2018 à 03:30, Chris Lambertus a écrit :

On Jan 1, 2018, at 2:24 PM, Chris Lambertus  wrote:

Hi folks,

At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB 
forum databases to a new server. The forums will be offline during this 
process, and is expected to take about 2 hours.

-Chris
ASF Infra




Hi all,

This move has been completed. Spot checks on the forums look good.

-Chris






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

Re: ooo-forums downtime

2018-01-04 Thread Hagar Delest 

Hi,

Since the move, we noticed that when performing an advanced search that should 
display the results as topics, then we get an error:

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 ('+solved ' 
IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY t.topic_last_post_time 
DESC LIMIT 250

The same search is fine when set to display results as posts.

Could you have a look please?
Thanks

Hagar


Le 04/01/2018 à 03:30, Chris Lambertus a écrit :

On Jan 1, 2018, at 2:24 PM, Chris Lambertus  wrote:

Hi folks,

At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB 
forum databases to a new server. The forums will be offline during this 
process, and is expected to take about 2 hours.

-Chris
ASF Infra




Hi all,

This move has been completed. Spot checks on the forums look good.

-Chris




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

Re: Volunteer for building OpenOffice from source

2018-01-04 Thread Andrea Pescetti 

On 03/01/2018 Ash Blade wrote:

I saw that you are looking for help with building Open Office from source and I 
think my current set of skills could be put to good use with this task.


Welcome, Ash! Yes, we can surely put your skills to good use here.

With your current experience I think you can just go ahead and try a 
local build on Linux; the process is challenging, or at least 
nonstandard, in all environments, but Linux tends to be smoother.


Start with a trunk checkout (your svn skills "from the past" will 
actually help here!):


$ svn co https://svn.apache.org/repos/asf/openoffice/trunk openoffice

then go ahead following
https://wiki.openoffice.org/wiki/Documentation/Building_Guide_AOO
and tell us when you have any doubts.

What Linux distribution are you using?
https://wiki.openoffice.org/wiki/Documentation/Building_Guide_AOO/Step_by_step
has some hints to help building on many distributions, and we'd surely 
appreciate if you can collect some notes while you build so that you can 
add them to the wiki (if you need an account, just ask here).


I'm CCing you explicitly in this first answer, but in case you are not 
subscribed please do so; or read the archives at 
https://lists.apache.org/list.html?dev@openoffice.apache.org


Regards,
  Andrea.

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

Re: Reporting broken download link Download fehlgeschlagen 2 x

2018-01-04 Thread Marcus 

Thanks for your report.

However, a simple copy & paste is not enough to tell us what you problem 
is with downloading. Please can you specify it with your own words and 
with more details?


BTW:
I've tested a second ago and cannot see any problem when downloading AOO 
4.1.5 in German for Windows.


Thanks in advance.

Marcus



Am 04.01.2018 um 17:31 schrieb Henner Lotz:


[...]

Link melden 

*Problembeschreibung*   *Ersetze diesen Text und beschreibe das Problem

(Was funktioniert nicht? Was wird erwartet?)*
[...]



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

ooo-wiki downtime

2018-01-04 Thread Chris Lambertus 

> On Jan 1, 2018, at 2:24 PM, Chris Lambertus  wrote:
> 
> Hi folks,
> 
> At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB 
> forum databases to a new server. The forums will be offline during this 
> process, and is expected to take about 2 hours.



Hi folks,

We also need to perform this operation on the ooo-wiki site. This is only 
moving the MySQL database backend by updating the server IP in /x1/LocalDB.php. 
There will be no other changes to the application or app server. I will be 
performing this work tonight at 0100 UTC. The outage should be shorter as there 
is only one database that needs to move.


-Chris



signature.asc
Description: Message signed with OpenPGP

Reporting broken download link Download fehlgeschlagen 2 x

2018-01-04 Thread Henner Lotz 

Sprache:
Apache OpenOffice 


Die freie und offene Büro-Software
Apache OpenOffice 4.1.5 ist verfügbar! 



 * Produkt 
 * Herunterladen 
 * Hilfe & Support 
 * Blog 
 * Erweiterungen & Vorlagen
   
 * Entwickler 
 * Schwerpunkte 
 * Sprachen 

home  » de 
 » download 




 Wie wird ein kaputter Download-Link gemeldet?

1. *Wähle die gewünschten Optionen*: Betriebssystem, Sprache und
   Version in dem unteren grünen Kasten.
2. Sicherstellen, dass diese Optionen *noch immer nicht* zu
   funktionierenden Download-Links führen.
3. Auf den Button unterhalb des grünen Kastens drücken: *[ Klicken zum
   Aktualisieren der Tabelle ]*
4. Auf den Button unterhalb des grünen Kastens drücken: *[ Klicken zum
   Auswählen der Tabelle ]*
5. Kopieren der ausgewählten Tabellendaten in die Zwischenablage: *[
   Kopieren mit [Strg] + [C] / [⌘]+[C] ]*

6. *Neue E-Mail erstellen.*
7. *Beschreibung des Problems* (was funktioniert nicht und was wird
   erwartet).
8. Bitte auch *Details über das benutzte Betriebssystem* hinzufügen.
9. *Die kopierten Daten ans Ende der E-Mail einfügen.*
10. Bitte *die E-Mail nur in dem Fall senden, wenn es um Probleme beim
   Herunterladen geht* und nicht beim Installieren.
11. *Diese Webseite kann überhaupt nicht bei Installationsproblemen helfen.*
12. Schließlich, *senden der E-Mail* an die: *Apache OpenOffice
   Entwickler-Mailing Liste*
   
.
   *)


*) *Was ist eine Mailing Liste?* 
.



 Wir werden versuchen, nach Erhalt der E-Mail und Analyse
 schnellstmöglich eine Antwort zu geben.
 Vielen Dank für den Report.


   Apache OpenOffice herunterladen

(Hosted von Sourceforge.net - Eine vertrauenswürdige Webseite)

*Wähle das gewünschte Betriebssystem, Sprache und Version:*


 Herunterladen: Vollinstallation
 



 Herunterladen: Sprachpaket
 




*Release: * Milestone AOO415m1 | Build ID 9789 | SVN r1817496 | 
Veröffentlicht 2017-12-30 | Release Notes 

*Vollinstallation: *Dateigröße ~157 MByte | Signaturen und Hashwerte: 
KEYS , ASC 
, 
MD5 
, 
SHA256 

*Sprachpaket: *Dateigröße ~ 19 MByte | Signaturen und Hashwerte: KEYS 
, ASC 
, 
MD5 
, 
SHA256 



Install infoWas ist ein Sprachpaket? 
Prüfsummen 
verifizierenDownload verifizieren? 
Broken linkKaputten 
Link melden 


*Problembeschreibung*   *Ersetze diesen Text und beschreibe das Problem

(Was funktioniert nicht? Was wird erwartet?)*
*Browser Variablen* *Werte*
navigator.appCodeName   Mozilla
navigator.appName   Netscape
navigator.appVersion5.0 (Windows)
navigator.platform  Win32
navigator.oscpu Windows NT 6.1
navigator.cpuClass  undefined
navigator.product   Gecko
navigator.productSub20100101
navigator.vendor
navigator.vendorSub 
navigator.language  de
navigator.browserLanguage   undefined
navigator.userLanguage  undefined
navigator.systemLanguageundefined
navigator.userAgent 	Mozilla/5.0 (Windows NT 6.1; rv:56.0) 
Gecko/20100101 Firefox/56.0

Debian / Ubuntu / IceWeasel ?   Nein /