Re: Forum Migration Status
There is an issue with Search and returning topics. To reproduce:
Go to advanced search
Enter a search term(s) - I used spell check error
Scroll down and choose Display results as: Topics
Leave all other settings and click Search
Result:
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 ('+spell
+check +error ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY
t.topic_last_post_time DESC 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()
-
As an aside, would it be possible to have the search default to Display
as Topics? This returns a more compact listing of the results which
seems to me to be easier to work through.
On 27/11/18 10:40 am, Dave Fisher wrote:
Hi Hagar / Forum Admins,
We must do a forum migration to new VMs by Friday, November 30th.
It turns out that many of the errors we had in June testing are due to
incompatibilities between PHP 7 and phpBB 3.0.x and 3.1.x. Specifically BBCodes
use a php method that is no longer supported in PHP 7.
In order for me to better perform the migration I need you to grant my ID
(dave2wave) full admin rights on both the current production and also forum
test.
Also, please provide to me the email addresses to each forums admins so that I
can provide any setup instructions.
I am in the San Francisco area and will be online by 16:00 UTC.
Regards,
Dave
-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
Cheers
--
David Robley
A bird in the hand can be messy.
Re: Forum Migration Status
For testing purposes - is the test site forum-test.openoffice.org configured to _not_ send notifications in response to mod actions such as banning, disapproving posts etc? I'll test some of those functions as long as I can be sure I'm not sending a spray of un-needed notifications. On 27/11/18 10:40 am, Dave Fisher wrote: Hi Hagar / Forum Admins, We must do a forum migration to new VMs by Friday, November 30th. It turns out that many of the errors we had in June testing are due to incompatibilities between PHP 7 and phpBB 3.0.x and 3.1.x. Specifically BBCodes use a php method that is no longer supported in PHP 7. In order for me to better perform the migration I need you to grant my ID (dave2wave) full admin rights on both the current production and also forum test. Also, please provide to me the email addresses to each forums admins so that I can provide any setup instructions. I am in the San Francisco area and will be online by 16:00 UTC. Regards, Dave - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org Cheers -- David Robley A bird in the hand can be messy. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Forum Migration Status
There is no special configuration. It should send normal email / notifications. Sent from my iPhone > On Nov 28, 2018, at 12:22 AM, David Robley wrote: > > For testing purposes - is the test site forum-test.openoffice.org configured > to _not_ send notifications in response to mod actions such as banning, > disapproving posts etc? > > I'll test some of those functions as long as I can be sure I'm not sending a > spray of un-needed notifications. > >> On 27/11/18 10:40 am, Dave Fisher wrote: >> Hi Hagar / Forum Admins, >> >> We must do a forum migration to new VMs by Friday, November 30th. >> >> It turns out that many of the errors we had in June testing are due to >> incompatibilities between PHP 7 and phpBB 3.0.x and 3.1.x. Specifically >> BBCodes use a php method that is no longer supported in PHP 7. >> >> In order for me to better perform the migration I need you to grant my ID >> (dave2wave) full admin rights on both the current production and also forum >> test. >> >> Also, please provide to me the email addresses to each forums admins so that >> I can provide any setup instructions. >> >> I am in the San Francisco area and will be online by 16:00 UTC. >> >> Regards, >> Dave >> - >> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: dev-h...@openoffice.apache.org >> >> > > Cheers > -- > David Robley > > A bird in the hand can be messy. > > > - > 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: Forum Migration Status
I confirm this issue in Italian forum.
ciao
charlie
Il 28/11/18 09:15, David Robley ha scritto:
There is an issue with Search and returning topics. To reproduce:
Go to advanced search
Enter a search term(s) - I used spell check error
Scroll down and choose Display results as: Topics
Leave all other settings and click Search
Result:
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
('+spell +check +error ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id
ORDER BY t.topic_last_post_time DESC 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()
-
As an aside, would it be possible to have the search default to
Display as Topics? This returns a more compact listing of the results
which seems to me to be easier to work through.
On 27/11/18 10:40 am, Dave Fisher wrote:
Hi Hagar / Forum Admins,
We must do a forum migration to new VMs by Friday, November 30th.
It turns out that many of the errors we had in June testing are due
to incompatibilities between PHP 7 and phpBB 3.0.x and 3.1.x.
Specifically BBCodes use a php method that is no longer supported in
PHP 7.
In order for me to better perform the migration I need you to grant
my ID (dave2wave) full admin rights on both the current production
and also forum test.
Also, please provide to me the email addresses to each forums admins
so that I can provide any setup instructions.
I am in the San Francisco area and will be online by 16:00 UTC.
Regards,
Dave
-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
Cheers
-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Forum Migration Status
Hi -
This issue should now be resolved.
Regards,
Dave
> On Nov 28, 2018, at 2:16 AM, Carlo Salvagno
> wrote:
>
> I confirm this issue in Italian forum.
>
> ciao
>
> charlie
>
>
> Il 28/11/18 09:15, David Robley ha scritto:
>> There is an issue with Search and returning topics. To reproduce:
>> Go to advanced search
>> Enter a search term(s) - I used spell check error
>> Scroll down and choose Display results as: Topics
>> Leave all other settings and click Search
>>
>> Result:
>>
>> 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 ('+spell
>> +check +error ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY
>> t.topic_last_post_time DESC 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()
>>
>> -
>>
>> As an aside, would it be possible to have the search default to Display as
>> Topics? This returns a more compact listing of the results which seems to me
>> to be easier to work through.
>>
>> On 27/11/18 10:40 am, Dave Fisher wrote:
>>> Hi Hagar / Forum Admins,
>>>
>>> We must do a forum migration to new VMs by Friday, November 30th.
>>>
>>> It turns out that many of the errors we had in June testing are due to
>>> incompatibilities between PHP 7 and phpBB 3.0.x and 3.1.x. Specifically
>>> BBCodes use a php method that is no longer supported in PHP 7.
>>>
>>> In order for me to better perform the migration I need you to grant my ID
>>> (dave2wave) full admin rights on both the current production and also forum
>>> test.
>>>
>>> Also, please provide to me the email addresses to each forums admins so
>>> that I can provide any setup instructions.
>>>
>>> I am in the San Francisco area and will be online by 16:00 UTC.
>>>
>>> Regards,
>>> Dave
>>> -
>>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>>>
>>>
>>
>> Cheers
>
>
> -
> 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: Forum Migration Status
Hi, I confirm that it has been solved.
ciao,
charlie
Il 28/11/18 19:02, Dave Fisher ha scritto:
Hi -
This issue should now be resolved.
Regards,
Dave
On Nov 28, 2018, at 2:16 AM, Carlo Salvagno wrote:
I confirm this issue in Italian forum.
ciao
charlie
Il 28/11/18 09:15, David Robley ha scritto:
There is an issue with Search and returning topics. To reproduce:
Go to advanced search
Enter a search term(s) - I used spell check error
Scroll down and choose Display results as: Topics
Leave all other settings and click Search
Result:
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 ('+spell
+check +error ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY
t.topic_last_post_time DESC 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()
-
As an aside, would it be possible to have the search default to Display as
Topics? This returns a more compact listing of the results which seems to me to
be easier to work through.
On 27/11/18 10:40 am, Dave Fisher wrote:
Hi Hagar / Forum Admins,
We must do a forum migration to new VMs by Friday, November 30th.
It turns out that many of the errors we had in June testing are due to
incompatibilities between PHP 7 and phpBB 3.0.x and 3.1.x. Specifically BBCodes
use a php method that is no longer supported in PHP 7.
In order for me to better perform the migration I need you to grant my ID
(dave2wave) full admin rights on both the current production and also forum
test.
Also, please provide to me the email addresses to each forums admins so that I
can provide any setup instructions.
I am in the San Francisco area and will be online by 16:00 UTC.
Regards,
Dave
-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
Cheers
-
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
-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Small website refresh
Hi George, I echo what Andrea writes. I am currently migrating the OpenOffice forums to new VMs and then need to plan additional upgrades. I was the one who did the bulk of the Apache CMS work with OpenOffice.org and understand exactly how the pages are built from templates and css. When I have more time in December I can look at how to convert the pages. We’ve kept all language sites including over 100 languages in case a community ever returns. (Mongolian has some nice Yurt icons.) Files are either in the original pre-Apache html or in Markdown. We should evaluate whatever generation system we decide to use to figure out the best way to preserve as much as possible. You might get a handle on the structure from making use of the instructions on this page. [1] Regards, Dave [1] https://openoffice.apache.org/website-local.html#using-the-apache-cms-bookmarklet-simpler-method > On Nov 27, 2018, at 12:29 PM, Andrea Pescetti wrote: > > George Karalis wrote: >> All I am asking now is if I could have access to a staging environment(maybe >> in >> another url, as I don't want to mess with your current staging site, as you >> may want >> to make changes there), so I can make those changes and having a fully >> working and >> tested homepage within this week, that we can move live. > > Thanks, George! As you've probably seen from other conversations, we are on a > very tight schedule at the moment since we need to move our old sites to new > servers this week; this is why nobody had the time to help you with the site. > > Since I see it's just HTML and assets, we could try hosting it at > http://www.openoffice.org/new > or similar, provided you use relative URLs for assets. > > You will need some patience; I like your draft more than the current homepage > and I think it undeniably looks more modern, but we'll have to feature-match > the current home (e.g., it suggests the native-lang site when available) and > some of the choices we had made, like not to have a prominent Donate button, > reflected mailing list discussions back at the time. Everything can be > reversed, but it needs to go through a discussion. Fortunately, discussions > on this list are now much shorter and to-the-point than they used to be a few > years ago, so I hope we can have the new homepage online relatively soon. > > Next step: if you manage to adapt the JS so that it suggests the native-lang > site correctly, I can then put it at a convenience URL for testing (or we can > continue to review it on Github). Some of us will very likely be busy with > the Wiki and Forum upgrades this week, but some feedback should come. > > Regards, > Andrea. > > - > 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
