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.
- is related to
-
PHPBB-16902 Improve search results count for MySQL
- Unverified Fix