Search does not work anymore

[killerwhale65]

Hi,

 

Since a while the search function does not work anymore. No matter what i enter, no products are found. Here is the site: www.tm-solutions.be

 

I have a local copy of this site running on my own server. Here it works fine! I have already re-uploaded advanced_search_result.php, but it still does not work online.

 

Any ideas?

 

thanks!

 

Matt

[♥ecartz]

Have you tried running the search query manually in something like phpMyAdmin? Has your host updated MySQL or PHP recently that behavior might have changed? Have you changed any tables from the default MyISAM engine to the InnoDB engine?

[masat]

Verify your configure.php settings. If they are not correct you can get behavior such as you describe. I think it is because the session id is getting lost due to improper path definitions. When a search is done the search term is placed in the url and fetched as a $_GET. If the paths in config are not right the posting of the search term to the url will disrupt the tracking of the session id variables.

[killerwhale65]

hello,

 

I have discovered something very strange in phpmyadmin. When i explore the products_description table, everything seems normal and all things i try to search for are there.

But then i tried the search tab in phpmyadmin, and the result was 0 rows.

 

Then i tried exporting the table, and discovered this for every product:

 

INSERT INTO `products_description` VALUES (2854, 4, 0x485020454c495445424f4f4b203837333057, NULL, NULL, 0);

 

That strange number (different for every product) is supposed to be the product name. What is that? It does show up ok in the database and on the website.

 

thanks!

 

Matt