Announcement

Collapse
No announcement yet.

MySQL Error : Incorrect information in file: './my_site/taggregate_temp_1414911360.frm'

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    Wayne Luke
    vBulletin Technical Support Lead

  • Wayne Luke
    replied
    You can drop them from the database.

    Leave a comment:

  • chaz7979
    Senior Member

  • chaz7979
    replied
    Yes, I had to manually delete the .frm file and it worked.

    If I have other _temp tables hanging around the DB should I just delete them?

    Leave a comment:

  • Wayne Luke
    vBulletin Technical Support Lead

  • Wayne Luke
    replied
    It is a temporary table used to aggregated view counts every hour. It should be deleted when the system is finished using it. Have your hosting provider delete the table if you cannot do it in phpMyAdmin. They may be able to do it just by deleting its corrupted files.

    Leave a comment:

  • chaz7979
    Senior Member

  • chaz7979
    replied
    I can't drop it or repair it. phpMyAdmin just throws an error;

    "#1051 - Unknown table 'taggregate_temp_1414911360'"

    Any ideas? What is this table? Where did it come from?

    Leave a comment:

  • Wayne Luke
    vBulletin Technical Support Lead

  • Wayne Luke
    replied
    You should be able to drop this table using whatever tool your hosting provider offers to manage databases. The most common is phpMyAdmin. Here is a tutorial:
    http://support.hostgator.com/article...-in-phpmyadmin

    Leave a comment:

  • chaz7979
    Senior Member

  • chaz7979
    replied
    Any ideas?

    Leave a comment:

  • chaz7979
    Senior Member

  • MySQL Error : Incorrect information in file: './my_site/taggregate_temp_1414911360.frm'

    I have been getting this same error for a couple of weeks at what seems to be random. I have no idea whats causing it and by the time I go into phpMyAdmin, the table seems to be deleted. Any ideas?

    Database error in vBulletin 4.2.2:

    Invalid SQL:
    SHOW CREATE TABLE `taggregate_temp_1414911360`;

    MySQL Error : Incorrect information in file: './my_site/taggregate_temp_1414911360.frm'
    Error Number : 1033
    Request Date : Sunday, December 7th 2014 @ 03:45:19 AM
    Error Date : Sunday, December 7th 2014 @ 03:46:18 AM
    IP Address : 50.151.235.47
    Username : Unregistered
    Classname : vB_Database

Related Topics

Collapse

Working...
X