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]

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.