Compare commits

..

10 Commits

Author SHA1 Message Date
gitea-actions[bot] a2ba10c562 chore(version): pre-release bump to 01.07.09-dev [skip ci] 2026-07-06 22:41:46 +00:00
gitea-actions[bot] e94a950cb0 chore(version): pre-release bump to 01.07.08-dev [skip ci] 2026-07-06 22:40:10 +00:00
gitea-actions[bot] c64c503f5d chore(version): pre-release bump to 01.07.07-dev [skip ci] 2026-07-06 22:39:54 +00:00
jmiller 2b56dc411a feat(menu): use COM_MOKOOG_SHORT for admin menu label (#119)
Universal: PR Check / Branch Policy (pull_request) Successful in 3s
Universal: PR Check / Validate PR (pull_request) Failing after 6s
Generic: Project CI / Lint & Validate (pull_request) Successful in 16s
Universal: PR Check / Secret Scan (pull_request) Successful in 7s
Joomla: Metadata Validation / Validate Joomla Metadata (pull_request) Failing after 10s
Universal: Pre-Release / Build Pre-Release (${{ inputs.stability || github.ref_name }}) (push) Successful in 23s
Generic: Project CI / Tests (pull_request) Has been cancelled
Universal: PR Check / Build RC Package (pull_request) Has been cancelled
Universal: PR Check / Report Issues (pull_request) Has been cancelled
Claude-Session: https://claude.ai/code/session_01B9aZHSWbiiZykJD88pYx8R
2026-07-06 22:37:44 +00:00
jmiller 6ef67d9ca7 feat(menu): add COM_MOKOOG_SHORT short-name constant (#119)
Universal: Pre-Release / Build Pre-Release (${{ inputs.stability || github.ref_name }}) (push) Successful in 13s
Claude-Session: https://claude.ai/code/session_01B9aZHSWbiiZykJD88pYx8R
2026-07-06 22:37:10 +00:00
jmiller cf744a8bd2 Merge pull request 'fix(installer): gate update() + enqueueMessage for success (og-com tidy)' (#122) from fix/og-installer-tidy into dev
Universal: Auto Version Bump / Version Bump (push) Has been skipped
Universal: Pre-Release / Build Pre-Release (${{ inputs.stability || github.ref_name }}) (push) Successful in 23s
2026-07-06 16:24:41 +00:00
jmiller dbaeb33dc4 fix(installer): gate update() on schema + use enqueueMessage for success
Universal: PR Check / Branch Policy (pull_request) Successful in 2s
RC Revert / Rename rc/ back to dev/ (pull_request) Has been skipped
Branch Cleanup / Delete merged branch (pull_request) Failing after 1s
Universal: PR Check / Validate PR (pull_request) Failing after 5s
Universal: PR Check / Secret Scan (pull_request) Successful in 8s
Joomla: Metadata Validation / Validate Joomla Metadata (pull_request) Failing after 9s
Universal: Pre-Release / Build Pre-Release (${{ inputs.stability || github.ref_name }}) (push) Failing after 5s
Generic: Project CI / Lint & Validate (pull_request) Successful in 27s
Generic: Project CI / Tests (pull_request) Has been cancelled
Universal: PR Check / Build RC Package (pull_request) Has been cancelled
Universal: PR Check / Report Issues (pull_request) Has been cancelled
Mirrors the install() smart-check on update() and replaces echo with a proper
Joomla message for consistency.

Claude-Session: https://claude.ai/code/session_01MrxXW9iyuDda5yDZrjZMbF
2026-07-06 16:24:15 +00:00
jmiller fe38a422be Merge pull request 'fix(installer): gate install-success on real verification' (#120) from fix/installer-success-detection into dev
Universal: Auto Version Bump / Version Bump (push) Has been skipped
Universal: Pre-Release / Build Pre-Release (${{ inputs.stability || github.ref_name }}) (push) Failing after 5s
2026-07-06 16:15:36 +00:00
gitea-actions[bot] a6fe8fb580 chore(version): pre-release bump to 01.07.05-dev [skip ci]
RC Revert / Rename rc/ back to dev/ (pull_request) Has been skipped
Branch Cleanup / Delete merged branch (pull_request) Successful in 1s
2026-07-06 03:55:02 +00:00
jmiller a6a24f72de fix(installer): gate install-success on real verification
Universal: Pre-Release / Build Pre-Release (${{ inputs.stability || github.ref_name }}) (push) Successful in 22s
Joomla installers keep running after a failed sub-step, so a postflight
"installed successfully" / next-steps message can lie. Gate the success
path in both installer scripts.

Package (source/script.php): postflight now verifies every child extension
declared in the package manifest actually registered in #__extensions
(element + type, plus folder for plugins). If any are missing it enqueues
an error listing them and returns before the licence notice. Download-key
restore and plugin-enable housekeeping still run unconditionally. Check
fails open on any error.

Component (source/packages/com_mokoog/script.php): install() now parses the
installed SQL (JPATH_ADMINISTRATOR/components/com_mokoog/sql/install.mysql.sql)
for CREATE TABLE declarations and verifies each exists (prefix-substituted,
case-insensitive) before echoing the success message. Fails open if the SQL
is unreadable.

Claude-Session: https://claude.ai/code/session_01MrxXW9iyuDda5yDZrjZMbF
2026-07-05 22:54:38 -05:00
19 changed files with 104 additions and 106 deletions
+1 -1
View File
@@ -5,7 +5,7 @@
# FILE INFORMATION # FILE INFORMATION
# DEFGROUP: Gitea.Workflow # DEFGROUP: Gitea.Workflow
# INGROUP: mokocli.Automation # INGROUP: mokocli.Automation
# VERSION: 01.07.06 # VERSION: 01.07.09
# BRIEF: Auto-create feature branch when an issue is opened # BRIEF: Auto-create feature branch when an issue is opened
name: "Universal: Issue Branch" name: "Universal: Issue Branch"
+1 -4
View File
@@ -4,13 +4,10 @@ All notable changes to MokoSuiteOpenGraph will be documented in this file.
The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.1.0/). The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.1.0/).
<!-- VERSION: 01.07.06 --> <!-- VERSION: 01.07.09 -->
## [Unreleased] ## [Unreleased]
### Fixed
- **Honest install success** — the installer no longer claims success or shows the license message when the install partially failed. The package postflight verifies every child extension declared in the manifest registered in `#__extensions`; the `com_mokoog` component script verifies its declared tables exist before echoing the success message. Both checks fail open, so a transient DB/IO glitch never fakes a failure.
### Added ### Added
- OG coverage **dashboard** as the default admin view — SVG donut gauge, coverage by content type, and a list of articles missing OG tags with a batch-generate shortcut (#94) - OG coverage **dashboard** as the default admin view — SVG donut gauge, coverage by content type, and a list of articles missing OG tags with a batch-generate shortcut (#94)
- Single OG tag **create/edit screen** in the admin (the tag manager was previously read-only) (#98) - Single OG tag **create/edit screen** in the admin (the tag manager was previously read-only) (#98)
+1 -1
View File
@@ -14,7 +14,7 @@
DEFGROUP: Template-Joomla DEFGROUP: Template-Joomla
INGROUP: Template-Joomla.Documentation INGROUP: Template-Joomla.Documentation
REPO: https://github.com/mokoconsulting-tech/Template-Joomla/ REPO: https://github.com/mokoconsulting-tech/Template-Joomla/
VERSION: 01.07.06 VERSION: 01.07.09
PATH: ./CODE_OF_CONDUCT.md PATH: ./CODE_OF_CONDUCT.md
BRIEF: Community expectations and enforcement guidelines BRIEF: Community expectations and enforcement guidelines
NOTE: Adapted with attribution from the Contributor Covenant v2.1 NOTE: Adapted with attribution from the Contributor Covenant v2.1
+1 -1
View File
@@ -19,7 +19,7 @@
DEFGROUP: mokoconsulting-tech.Template-Joomla DEFGROUP: mokoconsulting-tech.Template-Joomla
INGROUP: MokoStandards.Governance INGROUP: MokoStandards.Governance
REPO: https://github.com/mokoconsulting-tech/Template-Joomla REPO: https://github.com/mokoconsulting-tech/Template-Joomla
VERSION: 01.07.06 VERSION: 01.07.09
PATH: /GOVERNANCE.md PATH: /GOVERNANCE.md
BRIEF: Project governance rules, roles, and decision process for Template-Joomla BRIEF: Project governance rules, roles, and decision process for Template-Joomla
--> -->
+1 -1
View File
@@ -1,6 +1,6 @@
# MokoSuiteOpenGraph # MokoSuiteOpenGraph
<!-- VERSION: 01.07.06 --> <!-- VERSION: 01.07.09 -->
Open Graph, Twitter Card, and social sharing meta tag management for Joomla 6 and higher. Open Graph, Twitter Card, and social sharing meta tag management for Joomla 6 and higher.
+1 -1
View File
@@ -23,7 +23,7 @@ DEFGROUP: Template-Joomla
INGROUP: Template-Joomla.Documentation INGROUP: Template-Joomla.Documentation
REPO: https://git.mokoconsulting.tech/MokoConsulting/Template-Joomla REPO: https://git.mokoconsulting.tech/MokoConsulting/Template-Joomla
PATH: /SECURITY.md PATH: /SECURITY.md
VERSION: 01.07.06 VERSION: 01.07.09
BRIEF: Security vulnerability reporting and handling policy BRIEF: Security vulnerability reporting and handling policy
--> -->
@@ -3,4 +3,5 @@
; License: GPL-3.0-or-later ; License: GPL-3.0-or-later
COM_MOKOOG="MokoSuiteOpenGraph" COM_MOKOOG="MokoSuiteOpenGraph"
COM_MOKOOG_SHORT="OpenGraph"
COM_MOKOOG_DESCRIPTION="Manage Open Graph and social sharing tags for all your content. View, edit, and batch-process OG metadata." COM_MOKOOG_DESCRIPTION="Manage Open Graph and social sharing tags for all your content. View, edit, and batch-process OG metadata."
+2 -2
View File
@@ -8,7 +8,7 @@
--> -->
<extension type="component" method="upgrade"> <extension type="component" method="upgrade">
<name>com_mokoog</name> <name>com_mokoog</name>
<version>01.07.06</version> <version>01.07.09</version>
<creationDate>2026-05-23</creationDate> <creationDate>2026-05-23</creationDate>
<author>Moko Consulting</author> <author>Moko Consulting</author>
<authorEmail>hello@mokoconsulting.tech</authorEmail> <authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -71,7 +71,7 @@
<filename>access.xml</filename> <filename>access.xml</filename>
<filename>config.xml</filename> <filename>config.xml</filename>
</files> </files>
<menu img="class:bookmark">COM_MOKOOG</menu> <menu img="class:bookmark">COM_MOKOOG_SHORT</menu>
<submenu> <submenu>
<menu link="option=com_mokoog&amp;view=dashboard">COM_MOKOOG_SUBMENU_DASHBOARD</menu> <menu link="option=com_mokoog&amp;view=dashboard">COM_MOKOOG_SUBMENU_DASHBOARD</menu>
<menu link="option=com_mokoog&amp;view=tags">COM_MOKOOG_SUBMENU_TAGS</menu> <menu link="option=com_mokoog&amp;view=tags">COM_MOKOOG_SUBMENU_TAGS</menu>
+45 -45
View File
@@ -12,7 +12,6 @@ defined('_JEXEC') or die;
use Joomla\CMS\Factory; use Joomla\CMS\Factory;
use Joomla\CMS\Installer\InstallerAdapter; use Joomla\CMS\Installer\InstallerAdapter;
use Joomla\Database\DatabaseInterface;
class Com_MokoOGInstallerScript class Com_MokoOGInstallerScript
{ {
@@ -25,21 +24,26 @@ class Com_MokoOGInstallerScript
*/ */
public function install(InstallerAdapter $parent): void public function install(InstallerAdapter $parent): void
{ {
// Be honest about success: don't claim a clean install if the component's // Be smart: verify EVERY table the component's own install SQL declares is
// own tables never landed. Fails open (see missingTables) so a query/IO // actually present. If any are missing the install did not complete — say
// glitch never fakes a failure. // so instead of showing "installed successfully".
$missing = $this->missingTables(); $missing = $this->missingTables();
if (!empty($missing)) if ($missing !== []) {
{ $detail = count($missing) > 6
echo '<p>MokoSuiteOpenGraph component did not install correctly. ' ? count($missing) . ' expected database tables are missing'
. 'Missing database table(s): ' : 'missing tables: ' . htmlspecialchars(implode(', ', $missing), ENT_QUOTES, 'UTF-8');
. htmlspecialchars(implode(', ', $missing), ENT_QUOTES) . '.</p>';
Factory::getApplication()->enqueueMessage(
'<strong>MokoSuiteOpenGraph did not install correctly.</strong> ' . $detail
. ' — review the errors above, then reinstall.',
'error'
);
return; return;
} }
echo '<p>MokoSuiteOpenGraph component installed successfully.</p>'; Factory::getApplication()->enqueueMessage('<h4>MokoSuiteOpenGraph installed successfully!</h4>', 'info');
} }
/** /**
@@ -51,68 +55,64 @@ class Com_MokoOGInstallerScript
*/ */
public function update(InstallerAdapter $parent): void public function update(InstallerAdapter $parent): void
{ {
// Same smart check on update: only report success if the schema is intact.
$missing = $this->missingTables(); $missing = $this->missingTables();
if (!empty($missing)) if ($missing !== []) {
{ $detail = count($missing) > 6
echo '<p>MokoSuiteOpenGraph component did not update correctly. ' ? count($missing) . ' expected database tables are missing'
. 'Missing database table(s): ' : 'missing tables: ' . htmlspecialchars(implode(', ', $missing), ENT_QUOTES, 'UTF-8');
. htmlspecialchars(implode(', ', $missing), ENT_QUOTES) . '.</p>';
Factory::getApplication()->enqueueMessage(
'<strong>MokoSuiteOpenGraph did not update correctly.</strong> ' . $detail
. ' — review the errors above.',
'error'
);
return; return;
} }
echo '<p>MokoSuiteOpenGraph component updated successfully.</p>'; Factory::getApplication()->enqueueMessage('MokoSuiteOpenGraph updated successfully.', 'info');
} }
/** /**
* Verify the component's declared tables actually exist. Reads the shipped * Smart schema check: parse the component's own installed install SQL for every
* install SQL, extracts every CREATE TABLE #__name, resolves the live prefix, * CREATE TABLE, then return the ones missing from the database. An empty array
* and checks each against the database's table list (case-insensitive). * means the full schema installed. Fails open (returns []) if the SQL can't be
* read, so a good install is never flagged as failed.
* *
* FAILS OPEN: any error (unreadable SQL, query failure) returns [] so a * @return string[] Names (without the #__ prefix) of missing tables.
* transient glitch never turns a good install into a false failure.
*
* @return string[] Prefixed names of any missing tables.
*/ */
private function missingTables(): array private function missingTables(): array
{ {
try try {
{
$sqlFile = JPATH_ADMINISTRATOR . '/components/com_mokoog/sql/install.mysql.sql'; $sqlFile = JPATH_ADMINISTRATOR . '/components/com_mokoog/sql/install.mysql.sql';
if (!is_file($sqlFile)) if (!is_file($sqlFile)) {
{
return []; return [];
} }
$sql = (string) file_get_contents($sqlFile); $sql = file_get_contents($sqlFile);
if ($sql === '' || !preg_match_all('/CREATE\s+TABLE\s+(?:IF\s+NOT\s+EXISTS\s+)?[`"\']?(#__[A-Za-z0-9_]+)/i', $sql, $m)) if ($sql === false
{ || !preg_match_all('/CREATE\s+TABLE\s+(?:IF\s+NOT\s+EXISTS\s+)?[`"\']?(#__[A-Za-z0-9_]+)/i', $sql, $m)) {
return []; return [];
} }
$db = Factory::getContainer()->get(DatabaseInterface::class); $db = Factory::getDbo();
$prefix = $db->getPrefix(); $prefix = strtolower($db->getPrefix());
$existing = array_map('strtolower', (array) $db->getTableList()); $have = array_map('strtolower', $db->getTableList());
$missing = []; $missing = [];
foreach (array_unique($m[1]) as $table) foreach (array_unique($m[1]) as $decl) {
{ $bare = substr($decl, 3); // strip "#__"
$real = str_replace('#__', $prefix, $table); if (!in_array($prefix . strtolower($bare), $have, true)) {
$missing[] = $bare;
if (!in_array(strtolower($real), $existing, true))
{
$missing[] = $real;
} }
} }
return $missing; return $missing;
} } catch (\Throwable $e) {
catch (\Throwable $e)
{
// Fail open — never fake a failure on a glitch.
return []; return [];
} }
} }
@@ -0,0 +1 @@
/* 01.07.05 — no schema changes */
@@ -1 +0,0 @@
/* 01.07.06 — no schema changes */
@@ -0,0 +1 @@
/* 01.07.07 — no schema changes */
@@ -0,0 +1 @@
/* 01.07.08 — no schema changes */
@@ -0,0 +1 @@
/* 01.07.09 — no schema changes */
@@ -8,7 +8,7 @@
--> -->
<extension type="plugin" group="content" method="upgrade"> <extension type="plugin" group="content" method="upgrade">
<name>Content - MokoSuiteOpenGraph</name> <name>Content - MokoSuiteOpenGraph</name>
<version>01.07.06</version> <version>01.07.09</version>
<creationDate>2026-05-23</creationDate> <creationDate>2026-05-23</creationDate>
<author>Moko Consulting</author> <author>Moko Consulting</author>
<authorEmail>hello@mokoconsulting.tech</authorEmail> <authorEmail>hello@mokoconsulting.tech</authorEmail>
+1 -1
View File
@@ -8,7 +8,7 @@
--> -->
<extension type="plugin" group="system" method="upgrade"> <extension type="plugin" group="system" method="upgrade">
<name>System - MokoSuiteOpenGraph</name> <name>System - MokoSuiteOpenGraph</name>
<version>01.07.06</version> <version>01.07.09</version>
<creationDate>2026-05-23</creationDate> <creationDate>2026-05-23</creationDate>
<author>Moko Consulting</author> <author>Moko Consulting</author>
<authorEmail>hello@mokoconsulting.tech</authorEmail> <authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -8,7 +8,7 @@
--> -->
<extension type="plugin" group="webservices" method="upgrade"> <extension type="plugin" group="webservices" method="upgrade">
<name>Web Services - MokoSuiteOpenGraph</name> <name>Web Services - MokoSuiteOpenGraph</name>
<version>01.07.06</version> <version>01.07.09</version>
<creationDate>2026-05-23</creationDate> <creationDate>2026-05-23</creationDate>
<author>Moko Consulting</author> <author>Moko Consulting</author>
<authorEmail>hello@mokoconsulting.tech</authorEmail> <authorEmail>hello@mokoconsulting.tech</authorEmail>
+1 -1
View File
@@ -8,7 +8,7 @@
<extension type="package" method="upgrade"> <extension type="package" method="upgrade">
<name>Package - MokoSuiteOpenGraph</name> <name>Package - MokoSuiteOpenGraph</name>
<packagename>mokoog</packagename> <packagename>mokoog</packagename>
<version>01.07.06</version> <version>01.07.09</version>
<creationDate>2026-05-23</creationDate> <creationDate>2026-05-23</creationDate>
<author>Moko Consulting</author> <author>Moko Consulting</author>
<authorEmail>hello@mokoconsulting.tech</authorEmail> <authorEmail>hello@mokoconsulting.tech</authorEmail>
+42 -45
View File
@@ -50,9 +50,10 @@ class Pkg_MokoOGInstallerScript
public function postflight(string $type, InstallerAdapter $parent): void public function postflight(string $type, InstallerAdapter $parent): void
{ {
// The download key must be restored regardless of the install outcome.
$this->restoreDownloadKey(); $this->restoreDownloadKey();
// Enable plugins after first install (unconditional module/plugin setup) // Housekeeping: ensure the bundled plugins are enabled after a fresh install.
if ($type === 'install') if ($type === 'install')
{ {
$db = Factory::getContainer()->get(\Joomla\Database\DatabaseInterface::class); $db = Factory::getContainer()->get(\Joomla\Database\DatabaseInterface::class);
@@ -70,19 +71,18 @@ class Pkg_MokoOGInstallerScript
} }
} }
// Be honest about success. Joomla's package installer only LOGS a failed child // Be smart: only run the success path (the licence notice, which implies a
// sub-install but still runs this postflight, so don't show the license / // completed install) when every child extension declared in the package
// next-steps message if a bundled extension is actually missing. Fails open // manifest actually registered. If any are missing, the package did NOT
// (see missingChildExtensions) so a query/IO glitch never fakes a failure. // install successfully — surface that instead of implying success.
$missing = $this->missingChildExtensions($parent); $missing = $this->missingChildExtensions($parent);
if (!empty($missing)) if ($missing !== [])
{ {
Factory::getApplication()->enqueueMessage( Factory::getApplication()->enqueueMessage(
'<h4>MokoSuiteOpenGraph did not install correctly.</h4>' '<strong>MokoSuiteOpenGraph did not install completely.</strong> '
. '<p>The following bundled extensions are missing: ' . 'The following extension(s) failed to install: ' . htmlspecialchars(implode(', ', $missing), ENT_QUOTES, 'UTF-8') . '. '
. htmlspecialchars(implode(', ', $missing), ENT_QUOTES) . '</p>' . 'Resolve the errors shown above, then uninstall and reinstall the package.',
. '<p>Please uninstall MokoSuiteOpenGraph and reinstall the full package.</p>',
'error' 'error'
); );
@@ -93,15 +93,22 @@ class Pkg_MokoOGInstallerScript
} }
/** /**
* Verify every child extension declared in the package manifest actually landed * Compare the child extensions the package manifest declares against what is
* in #__extensions. Returns readable labels of any that are missing. * actually registered in #__extensions after the install/update. Returns the
* label of each declared extension that is missing (i.e. failed to install);
* an empty array means every child installed and the package succeeded.
* *
* element = <file> "id", EXCEPT plugins strip a leading plg_<group>_; plugins also * Fails open: any error returns [] so a query problem can never turn a good
* match folder = <file> "group". FAILS OPEN — any error returns [] so a transient * install into a false "did not install completely" warning.
* glitch never turns a good install into a false failure. *
* @param InstallerAdapter $parent Installer adapter
*
* @return string[]
*/ */
private function missingChildExtensions($parent): array private function missingChildExtensions(InstallerAdapter $parent): array
{ {
$missing = [];
try try
{ {
$manifest = $parent->getParent()->getManifest(); $manifest = $parent->getParent()->getManifest();
@@ -111,59 +118,49 @@ class Pkg_MokoOGInstallerScript
return []; return [];
} }
$db = Factory::getContainer()->get(\Joomla\Database\DatabaseInterface::class); $db = Factory::getContainer()->get(\Joomla\Database\DatabaseInterface::class);
$missing = [];
foreach ($manifest->files->file as $file) foreach ($manifest->files->file as $file)
{ {
$attrs = $file->attributes(); $childType = (string) $file['type'];
$id = isset($attrs['id']) ? (string) $attrs['id'] : ''; $element = (string) $file['id'];
$exType = isset($attrs['type']) ? (string) $attrs['type'] : ''; $group = (string) $file['group'];
if ($id === '' || $exType === '') if ($element === '')
{ {
continue; continue;
} }
$group = isset($attrs['group']) ? (string) $attrs['group'] : '';
$element = $id;
// Plugin element in #__extensions is the id minus any leading plg_<group>_.
if ($exType === 'plugin' && $group !== '')
{
$prefix = 'plg_' . $group . '_';
if (strpos($element, $prefix) === 0)
{
$element = substr($element, \strlen($prefix));
}
}
$query = $db->getQuery(true) $query = $db->getQuery(true)
->select('COUNT(*)') ->select('COUNT(*)')
->from($db->quoteName('#__extensions')) ->from($db->quoteName('#__extensions'))
->where($db->quoteName('element') . ' = ' . $db->quote($element)) ->where($db->quoteName('element') . ' = ' . $db->quote($element));
->where($db->quoteName('type') . ' = ' . $db->quote($exType));
if ($exType === 'plugin' && $group !== '') if ($childType !== '')
{
$query->where($db->quoteName('type') . ' = ' . $db->quote($childType));
}
// Plugins are only unique by element + folder (the manifest "group").
if ($childType === 'plugin' && $group !== '')
{ {
$query->where($db->quoteName('folder') . ' = ' . $db->quote($group)); $query->where($db->quoteName('folder') . ' = ' . $db->quote($group));
} }
if ((int) $db->setQuery($query)->loadResult() === 0) $db->setQuery($query);
if ((int) $db->loadResult() === 0)
{ {
$label = trim((string) $file); $missing[] = $element . ($group !== '' ? ' (' . $group . ')' : '');
$missing[] = $label !== '' ? preg_replace('/\.zip$/i', '', $label) : $id;
} }
} }
return $missing;
} }
catch (\Throwable $e) catch (\Throwable $e)
{ {
// Fail open — never fake a failure on a glitch.
return []; return [];
} }
return $missing;
} }