Administrative and Maintenance Tools - [DBTech] vBSearch Log v1 (vB3)

Why use, vBSearch Log?
Myself, as alot of members on here, have at times wanted to know what the members or guests are searching for on our sites. vBSearch Log logs every search query made on your forum after installation. Useful to see what the members or guests are searching for on our sites.

Lets say you run a site that is about cars. You look in the search log and see that there is quite a few searches for Corvette Stingray. Now you look on your forums and see there is not to much information about Corvette Stingray. So what you could do is find some info to post in your forums about that.

Lets say you run a site that is about gaming. You look in the search log and see that there is quite a few searches for Borderlands 2. Now you look on your forums and see there is not to much information about Borderlands 2. So what you could do is find some info to post in your forums about that.

So in theory, by adding missing information about such things should, retain your existing members and get guests to register, cause members and guests found what they are looking for, and have no need to go look elsewhere.

-------------------------------------------------------------------------------------------

If you like this mod please hit the button to the right ---->

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Other addons available @ www.DragonByte-Tech.com/forum

There are no vB settings settings for the mod.

-------------------------------------------------------------------------------------------------------

This mod displays NO copyright notification in the footer as it is a admin only mod.

[cheech47]

Im getting an error when trying to look at the logs:

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT DISTINCT dbtech_search_log.userid, user.username
FROM dbtech_search_log AS dbtech_search_log
INNER JOIN user AS user USING(userid)
ORDER BY username;

MySQL Error : Table 'XXXadmin_XXXforums.dbtech_search_log' doesn't exist
Error Number : 1146
Request Date : Saturday, May 18th 2013 @ 12:01:31 PM
Error Date : Saturday, May 18th 2013 @ 12:01:31 PM
Script : http://www.xxx.com/forums/admincp/db....php?do=select
Referrer : http://www.xxx.com/forums/admincp/index.php?do=nav
IP Address : XXX.XXX.XXX.XXX
Username : Mine
Classname : vB_Database
MySQL Version : 5.1.68-cll

[DragonByte Tech]

Originally Posted by cheech47

Im getting an error when trying to look at the logs:

Sorted, uninstall the mod, redownload the files and proceed as a fresh install. I dunno how it was missing the install but it was.

Chris

[christon26]

I got that too but the first time I tried to install my database glitched at the same time so I thought it was that LOL and just used the sql in the 100.php file to create the table myself :P

[DragonByte Tech]

Lol cool, but you should still import the new xml, so if yo happen to uninstall the mod, the table gets removed.

Chris

[cheech47]

Still getting the same error as before, re-uploaded all files and re-imported the xml, as soon as you go to the option in the admincp the error shows

[ozzy47]

Did you uninstall the mod first? If no you need to do so in order to activate the installer.

[cheech47]

Originally Posted by ozzy47

Did you uninstall the mod first? If no you need to do so in order to activate the installer.

I had, removed everything including uploaded files instead of overwriting, reinstalled and its now working, thanks

[DragonByte Tech]

Originally Posted by cheech47

I had, removed everything including uploaded files instead of overwriting, reinstalled and its now working, thanks

That's good to here, thanks for reporting back.
Chris

[juan71287]

Let me give it a shoot

Hope to have it In a Positive Use