Customer Search Log

[MischiefDesignz]

nvm my error.......

[CJPinder]

Hi,

nvm my error.......

You beat me too it, I was just about to reply to your previous post. Glad you got it working. I hope you find the add-on useful.

Regards,
Christian.

[sabastina]

Awesome Mod, Thanks alot!!!

I just wanted to post to confirm that this mod DOES work on zc v1.3.9h!!!
Additionally, I couldn't find a thread for your Keep Cart mod, which has also been sucessfully installed on my ZC v1.3.9h site.

Wonderful work!!!

[teoB]

Hi,
I 'm using this plugin with 1.3.8. and it's working great! Only one major problem at least for me. When search term contains Greek characters I'm getting '?????????' at search term field. So is this working only for English characters?

[directpc]

Hi,

Im trying to install this and having a problem with the sql file. Im installing on version 1.39, Ive installed this a few times with no problems but this time, when adding the sql file, im getting the following error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE search_log ( search_log_id int NOT NULL auto_increment, search_term varchar(255), search_time datetime, search_results int, PRIMARY KEY (search_log_id) ) TYPE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I would be very greatful if somebody can help me with this error

Thanks

[countrycharm]

Hi,

Im trying to install this and having a problem with the sql file. Im installing on version 1.39, Ive installed this a few times with no problems but this time, when adding the sql file, im getting the following error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE search_log ( search_log_id int NOT NULL auto_increment, search_term varchar(255), search_time datetime, search_results int, PRIMARY KEY (search_log_id) ) TYPE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I would be very greatful if somebody can help me with this error

Thanks

Change the sql statement from

TYPE=MyISAM
to
ENGINE=MyISAM

and that will take care of the problem.

[directpc]

Change the sql statement from

TYPE=MyISAM
to
ENGINE=MyISAM

and that will take care of the problem.

Thank you thats sorted the problem.

[torvista]

I assume by the lack of comments everyone finds the download CSV function to work ok?

[torvista]

I have uploaded a new version: 2.2
http://www.zen-cart.com/downloads.php?do=file&id=485

- removed Search Log Admin (tools) page and moved the delete logs/save csv functionality into the Search Log (reports) page
- corrected form submission code to delete logs/save csv (was not working in ZC 1.51)
- corrected validation errors
- added links to plugin and support pages
- added spanish constants
- minor changes and correction to install/uninstall sql
- removed obsolete 1.39 files
- edited readme

[SoftCorpse]

Hi is there an easy way to display which customer searched for each term in the search log?