Revision Count - Post Types Update - Dashboard Installer

Link: https://support.brilliantdirectories.com/support/solutions/articles/12000109098

The Install New Updates module on the admin dashboard lists one-time platform installers that still have pending steps on the site. Clicking the green Check For Updates button refreshes the list — an installer only appears when the site actually has something left to install, and it disappears from the list once its steps are complete.

What Revision Count - Post Types Update Does

This installer makes three small database structure changes that newer post type features rely on. It adds a save-counter column to the post tables and relaxes two real estate fields so they can be left empty. It changes how data is stored, it does not delete or rewrite the posts.

The three steps do the following:

• Revision count column: adds a revision_count column (BIGINT, default 0) to both the data_posts table and the users_portfolio_groups table, placed after the state_sn column. This column counts how many times a post has been saved.
• Property square footage: changes the property_sqr_foot column on the users_portfolio_groups table to DECIMAL(10,2) that allows empty (NULL) values, so the field can be left blank.
• Property price: changes the property_price column on the users_portfolio_groups table to DECIMAL(20,2) that allows empty (NULL) values, so the field can be left blank. If the site does not have a property_price column at all, this step reports nothing to run and is skipped.

Why It Appears

The installer runs three status checks against the database structure and appears whenever at least one still has work to do. In plain terms, it shows up when revision_count is missing from either data_posts or users_portfolio_groups, when the property_sqr_foot column does not yet allow empty values, or when the property_price column does not yet allow empty values.

These are legacy conditions. Databases created before these column updates became standard will see the installer offered. Seeing it does not mean anything is broken, it means the database predates one or more of these structure updates.

Why It Matters

The revision_count column gives the platform a place to track how many times a post has been saved, which post type features use. Allowing the property square footage and property price fields to hold empty values means members can leave those fields blank instead of being forced to enter a number, which matters for real estate style post types. Skipping the installer will not break the current site, but it leaves the database on the older structures that these features expect.

How to Run It

1. From the admin dashboard, find the Install New Updates module and click Check For Updates.
2. If the site has pending steps, Revision Count - Post Types Update appears in the list. Click Install.
3. After it completes, click Check For Updates again. The entry disappears once all steps are done.

If Revision Count - Post Types Update does not appear in the list, the website is already up to date. The module only shows installers with pending steps, so there is nothing to do.

After Running

Nothing changes visibly on the website. The updates are internal database structure changes: the posts keep their existing data, the new revision_count column starts at 0, and the two property fields can now be saved empty. There is nothing to reconfigure afterward.

The revision count step re-checks both tables before adding the column, and the two property field steps re-apply the same column definition, so the installer is safe to run even if part of the update was applied earlier. Click Check For Updates again and the entry disappears once all three checks pass.