Customer Search Log

nvm my error.......

Hi,

MischiefDesignz:

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.

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!!!
:clap:

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?

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

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

Change the sql statement from

TYPE=MyISAM
to
ENGINE=MyISAM

and that will take care of the problem.

countrycharm:

Change the sql statement from

TYPE=MyISAM
to
ENGINE=MyISAM

and that will take care of the problem.

Thank you thats sorted the problem.

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

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

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

Can this module track actual customers who perform searches or does it just keep a record of the search term (keywords entered),date/time of the search and the number of results returned. I have an older version of this mod installed, which works great, however it does not list which of my clients has performed the various searches, I would like to see this so that I can get stock of the product and inform each customer which has performed that specific search.

Thanks.

I am attempting to install Search Log 2.1. I am using 1.3.8f
I was able to download a file called Downloads.php.
I am looking for a file call Search_Log.sql so I can do the following
Admin->Tools->Install SQL Patch, run the included SQL file (search_log.sql)
QUESTION:
Where do I find the abve mentioned sql file?
This is a wonderful tool for me.
When I finished istalling it where will I find it so I can use it?

I

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
also for me, same issue :-(

SoftCorpse:

Can this module track actual customers who perform searches or does it just keep a record of the search term (keywords entered),date/time of the search and the number of results returned. I have an older version of this mod installed, which works great, however it does not list which of my clients has performed the various searches, I would like to see this so that I can get stock of the product and inform each customer which has performed that specific search.

Thanks.

Exactly what I was looking for. I have search log 2.0 with zen ver 1.5.1. This current version has been working without issues, but when I have searches that don't make sense, I would like to contact that customer to see what exactly it is they are looking for.

Thank you, Justin

Great Tool!

However I am wondering why I am getting numerous occurrences of the following:

Any Ideas Anyone?

Thanks,
Danny

Have you tried to recreate that log by entering random nothingness into the search? try different browsers?

I am getting this error.

1146 Table '********zen_admin_pages' doesn't exist
in:
[SELECT @max_sort_order_reports:=max(sort_order) FROM zen_admin_pages WHERE menu_key = 'reports';]

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'm pretty sure it is compatible with 1.5.3 and 1.5.4

Thank you DrByte > DrByte:

I'm pretty sure it is compatible with 1.5.3 and 1.5.4