Recreate table

[chikuru]

Database error in vBulletin 4.2.2:

Invalid SQL:

        INSERT INTO taggregate_temp_1492976820
                SELECT threadid, COUNT(*) AS views
                FROM threadviews
                GROUP BY threadid;

MySQL Error   : Can't find file: 'threadviews' (errno: 2)

Whats the query to recreate that table in vbulletin 4.2?
Thanks!

[Paul M]

You can get it from the mysql-schema.php file, in the install folder.

[chikuru]

Thanks!

The missing threadviews table caused the database to create lots of taggregate_temp_xxxx tables.
Is there sql query to delete them all at once? Because I cant manually delete them because phpmyadmin hangs when I tried to load the database. Thanks!

[Andreas]

Unfortuatenly, there is no way to delete all those tables with one query.

You could do some trickery with information_schema though:
http://stackoverflow.com/questions/1...es-with-prefix

Alternatively you could run a simple script:

PHP Code:

require('./global.php');

$tables = $db->query_read("SHOW TABLES LIKE 'taggregate\_temp\__%'");
while ($table = $db->fetch_row($tables))
{
    $db->query_write("DROP TABLE `$table[0]`");
} 


No guarantees whatsoever, eg. you should be prepared to have a backup ready if anything goes wrong

[chikuru]

Thanks Andreas! Problem solved
More than 100,000 temp tables have been removed