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

Search Doesn't Work on Topics Option

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 3.2.1, 3.2.2
    • Search
    • PHP 7.1.9
      MySQL 5.7.20

      If I select Show Results: Topics instead of Messages then:

      SQL ERROR [ mysqli ]

      Expression #1 of ORDER BY clause is not in SELECT list, references column 'phpbb.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_topics t, phpbb_posts p WHERE MATCH (p.post_subject) AGAINST ('+Teste ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id AND (p.post_visibility = 1 OR p.forum_id IN (3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 33, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 166, 167, 168, 169, 170, 171, 172, 173, 175, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 216, 217, 218, 219, 220)) AND p.post_id = t.topic_first_post_id ORDER BY t.topic_last_post_time DESC LIMIT 250

      BACKTRACE

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()

      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 996
      CALL: trigger_error()

      FILE: [ROOT]/phpbb/db/driver/mysqli.php
      LINE: 193
      CALL: phpbb\db\driver\driver->sql_error()

      FILE: [ROOT]/phpbb/db/driver/mysql_base.php
      LINE: 45
      CALL: phpbb\db\driver\mysqli->sql_query()

      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 270
      CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

      FILE: [ROOT]/phpbb/db/driver/factory.php
      LINE: 321
      CALL: phpbb\db\driver\driver->sql_query_limit()

      FILE: [ROOT]/phpbb/search/fulltext_mysql.php
      LINE: 594
      CALL: phpbb\db\driver\factory->sql_query_limit()

      FILE: [ROOT]/search.php
      LINE: 593
      CALL: phpbb\search\fulltext_mysql->keyword_search()

       

       

       May I say that I'm using MySQL Fulltext

      EDIT: 3.2.2 has the same problem but the line 594 is hiding the sql error: $this->db->sql_return_on_error(true);

      How to see the error on 3.2.2? Simple, do a normal search, after it show you some results go to the url and change sr=posts to sr=topics, now it gives empty results.

            Unassigned Unassigned
            Tarantino Tarantino
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: