Customer Search Log

[BlessIsaacola]

Hi installed and it is very straightforward. Very nice mod.

It's absolutely fabulous mod and with the integration of added features from 1.1.1 it's even a better mod :)

[CJPinder]

For now I uploaded all file from version 2.0 and replaced your admin\stats_search_log.php with the one from Paul's version 1.1.1 and that provided the report that I am looking for. I am not sure if this is the right approach but it works.

I can't see any problems with doing that. Should work fine.

Regards,
Christian.

[blackhalo]

Yeah, this mod is cool...

More features would be nice...keeping a Marketing/SEO point of view in mind.

I think Google Analytics offers this type of tool for your site,
I'm sure there's some good ideas to be copped from their version.

Some people don't believe in offering Google their entire business model, advertising strategy and sales information on a silver platter...
so those people have to do without the handy little features like search stats...this Search Log mod helps overcome that problem!

Thanks man, good work!

[edward.mcdougle]

Hello everyone,

Does anyone have Search Log v2.0 working with v1.3.8a of the Time Zone Offset mod by Gilby?
http://www.zen-cart.com/index.php?ma...roducts_id=145

Whilst the Time Zone Offset mod offsets all other times correctly, the Search Log still shows the incorrect time.
In an unsuccessful attempt to resolve this, the following change was made, however, new searches still do not show the offset time.

\includes\classes\observers\class.search_log.php

Line 47 - Changed from:

$sql = 'insert into ' .DB_PREFIX. 'search_log (search_term, search_time, search_results) values (:searchTerm,now(),:searchResults)';

To:

$sql = 'insert into ' .DB_PREFIX. 'search_log (search_term, search_time, search_results) values (:searchTerm,date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR),:searchResults)';

Can anyone advise what other changes in addition to, or instead of the above, are required to fix this?
If relevant, Zen Cart is v1.38a, PHP is v5.2.6 and MySQL is v5.0.51a-community

Testing on an otherwise clean installed Zen Cart with correct locale setting, and only the Search Log and Time Zone Offset mods installed shows the problem remains, and is seemingly not related to any incompatibility with other mods.

Many thanks,
Edward McDougle.

[DrByte]

You used double-quotes when inserting the constant value into the query, but the rest of the syntax is using single-quotes. Thus the name of your constant, along with its quotes, is being sent literally to the query. I'm surprised MySQL didn't croak on it.

[edward.mcdougle]

Thanks DrByte, your suggested fix resolved that problem.

Just one more issue remains, that being the date format, which is shown in the wrong format:
For example, 2008-08-10 01:02:52, where it should be 01:02:52 10-08-2008

Elsewhere, the date format is correct as per the locale setting.

Many thanks,
Edward McDougle.

[DrByte]

The date must be stored in the database in YYYY-MM-DD HH:MM:SS format. That's what MySQL requires.

If you're not happy with the way the search log *report* shows the output, you'll have to alter the code of the contribution to have it render the display to your liking. You can probably use the changes introduced by other files in your timezone-offset addon as an example for how to change other things such as your report.

[edward.mcdougle]

Thank you for your help DrByte.

[ShoesBuyOnline]

Hi,

Good job! Combining using this add-on with Google Analytics, we would get what keywords do well and what to develop!

Thanks for your job,

[MischiefDesignz]

I have installed this to Zen 1.3.9 c, and it is not showing up under the admin>reports, how do I add this , thanks for any help