Search Log

[CJPinder]

Has anyone else found that, with Search Log installed, searching for a string containing an apostrophe causes an error?

The error you are getting looks like it is with the SuperTracker mod rather than either of the Search Log mods. Probably best to post the error in the SuperTracker support thread.

Regards,
Christian.

[christoph_lutz]

Hi there, just came across the same problem with apostrophes. A common oversight in php coding. Just wrap the "$keyword" in step 4 in the instructions in the php function mysql_real_escape_string like so

$searchsql = "insert into " .DB_PREFIX. "search_log (searchterm, date) values ('". mysql_real_escape_string($keyword )."','$mydate')";


And all should be good - worked fine for me

Christoph

[christoph_lutz]

Having spent a bit more time on this now, I have got a few suggestions for the author

- instead of putting the code amendments into one of the core files, put it in this file
/includes/templates/YOURTEMPLATE/templates/tpl_modules_product_listing.php
This has the added advantage of doing something I wanted to do: record the numbers of returned results of any search (see next point)
- record the number of returned results. With an increasing number of products in my shop (3500 at the moment) and meta tags and descriptions, it is sometimes hard to know if a search is actually successful. Do this by adding another column to the table, add it to the sql query and use $listing_split->number_of_rows to record it. In the query to return the results, then also group by the results column
- add a link to run the search on the site in the admin/report too. This way you can see what the users see when they search for a keyword, order of results, etc.

Hope you find these good ideas

Christoph

[CJPinder]

Christoph,

Have a look at the new Search Log contrib I wrote. It is in the downloads section here...
http://www.zen-cart.com/index.php?ma...roducts_id=702

It records the number of search results and has been written so that no files have to be modified.

Regards,
Christian.

[kbalona]

This was a great mod, but since I installed 1.3.8a it no longer logs all the searches, only the searches that have results. Therefore it's basically useless.

[tacoma]

I have the same problem. The searches with 0 results aren't recorded.

[CJPinder]

I have the same problem. The searches with 0 results aren't recorded.

If you are referring to the Search Log mod that I wrote (rather than the one this thread was originally about) then it is a known issue with using it on ZC v1.3.8. I'm working on an update.

Regards,
Christian.

[tacoma]

If you are referring to the Search Log mod that I wrote (rather than the one this thread was originally about) then it is a known issue with using it on ZC v1.3.8. I'm working on an update.

Regards,
Christian.

I apologize Christian. I had thought the version I had, which is the latest, was your version. Your link goes to both your version and Paul's version.

I have the 1.1.1 version from Paul.

Thank you for your add-on and updates.

[CJPinder]

I apologize Christian. I had thought the version I had, which is the latest, was your version. Your link goes to both your version and Paul's version.

I have the 1.1.1 version from Paul.

Thank you for your add-on and updates.

I hadn't actually noticed that someone had uploaded a version 1.1.1 (which is my v1.0 plus a few changes). They probably should have posted something about it. Maybe I missed it. Despite what it says on the download page, the version they have uploaded will not work properly with ZC v1.3.8.

I will release a proper ZC 1.3.8 compatible version next week.

Regards,
Christian.

[DrByte]

If you are referring to the Search Log mod that I wrote (rather than the one this thread was originally about) then it is a known issue with using it on ZC v1.3.8. I'm working on an update.

There was a feature change to 1.3.8 whereby if there are 0 results to a search, the customer is redirected to the search input page to enter new selections, rather than a blank page.

This means that instead of monitoring the NOTIFY_HEADER_END_ADVANCED_SEARCH_RESULTS notifier point, you have to monitor an earlier notifier point instead: NOTIFY_SEARCH_ORDERBY_STRING
Making that change to the class.search_log.php file should suffice, and should work fine with earlier Zen Cart versions as well.