Install Private Member Chat - Dashboard Installer

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

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 Install Private Member Chat Does

This installer prepares the website’s database for the Private Member Chat add-on, which lets members exchange direct messages on the site. It creates the storage that chat conversations live in and brings that storage up to the current specification. It does not change anything visible on the website by itself, and it does not turn the chat feature on. It only sets up the database structures the add-on needs.

  • Creates two new database tables: chat_message_threads, which stores one row per conversation (who started it, who is participating, its status, and when it was created and last updated), and chat_message_items, which stores the individual messages inside each conversation.
  • Ensures the message content column uses a storage type (LONGBLOB) that can hold the full range of characters, including emojis, so messages containing emojis save correctly.
  • Adds two informational columns to the conversations table: origin_ip (the IP address a conversation was started from) and request_uri (the page address it was started on).

Why It Appears

The installer shows up when the database is missing any part of this structure. Specifically, it has pending steps when:

  • The chat_message_items and chat_message_threads tables do not exist yet, which is typical for sites that have never set up the Private Member Chat add-on, or
  • The tables exist from an earlier installation but the message content column still uses an older storage type that cannot reliably hold emojis, or
  • The conversations table is missing the newer origin_ip and request_uri columns.

If the site set up the chat tables a while ago, only the later refinement steps may appear. That is normal for older installations and nothing to worry about.

Why It Matters

Without these tables, the Private Member Chat add-on has nowhere to save conversations, so installing them is a prerequisite for the feature to work. If the site's members already use chat, the emoji update prevents messages containing emojis from saving incorrectly, and the two new columns let the system record where each conversation was started. If the add-on is not in use, running the installer is still harmless: it creates empty tables and leaves everything else on the site untouched.

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, Install Private Member Chat appears in the list. Click Install.
  3. After it completes, click Check For Updates again — the entry disappears once all steps are done.

If Install Private Member Chat 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 new tables start out empty and only fill as members start conversations through the Private Member Chat add-on. If the tables already existed, any messages stored in them are preserved: the update adjusts a column type and adds columns, and it does not delete or rewrite existing chat data. There is nothing to verify afterward. If the add-on is in use, chat continues to work as before, now with emoji support and conversation origin tracking in place.