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.
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 Conferencing and social media domain. The motive of creating cutehits was just to share the knowledge/solutions I get to know during my day to day life so that if possible I can help someone for same problems/solutions. CuteHits.com is a really a very effort for sharing knowledge to rest of the world. For any query/suggestion about same you can contact me on below details:-
Email: shekharmca2005 at gmail.com
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.