http://urbangiraffe.com/support/ Urban Giraffe Support Topic: Problem with Indexing and Search en Thu, 20 Nov 2008 17:40:36 +0000 http://urbangiraffe.com/support/topic/problem-with-indexing-and-search#post-101 Fri, 14 Mar 2008 05:52:51 +0000 ririzarry 101@http://urbangiraffe.com/support/ <p>Another small update - I recreated the tables manually and this time it seems to have stuck. I can only guess that there was a syntax issue somewhere in my previous SQL statement. </p> <p>However, I'd still be curious to understand what changes need to be backed out in order to restore things to a pristine state. I know about the tables but there are also a few entries I found in the options table. What are the entries that go into the options table? </p> http://urbangiraffe.com/support/topic/problem-with-indexing-and-search#post-100 Thu, 13 Mar 2008 20:37:46 +0000 ririzarry 100@http://urbangiraffe.com/support/ <p>I did a bit more digging around. </p> <p>I tried 0.2.14 but nothing changed. I still didn't see the tables created and the indexing continues to report as working. </p> <p>I located the database.php and used the code to create the tables manually but only the comments would index. I deactivated the plugin and reactivated it. The tables disappeared and I ended up back to square one - no tables. </p> http://urbangiraffe.com/support/topic/problem-with-indexing-and-search#post-99 Thu, 13 Mar 2008 09:27:00 +0000 ririzarry 99@http://urbangiraffe.com/support/ <p>I will start by admitting that it seems clear I contributed to this issue. I'll explain.</p> <p>I had submitted a feature request to allow bolding search phrases in addition to or instead of colors. I picked around a bit and found this bit of code in css.php - .searchterm&lt;?php echo $x + 1 ?&gt; { background-color: #&lt;?php echo $highlight[$x] ?&gt;; padding: 2px 0px;}</p> <p>Having found this, I added font-weight: 700 between the php call and padding. I then set the highlighting to white and got my bold search terms. It worked fine - no issues. </p> <p>Last night, I upgraded to the latest version 0.2.13 with the intent of carrying forward my little hack. However, I blundered and removed the #&lt;?php echo $highlight[$x] ?&gt;;. Search returned zero results and I realized my mistake.</p> <p>I then went back, restored the original plugin code and reran the indexing. The indexing process reported as complete but then would show no items actually indexed and search would return 0 results.</p> <p>I also tried reverting to previous versions of the plugin to no avail. I also observed that the tables search and search phrases exist in my test region but not my main site. Are these the two generated by Search Unleashed?</p> <p>If they are, it leads me to think that the issue relates to a piece of code that thinks the tables exist based on some parameter I'm missing. </p> <p>Thanks in advance for your help! </p>