Text labels - Dashboard Installer
Link: https://support.brilliantdirectories.com/support/solutions/articles/12000109025
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 Text labels Does
Text labels are the editable words and phrases the website uses throughout its pages, and they are stored in a database table called website_labels. This installer applies two housekeeping updates to that table.
- It widens the field_type column to the LONGTEXT storage type so it can hold longer values than the previous format allowed.
- It adds a uniqueness rule (a unique index) to the field column, which is the identifier of each label. This guarantees each label can exist only once in the table. If the site already contains duplicate copies of a label, the installer first removes the older copies, keeping the most recently created row for each duplicated label, and records a notification listing exactly which labels were affected.
Why It Appears
This update is age related. Sites created before the current database format still have the field_type column in an older, shorter format, or do not yet have the uniqueness rule on the field column. The installer checks the two conditions separately, so it can appear even if only one of them still needs the update. Seeing it does not mean anything is broken; it means the database predates this improvement.
Why It Matters
Duplicate label rows are the main problem this solves. When the same label exists twice, editing the site text can behave unpredictably: one copy may change in the admin while the website keeps reading the other, so the edit never seems to take effect. The uniqueness rule makes that situation impossible going forward, and the built-in cleanup resolves any duplicates that already exist. This is a data integrity update rather than a visible change; it does not alter what the labels say.
How to Run It
- From the admin dashboard, find the Install New Updates module and click Check For Updates.
- If the site has pending steps, Text labels appears in the list. Click Install.
- After it completes, click Check For Updates again — the entry disappears once all steps are done.
If Text labels 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
The site’s text stays the same in almost all cases. The one exception is a site that had duplicate labels: for each duplicated label, the most recently created version is kept and the older copies are deleted, and the installer records a notification naming the removed duplicates. If that notification appears, review the labels it lists in the Text Labels area of the admin and confirm the wording is what is expected. No other follow-up is needed, and future duplicates are prevented automatically by the new uniqueness rule.
