-
Bug
-
Resolution: Fixed
-
Blocker
-
3.0.3
-
None
-
PHP Environment: 5.2.6
Database: Oracle 10.2.0.3.0
When I try to search with multiple words, system show me an error message:
SQL ERROR [ oracle ]
|
|
ORA-00904: "M0"."POST_ID": invalid identifier [904]
|
|
SQL
|
|
SELECT COUNT(DISTINCT p.post_id) AS total_results FROM fb_search_wordmatch m0, fb_search_wordmatch m1 LEFT JOIN fb_posts p ON ((m0.post_id = p.post_id OR (m0.post_id is NULL AND p.post_id is NULL))) WHERE m0.word_id = 5154 AND m1.word_id = 27255 AND (m1.post_id = m0.post_id OR (m1.post_id is NULL AND m0.post_id is NULL))
|
|
BACKTRACE
|
|
FILE: includes/db/oracle.php
|
LINE: 343
|
CALL: dbal->sql_error()
|
|
FILE: includes/search/fulltext_native.php
|
LINE: 666
|
CALL: dbal_oracle->sql_query()
|
|
FILE: search.php
|
LINE: 418
|
CALL: fulltext_native->keyword_search()
|