dear member i am trying to update counter and i get this message Database error in vBulletin 4.0.1: Invalid SQL: INSERT INTO searchgroup_text (searchgroupid, title) VALUES ( 12, 'French 1978 DVDRIP' ) ON DUPLICATE KEY UPDATE searchgroupid = VALUES(searchgroupid), title = VALUES(title); MySQL Error : Table '****_*****.searchgroup_text' doesn't exist Error Number : 1146 Request Date : Friday, February 19th 2010 @ 10:49:43 AM Error Date : Friday, February 19th 2010 @ 10:49:43 AM Script : *****.net/admincp/misc.php?do=updatethread Referrer :.*****.net/admincp/misc.php IP Address : 81.85.****.23 Username : **** Classname : vB_Database MySQL Version : 5.0.89-community Code (markup): so i have try to add this on db CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "searchgroup_text( searchid INT UNSIGNED NOT NULL AUTO_INCREMENT, userid INT UNSIGNED NOT NULL DEFAULT '0', ipaddress CHAR(15) NOT NULL DEFAULT '', personal SMALLINT UNSIGNED NOT NULL DEFAULT '0', query VARCHAR(200) NOT NULL DEFAULT '', searchuser VARCHAR(200) NOT NULL DEFAULT '', forumchoice MEDIUMTEXT, prefixchoice MEDIUMTEXT, sortby VARCHAR(200) NOT NULL DEFAULT '', sortorder VARCHAR(4) NOT NULL DEFAULT '', searchtime float NOT NULL DEFAULT '0', showposts SMALLINT UNSIGNED NOT NULL DEFAULT '0', orderedids MEDIUMTEXT, announceids MEDIUMTEXT, dateline INT UNSIGNED NOT NULL DEFAULT '0', searchterms MEDIUMTEXT, displayterms MEDIUMTEXT, searchhash VARCHAR(32) NOT NULL DEFAULT '', titleonly SMALLINT UNSIGNED NOT NULL DEFAULT '0', completed SMALLINT UNSIGNED NOT NULL DEFAULT '1', PRIMARY KEY (searchid), UNIQUE KEY searchunique (searchhash, sortby, sortorder) ) Code (markup): and i get this message on my phpmy admin #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 '" . TABLE_PREFIX . "searchgroup_text( searchid INT UNSIGNED NOT NULL AUTO_I' at line 1 Code (markup): what should i do ?