I need to clean up my hitlog using phpMyAdmin because currently my database is shut due to being over the limit. I want to clean out the referrals but keep the search referrals/terms in place. What fields should I search on if you can that holds the search referrals/terms?
I can barely understand what you will do, but if it's useful for you, the keyphrases are stored in the table evo_track__keyphrase, and also the field hit_keyphrase at the table evo_hitlog.
General Support
b2evolution CMS Support Forums
Update; I see the column "hit_referer_type; that field will be set to search. However, where are the search terms stored?