194
Views
2
Comments
Database Cleanup

How do I cleanup extra columns in tables that are no longer in use?

"Inconsistent database table and entity definitions: column 'OSUSR_ko1_UserSubmission.ISDUPES' exists in database, but there is no corresponding attribute in entity 'UserSubmission'."

The "DBCleaner" (package) does not list these attributes and the DBCleaner API "Attribute_DropColumn(Integer)" in the refers to an integer but I have no idea what integer to use.

Help!

2019-07-02 14-20-37
Leen Rietveld

Hi,

If you run DBCleaner as an application in your (cloud) environment, these extra columns should appear automatically:

2016-10-01 08-04-21
FCC Webmaster

And that's my point, they don't show up there at all.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.