-
Bug
-
Resolution: Duplicate
-
None
-
3.0.4
-
None
-
PHP Environment:
Database: PostgreSQL 8.2.6
This was reported on our russian support site, I can't confirm it because don't have Postgre installed.
Search within topic titles only produces error like
General error
|
SQL ERROR [ postgres ]
|
|
|
ERROR: missing FROM-clause entry for table "t" LINE 1: ...s p ON (m0.post_id = p.post_id) WHERE p.post_id = t.topic_first_post_id
|
|
|
SQL
|
|
|
SELECT COUNT(DISTINCT p.post_id) AS total_results FROM phpbb_search_wordmatch m0 LEFT JOIN phpbb_posts p ON (m0.post_id = p.post_id) WHERE p.post_id = t.topic_first_post_id AND m0.word_id = 18460 AND m0.title_match = 1
|
|
|
BACKTRACE
|
|
|
FILE: includes/db/postgres.php
|
LINE: 177
|
CALL: dbal->sql_error()
|
|
|
FILE: includes/search/fulltext_native.php
|
LINE: 663
|
CALL: dbal_postgres->sql_query()
|
|
|
FILE: search.php
|
LINE: 418
|
CALL: fulltext_native->keyword_search()
|
The query string example is: ./search.php?keywords=ford&terms=all&author=&sc=1&sf=titleonly&sk=t&sd=d&sr=posts&st=0&ch=300&t=0&submit=%D0%9F%D0%BE%D0%B8%D1%81%D0%BA
- duplicates
-
-
- Closed
-