specific search causes crash for tiki-searchresults.php
- Status
- Closed
- Subject
- specific search causes crash for tiki-searchresults.php
- Version
- 2.x
- Category
- Error
- Feature
- Search
Wiki (page view, edit, history, rename, etc) - Submitted by
- djrakun
- Lastmod by
- Landry Bitege
- Rating
- Description
entering the words "visual studio" in the search_box module causes the following message to be returned in the UI:
An error occured in a database query!Context:
File tiki-searchresults.php
Url tiki-searchresults.php?highlight=visual+studio&where=pages
Query:
select `data` from `tiki_dynamic_variables` where `name`=?
Values:
0 comspec
Message:
Table 'tikidb.tiki_dynamic_variables' doesn't exist
Built query was probably:
select `data` from `tiki_dynamic_variables` where `name`='comspec'- Solution
- Workaround
I prevented the crash from happening again by creating a page called "visual studio". Maybe someone started creating this page and it got orphaned or corrupted?
specific issue is resolved by my actions however cause of the original problem is unknown, so i will leave this issue open. One of my users confirmed that he accidentally typed "visual studio" into the 'quick edit' box and then shut down his browser. Even so, I would prefer this php script could be bullet proofed to not to crash if there is a titled page with no data in it.
FWIW, I created a blank page and saved it properly and this did not crash the php script when I used search_box to find that page. Likewise, by creating a page with the same name and then closing my broser I didn't see any problems with searching by that keyword
- Importance
- 5
- Priority
- 25
- 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
- 2295
- Created
- Monday 09 February, 2009 16:16:26 UTC
by Unknown - LastModif
- Wednesday 20 May, 2026 09:03:00 UTC