Table 'tachyforumcounter' doesn't exist

[Prorockz]

Database error in vBulletin 3.8.7:

Invalid SQL:
DELETE FROM tachyforumcounter WHERE forumid = 2;

MySQL Error   : Table 'database_name.tachyforumcounter' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 2nd 2012 @ 01:57:17 PM
Error Date    : Wednesday, May 2nd 2012 @ 01:57:17 PM
Script        : http://www.*******.com/inlinemod.php?do=domovethreads&threadids=6381,4906
Referrer      : http://www.*********.com/login.php?do=login
IP Address    : ***********
Username      : *************
Classname     : vB_Database
MySQL Version : 5.1.62-cll

Please Tell me Solution to It.

[Lynne]

And if you look at your database, do you see the table? Did you run the upgrade.php script when you upgraded?

[Prorockz]

yes i did so can some one tell me what table is this i mean what is perpose of it?
also is it a Built in Table?
there is no Table in It.

[Lynne]

It is a default vbulletin table. You can look in your /install/mysql-schema.php file and get the schema for it and create a new one.

[souperman]

CREATE TABLE `tachyforumcounter` (
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `forumid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `threadcount` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `replycount` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Just add your prefix if you have one.

[Prorockz]

ran this query but still that problem and can't open that PHP

[borbole]

Originally Posted by Prorockz

ran this query but still that problem and can't open that PHP

What php can''t you open?

[Prorockz]

MySQL Schema: $db is not an instance of the vB Database class. This script requires the escape_string() method from the vB Database class.

Its showing me this

[Lynne]

It is a query that you run in phpMyAdmin. You don't put it in a file to run.