Clean database

[chikuru]

how can I check if there are any database fields from custom plugins or custom database fields that were not successfully deleted from the past?

[squidsk]

Easily, you can't. The not easy way is to look at the installs for all products you've uninstalled check for tables/columns added to the database and see if they're still there. This of course requires that you have access to the install files that you used. The difficult way is to setup a clean install of the appropriate vb version and then compare the tables in both dbs removing any non-vb ones that aren't from current products, then go through each table and do the same thing with columns, this again requires access to install files but only for those products that you're currently using.

[cellarius]

Look at install/mysql-schema.php. Every table or column not in there is not stock.

Be sure to have a backup.

If you have deleted your install directory, as you should, look it up in the download package for your version.

[puertoblack2003]

I know for wordpress there's a plugin that does that. It'll scan your current installed plugin to the uninstalled left over plugins and after the scan it'll give you a list for removal.It was a neat feature that i used. It brought down the database size.

I wish that vbulletin has that feature or pluggin.

[Lynne]

I have no idea if this still works - https://vborg.vbsupport.ru/showthread.php?t=235476&highlight=database (test on a test site first!!!!)