System error: DOUBLE value is out of range when searching for the first time after Search Index rebuild
- Status
- Pending
- Subject
- System error: DOUBLE value is out of range when searching for the first time after Search Index rebuild
- Version
- 30.x
master - Category
- Error
- Regression
- Usability
- Feature
- Search
- Resolution status
- Fixed or Solved
- Submitted by
- luci
- Volunteered to solve
- joel.magene
- Lastmod by
- joel.magene
- Rating
- Description
Searching the content (try e.g., "social") FAILS with fatal error after fresh-install/index rebuild:
Copy to clipboardSystem error. The following error message was returned: DOUBLE value is out of range in '(round((match `tiki-fresh`.`index_6a5a0961d11ac`.`contents` against ('social')),2) * 1)' The query was: SELECT *, ROUND(MATCH(`contents`) AGAINST ('social'),2) * 1 + ROUND(MATCH(`title`) AGAINST ('social'),2) * 2.5 AS `score` FROM `index_6a5a0961d11ac` WHERE 1=1 AND ((MATCH (`contents`) AGAINST ('social' IN BOOLEAN MODE) OR MATCH (`title`) AGAINST ('social' IN BOOLEAN MODE)) AND (`searchable` = 'y' AND `searchable` IS NOT NULL)) ORDER BY `score` DESC The built query was likely: SELECT *, ROUND(MATCH(`contents`) AGAINST ('social'),2) * 1 + ROUND(MATCH(`title`) AGAINST ('social'),2) * 2.5 AS `score` FROM `index_6a5a0961d11ac` WHERE 1=1 AND ((MATCH (`contents`) AGAINST ('social' IN BOOLEAN MODE) OR MATCH (`title`) AGAINST ('social' IN BOOLEAN MODE)) AND (`searchable` = 'y' AND `searchable` IS NOT NULL)) ORDER BY `score` DESC
_This happens only for the first initial search. After that first attempt it seems to work normally for any subsequent search._Steps to reproduce:
- Run
php console.php i:r - Go to
tiki-searchindex.php?filter~content=profile&sort_mode=score_ndesc
- Run
- Solution
- Workaround
- Importance
- 7
- Easy to solve?
- 5
- Priority
- 35
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 9010
- Created
- Friday 17 July, 2026 12:40:53 UTC
by luci - LastModif
- Friday 07 August, 2026 06:38:25 UTC