Text labels: Install New Updates
Link: https://support.brilliantdirectories.com/support/solutions/articles/12000109025
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 Text labels Does
Text labels are the editable words and phrases your 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 your 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 your database predates this improvement.
Why It Matters
Duplicate label rows are the main problem this solves. When the same label exists twice, editing your site text can behave unpredictably: you may change one copy in the admin while the website keeps reading the other, so your 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 your labels say.
How to Run It
- From the admin dashboard, find the Install New Updates module and click Check For Updates.
- If your 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, your website is already up to date — the module only shows installers with pending steps, so there is nothing to do.
After Running
Your 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 you see that notification, review the labels it lists in the Text Labels area of your admin and confirm the wording is what you expect. No other follow-up is needed, and future duplicates are prevented automatically by the new uniqueness rule.
