Search-page problem after update 2.8.1 to 2.8.2?

[webby]

Hi (Ruud)

I have a seriuos search-page problem. When I try to use the search-funktion, I've got a blank site as answer?
The only thing I have done, is to upgrade from 2.8.1 to 2.8.2.
I have to mention that I have six WB-websites on this server and this is the only one of the six paged that do not work probably with the search-funktion. I also have tried to insert a droplets search-funktion - doesn't work either?

Please help.

Thank you

[pcwacht]

Most of the times when search doesn't work there is a faulty DB entrie from some ( leftover ) module wich wasn't 100% search ready.

Did you install some modules?

John

[webby]

Hi pcwacht

Yes hmm - I have. I have tried some "new" modules... But I do not exactly remember witch!? But I can remember that the search-funktion was one of the first features I did test, when I had installed the update 2.8.2?

How to find the db-faultys?

Thank you

[pcwacht]

The seach entries are stored in the  table <PREFIX>search
From record 16 onwards there are normally 4 records per module
all named:
module wich hold the modulename
querystart, querybody and queryend where the module name is in field extra

Look here for leftovers from old modules wich you did uninstalled.
Delete records associated with them.

Next to this there can be a search.php in the moduledirectory wich might have an error as well, but that is rarely the case.
Most of the time the module -uninstall leftovers are the cause.

John.

[webby]

Hi again

Just to be sure...

Every record just have only 4 record as you describe (module witch hold the modulename
querystart, querybody and queryend where the module name is in field extra).

I have to delete if there is more than these four?

Se the screenshot of a part of the db. (attach)

Thank you

[pcwacht]

First sort on search_id, then you will have the logical order.
Allso make a copy, you'll never know!!

Then delete the fields of the modules you don't have anymore, these are the leftovers
And next delete the fields wich don't have 4 for one module, these are faulty.

This might do it.

John

[webby]

Hi again

Hmm - please take a look on this screenshot of the db... The only fault I can see, is in the bottom (search ID 76) ? Isn't that right?
All the other items seem to look right... (as you told: modulename
querystart, querybody and queryend).

Thank you John !

[pcwacht]

Yups seems like a leftover or a module with bad search integration.
Make a backup first, allways do that when editing mysql tables, cause in the end you might be glad you did

I think it is save to delete that line, and after that search should work.

I took a look at the module 'newsreader' install and uninstall but it looks good to me.
http://www.websitebakers.com/pages/modules/listings/section-pages/newsreader.php

Don't know where the error comes from.

Hope search will be working after this.

John

[webby]

Thank you very much John  !

[webby]

Hi again

Hmm - That did not help. I have now removed the false line in the database, but the search-funktion do still not work aefter updating from 2.8.1. to 2.8.2. also with the new sp1 installed)?

Do you have other suggestions to solve this problem?

Thank you

[pcwacht]

The error description indicates a php error
Could you look into your logs to see the error? This would help a lot.

Other option is to go to settings, advanced options and set error reporting to E_ALL or E_ALL & E_STRICT
This might bring up some errors in the blank page.
Sometimes looking at the html source of the blank page might show errors as well, but rarely.

The logs are the best, cause there it will shwo what error in wich file at wich line

John

[webby]

Hi John

Hmm - the error-reports E_ALL or E_ALL & E_STRICT did not came up with anything - no error displayed?
May I send you the searchpage sourcecode - maybe you can come up with a solution?

(I have attach a screenshot of the "search-results")

Thank you

[webby]

Hi again

Buy the way... - I have also tried the droplet thing "Searchbox" in a test site... That do not work either!?

Webby

[pcwacht]

I think tyhe search.php itself is ok.
The droplet searchbox just makes a searchbox, there is no searchrelated code there.

I really think there is a leftover or a faulty module search wich breacks the search.

Can you look in your serverlogs? There lies the answer, I think.

[webby]

Hi again

Okay... Can I reinstall (remove and reinstall) the search-modul - and how?

Thank you

[pcwacht]

Again, I don't think it is the search modul

What I think
It is a database setting wich is made by a module setting something faulty wich leads to a search error
It might be gallery or guestbook
Dunnoh, need to see the entries in total and search forum for simular errors on these modules

If you want to reïnstall it, simply copy the folder /search over the exisiting one

You could allso remove the gallery and or guestbook to see if search will start working again

Myabe a better way for debugging,
get xampp, install WB, then install each extra module you use, one by one, after each one test search
This will give you the faulty module, then remove the search entries for that module in your live website. Search will start working again, I hope

If you do this and you find the faulty module, please post it here so others will know it to.

John

[dbs]

Myabe a better way for debugging,
get xampp...

maybe another good idea is websitebaker portable for debugging  

[webby]

Hi John

Thank you for your advice!
But before I do anything more...
If I send you the "search-database-file", will you then (maybe) be able to see what's wrong?
I'm not happy about reinstall all the modules one by one, because of the huge numbers of foto and text inside. I'm not shure to be able to reinstall it right again!? (The website is very large)

Thank you

[pcwacht]

Then I need:
the search db table
and the module addons you have installed, you don't need to zip tthose, a link to where you downed it will be good enough.

Then I can install the addons and see where it goes wrong, and correct your searchtable.

John

[webby]

Hi John

Ohw - that wil be nice...

Just to be shure:
- You need the search-db-table
- a list of the addons
but what do you mean with "a link to where you downed it"?

Thank you for your patience with me!

[pcwacht]

Just to be shure:
- You need the search-db-table
- a list of the addons

Correct

but what do you mean with "a link to where you downed it"?

I don't need the addon modules itself but a link to where you downloaded it, then I can download it there.
If you don't have the link then I need the addons as well
With addons I mean the added non core modules

John

[webby]

Hi John

Is there a smart and simple way to display all my addons (to you)?

[pcwacht]

You can mail them to me, see your pm

John

[pcwacht]

Ok, there was some mail, and finally I think I found the error

The imagegallery has a bad seacrh.php
At line 1;

Code:

<?php/**
[?code]
this need to be replaced with:
[code]
</php
/*

So at two lines and with one asterisk *


They allso stumbled upon this in german part -> http://www.websitebaker2.org/forum/index.php/topic,22352.0.html

As of this writing the solution is not yet confirmed.

John[/code]