[Masiello]

Originally Posted by coderphp

execute this query:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )

Hello, the table that you have write already exist, this is the error with the product enabled:

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT MAX(`count`) AS m FROM vb_coder_searchstats;

MySQL Error : Table 'db.vb_coder_searchstats' doesn't exist
Error Number : 1146
Date : Thursday, February 22nd 2007 @ 08:34:40 PM
Script : http://www.mysite.com/index.php
Referrer : http://www.mysite.com/admincp/index.php?do=head
IP Address : xxx.xxx.xxx
Username : xxx
Classname : vb_database

I think have to create a table named vb_coder_searchstats and drop the table coder_searchstats.