Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-7963

ORA-00904: "M0"."POST_ID": invalid identifier [904]

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 3.0.4
    • 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()

            Acyd Burn Meik Sievertsen [X] (Inactive)
            hogargrozni hogargrozni
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: