Problem with Indexing and Search

7 months ago | ririzarry (Member) | |

I will start by admitting that it seems clear I contributed to this issue. I'll explain.

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<?php echo $x + 1 ?> { background-color: #<?php echo $highlight[$x] ?>; padding: 2px 0px;}

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.

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 #<?php echo $highlight[$x] ?>;. Search returned zero results and I realized my mistake.

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.

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?

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.

Thanks in advance for your help!

Read responses...

Responses

  1. ririzarry:

    Posted 7 months ago by Member

    I did a bit more digging around.

    I tried 0.2.14 but nothing changed. I still didn't see the tables created and the indexing continues to report as working.

    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.

  2. ririzarry:

    Posted 7 months ago by Member

    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.

    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?

Reply

You must log in to post.

Home | Software | Terms & Conditions | Sitemap | John Godley © 2008