Database Update: Install New Updates

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

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

What Database Update Does

The name is generic, but this installer has a clear focus: it modernizes how your website's database stores location and mapping data, and it bundles in a set of related database structure updates that newer platform features rely on. It changes how data is stored; it does not delete or rewrite your content.

The location and mapping changes are the headline items:

• Member listing coordinates: the lat and lon columns on the users_data table (the latitude and longitude saved with each member listing) are converted from text fields (varchar) to true decimal number columns, DECIMAL(10,8) for latitude and DECIMAL(11,8) for longitude. Decimal is the standard storage format for map coordinates, and your existing coordinate values are converted in place, not discarded.
• Visitor location lookups: database indexes are added to the location_ips table (used to match visitor IP addresses to geographic locations) on its ip_address, country_sn, and country_ln columns, which speeds up those lookups. If your site does not have this table, this part is skipped automatically.

The remaining steps are smaller database housekeeping updates bundled into the same installer:

• Converts the menu_link column on the menu_items table to a longer TEXT field with full Unicode (utf8mb4) support, so long menu URLs and special characters are stored without truncation.
• Adds a system_name identifier column to the data_categories table (your post types) if it is missing, and fills in the standard identifier for each post type by copying it from the platform's master definitions.
• Ensures each core platform table has an auto-incrementing primary key, adding one to any table where it is missing.
• Adds a form_action_div column to the forms table.
• Adds three columns to the email_schedule table (cache_data, last_error, and last_error_date) that the newsletter wizard uses to cache content and record sending errors.
• Adds a source column to the email_outbox table so outgoing emails can record which feature generated them.

Why It Appears

This installer runs eight separate checks against your database structure, and it appears whenever at least one of them finds your site still on the older format. In plain terms, it shows up when your database still stores latitude and longitude as text, is missing one of the location lookup indexes, or is missing any of the columns or keys listed above.

These are legacy conditions. Sites created more recently already have all of these structures in place, while databases created before these updates became standard will see this installer offered. Seeing it does not mean anything is broken; it means your database predates one or more of these structure updates.

Why It Matters

Storing coordinates as decimal numbers keeps location data consistent: numbers sort and compare as numbers, which is what maps and location-based features expect. The new indexes on the IP location table make those lookups faster, a modest performance improvement rather than a transformation. The added columns bring your database in line with what newer platform features expect, EG the newsletter wizard's error tracking and the email source tracking. Skipping the installer will not break your current site, but it leaves the database on the older structures that newer features are not built for.

How to Run It

1. From the admin dashboard, find the Install New Updates module and click Check For Updates.
2. If your site has pending steps, Database 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 Database Update does not appear in the list, your 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 your website. All of the updates are internal database structure changes: your member listings, menus, forms, and emails keep their existing data, and the coordinates already saved on your listings are preserved in the new numeric format. There is nothing to reconfigure afterward.

If you want to verify, check that member listings still show their locations on maps and that location searches behave normally. Click Check For Updates again and the entry disappears once all eight checks pass. Each step re-checks the database before making changes and only applies what is still missing, so the installer is safe to run even if part of the update was already applied earlier.