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 <c...@apache.org> 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
