specific search causes crash for tiki-searchresults.php
- Status
- Open
- Subject
- specific search causes crash for tiki-searchresults.php
- Version
- 2.x
- Category
- Error
- Feature
- Wiki (page view, edit, history, rename, etc)
Search - Submitted by
- djrakun
- 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'- 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 (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 2295
- Created
- Monday 09 February, 2009 16:16:26 GMT-0000
by Unknown - LastModif
- Monday 09 February, 2009 16:16:26 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- htaccess.sh is gone from Tiki26 and after the installation you may need to create the symlink manually
- Create new Group function does not work Tiki V26.0 Clean install brand new database
- Manticore install and configuration
- Wiki plugin User list show all the user, the parameter Max of rows is not applied
- Automatic Indexing of Mathematical Calculation Tracker Fields
;){kind=link}
;){kind=link}