Entering blog thru SERP gives error, but Search box doesn’t

  • I just realized I was 4th in the Google SERPs for a particular word (which is cool but not the focus of this post) so I clicked on it out of curiousity – it produced this error:

    Can’t find FULLTEXT index matching the column list.

    SELECT ID AS post_id, post_title AS title FROM wp_posts WHERE MATCH (post_content, post_title) AGAINST (‘toptaggers’) AND post_status = ‘publish’ LIMIT 5

    However, it did produce the correct post and EVEN highlighted the word in the post for me. I then opened phpMyAdmin to check for that INDEX on the wp_posts table and sure enough, it doesn’t have that one but it does have an INDEX on the post_name.

    Is this an instance where I would want to create an index on the post_content field? Is the post_title field necessary too, or does the fact that it is a permalink good enough?

    Finally, what is it that makes a word highlighted when coming in through (Google) SERPs but using my own blog search box doesn’t highlight that same word? Case in point: Google toptaggers and you’ll see my SimplePie, fungow… post 4th inline (today anyway lol). Clicking on that link will produce what I am talking about – but then searching for that same word with my blog search box doesn’t highlight it for the user.

    Thanks so much for any help.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter sccoder

    (@sccoder)

    bump

    Thread Starter sccoder

    (@sccoder)

    bump

    please don’t bump your threads any sooner than 24 hours apart. someone who has an answer will come along for you – bumping makes it look like someone already might’ve helped you.

    this forum is all volunteer, and culminates knowledge from all over the globe – we have to sleep too, though. i’m sure the person who has the answer for you will find you without your having to make bumps every 2-3 hours.

    Thread Starter sccoder

    (@sccoder)

    bump

    Thread Starter sccoder

    (@sccoder)

    bump

    Thread Starter sccoder

    (@sccoder)

    bump

    SCcoder: Your original post seemed to indicate you have the capability to write in the English language yet your behaviour suggests that you’re having trouble undestanding it. Please take the advice and STOP BUMPING posts as it’s not appreciated by anyone and you run the risk of coming across as a jerk (and NOT being helped), which I’m sure is NOT what you’re trying to achieve.

    Thread Starter sccoder

    (@sccoder)

    kiss my ass jerk, it’s been 5 days, and as much as the search function of this site sucks, nobody would ever find this if they happened to be looking for this exact phrase anyway, so the only alternative is to keep it on the front page

    luckily, I haven’t done it that much at all

    Well you have proven to be exactly what I said you might be. Congratulations on being a complete IDIOT.

    And “as much as the search function of this site sucks”, it doesn’t quite suck as hard as you do.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Entering blog thru SERP gives error, but Search box doesn’t’ is closed to new replies.

Tags