Why Vbulletin is automatically creating tables like aaggregate_temp_% or aaggregate_temp_%

If you are seeing that your vbulletin database hasĀ  a lot of temp database tables are getting created automatically with some names like ‘taggregate_temp_%‘ or ‘aggregate_temp_%‘. Then there can be two reason behind the scene

i)Your databases user doesnot have drop permission. Because vbulletin creates such temporary tables but this also gets dropped from the database.But if your db user doesnot have drop permission on databaseĀ  then obviously above temporary tables wouldn’t get deleted from the database.

ii)Check your threadviews table from the database. This table might be corrupt. If this table is corrupt then repair this one and your problem will get fixed.

Related posts:

The following two tabs change content below.

Chandra Shekhar

GCP Architect
Chandra Shekhar Pandey is Google certified Cloud engineer, I am Magento2 Trained developer. Having huge experience in designing cloud solution. I have around 12 years of experience with world enterprise IT companies and fortune 500 clients. During my architecture design I am always caring about high availability, fast performance and resilient system. From the programmer background I have huge experience in LAMP stack as well. Throughout my carrier I have worked on Retail, E-Learning, Video... Read More about Chandra Shekhar

Latest posts by Chandra Shekhar (see all)