Search found 2 matches
- Wed Apr 27, 2022 4:35 pm
- Forum: [3.x] Tickets Discussion
- Topic: [PHPBB3-16976] phpBB Native Search returns 1 match and one page of results
- Replies: 5
- Views: 37114
Re: [PHPBB3-16976] phpBB Native Search returns 1 match and one page of results
I have corrected this on my site with what I have above and the search is working as expected now.
- Wed Apr 27, 2022 2:21 am
- Forum: [3.x] Tickets Discussion
- Topic: [PHPBB3-16976] phpBB Native Search returns 1 match and one page of results
- Replies: 5
- Views: 37114
Re: [PHPBB3-16976] phpBB Native Search returns 1 match and one page of results
I can confirm that the "GROUP BY" in the SQL causes the COUNT to return multiple rows, each with a "total_results" value of 1. It needs to return one row with the count. You can fix this by summing the result of the query e.g. $result = $this->db->sql_query("SELECT SUM(total...