Customer Search Log

missesbeehaven:

Is this compatible with 1.5.4? The forum posts to this point only mention previous 1.3.9 and 1.5.1 but no mention of anything above 1.5.1. I would really like this functionality on my zen cart store

I updated to 1.5.4 about a month ago and it works great.

I installed version 2.2 of this plugin on zc1.54, and it seems to record searches just fine in the database OK since they display in the Reports>Search Log admin window.

However, when I try to export a .CSV copy of the searches, none of the searches are recorded in the .CSV file. The .CSV file only has header information ("Date","Search Term","Results"). Any suggestions?

owen26:

I installed version 2.2 of this plugin on zc1.54, and it seems to record searches just fine in the database OK since they display in the Reports>Search Log admin window.

However, when I try to export a .CSV copy of the searches, none of the searches are recorded in the .CSV file. The .CSV file only has header information ("Date","Search Term","Results"). Any suggestions?

Same here.

In case anyone is trying to do a reinstall of Search Log v2.1 in ZC v1.3.9h, after deinstalling for whatever reason, if your server's MySQL is a version greater than about v4.x, you'll need to make one small change in the search_log_install.sql file. Change the last line to say ENGINE=MyISAM; Then the install will proceed as expected. (I can stop beating my head on the wall now.)

Rob

Does any have any issues since upgrading to 1.5.5? All of my search terms in the log show as -1' and ==. Any clues?

2016-04-02 18:57:52 -1' 0
2016-04-02 18:57:51 == 0
2016-04-02 18:56:32 -1' 0
2016-04-02 18:56:30 == 0
2016-04-02 18:56:28 == 0
2016-04-02 18:49:17 == 0
2016-04-02 18:35:32 -1' 0
2016-04-02 18:35:31 == 0
2016-04-02 18:35:31 == 0
2016-04-02 18:30:50 -1' 0

jwlamb:

Does any have any issues since upgrading to 1.5.5? All of my search terms in the log show as -1' and ==. Any clues?

Never mind, my site was being attacked. Nothing to do with the plugin.

Any way of adding the IP address of the customer (regardless if logged in) to the search log?

Thank you.

I am modifying this as part of my upgrade/spring clean:

so the listing is now of the search term (once per language), a count of how many times that keyword has been searched for, the last results of that search, and the date of the last search.

If anyone wants a copy for pre-upload testing, please pm me.

If anyone wants a copy for pre-upload testing, please pm me.
I'll leave it here for a few days, I'd appreciate someone having a try before I upload it with stupid error in it!
https://dl.dropboxusercontent.com/u/57111073/search_log_2-3.zip

thanks

schobing:

I updated to 1.5.4 about a month ago and it works great.

Did you ever find a resolution? I'm still seeing the problem?

Trying to use the EXPORT AS CSV function, but the export has nothing in it but the headers? Any ideas on fixes?

I just tried the Export as CSV in v2.3 and v2.4 and the output was correct: contained both headers and actual search results data.

Please update version 2.4 download version to reflect zip version:

admin/stats_search_log.php
line 2
// Search Log v2.4

admin/includes/extra_datafiles/search_log.php
line 21
define('STATS_SEARCH_LOG_VERSION', '2.4');

Our site was attacked 3 days ago via SQL injection. We've made a full recovery of course, but is there a way to also log the IP of the user doing the search and have it saved in the database along with the rest of the saved data. It would help out in case someone attempts to do this again. We're on the latest version of zen cart but for some reason they were still able to fill up our server's hard drive and bring the site down for a couple hours before we noticed and did a restore.

Make sure you have followed the directions at http://www.zen-cart.com/wiki/index.php/Recovering_From_Hacks. Work with your host about blocking before they get to your site and try IP Blocker for blocking at the site.

Using zen cart 1.5.7 and search log version 2.4 I have found that attempting to use any of the sort by Asc / Desc options kicks me back to the admin index page.
Can anyone else confirm this behaviour with the same zc and module version?
Any ideas on a fix for this?

I resolved the issue.

I modified lines 153 to 161 from this:

<td class="dataTableHeadingContent" align="left" valign="top" width="20%"><?php echo (($_GET['list_order']=='searchdate' or $_GET['list_order']=='searchdate-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_DATE . '</span>' : TABLE_HEADING_DATE); ?><br />
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchdate', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchdate' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>  <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchdate-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchdate-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
</td>
<td class="dataTableHeadingContent" align="left" valign="top"><?php echo (($_GET['list_order']=='searchterm' or $_GET['list_order']=='searchterm-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_SEARCH_TERM . '</span>' : TABLE_HEADING_SEARCH_TERM); ?><br />
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchterm', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchterm' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>  <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchterm-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchterm-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
</td>
<td class="dataTableHeadingContent" width="20%"><?php echo (($_GET['list_order']=='searchresults' or $_GET['list_order']=='searchresults-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_RESULTS . '</span>' : TABLE_HEADING_RESULTS); ?><br />
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchresults', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchresults' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>  <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchresults-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchresults-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
</td>

To this:

<td class="dataTableHeadingContent" align="left" valign="top" width="20%">
<?php echo (($_GET['list_order']=='searchdate' or $_GET['list_order']=='searchdate-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_DATE . '</span>' : TABLE_HEADING_DATE); ?><br />
<a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchdate', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchdate' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>
<a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchdate-desc', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchdate-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
</td>
<td class="dataTableHeadingContent" align="left" valign="top">
<?php echo (($_GET['list_order']=='searchterm' or $_GET['list_order']=='searchterm-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_SEARCH_TERM . '</span>' : TABLE_HEADING_SEARCH_TERM); ?><br />
<a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchterm', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchterm' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>
<a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchterm-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchterm-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
</td>
<td class="dataTableHeadingContent" width="20%">
<?php echo (($_GET['list_order']=='searchresults' or $_GET['list_order']=='searchresults-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_RESULTS . '</span>' : TABLE_HEADING_RESULTS); ?><br />
<a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchresults', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchresults' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>
<a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchresults-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchresults-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
</td>

I've submitted an updated version of the mod for approval.

Added a small tweak: skip logging of searches performed from an IP in the Down for Maintenance exclusion list.

ZC: 158v
Php: 7.4
Template: Bootstrap Cloned

I just installed the search.log plugin. Don't know if it is just me but it doesn't appear to be logging searches made from an a mobile phone (i have a samsung) or tablet (android). It only captures search made online form a computer.