Search Log (v2.0) Add-on for Zen Cart

[dinix]

Hi
i just finish to install Search Log (v2.0) but I have a problem:
wend I press in Search Log Admin and I press Delete Search Records go see the Search Log and reports still in visibles.

secound problem is the offset time, the server have diferent time from my country.

[CJPinder]

i just finish to install Search Log (v2.0) but I have a problem:
wend I press in Search Log Admin and I press Delete Search Records go see the Search Log and reports still in visibles.

By default it keeps the last 7 days worth of searches. Enter 0 in the 'older than x days' box to delete all records.

secound problem is the offset time, the server have diferent time from my country.

If you are in a different time zone to your host then you will need to set the locale correctly in you main language file, e.g. admin/includes/languages/english.php if you are using english.

There is also a Time Zone Offset mod in the downloads area...
http://www.zen-cart.com/index.php?ma...roducts_id=145
...that maybe what you need.

Regards,
Christian.

[dinix]

Tanks for the answer but I try to put 0 press delete and the records remain.

[CJPinder]

Tanks for the answer but I try to put 0 press delete and the records remain.

How odd. Can you tell me what version of Zen Cart you are using and which version of PHP and MySQL?

Many thanks,
Christian.

[dinix]

Zen-cart Version: 1.3.8a
Database: MySQL 5.0.45-community-log
PHP Version: 5.2.5 (Zend: 2.2.0)

[tacoma]

I didn't even realize there was a new version.

I just updated and everything seems to work fine!

Thanks!

[edward.mcdougle]

If you are in a different time zone to your host then you will need to set the locale correctly in you main language file, e.g. admin/includes/languages/english.php if you are using english.

There is also a Time Zone Offset mod in the downloads area...
http://www.zen-cart.com/index.php?ma...roducts_id=145
...that maybe what you need.

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.