chore(version): pre-release bump to 01.43.23-dev [skip ci]

fix: align remotes table schema, add restore_script_name column, profile ordering
- install.mysql.sql: rename `config` → `params` and drop `keep_local` from remotes table to match update file 01.41.00 and RemoteTable.php code (fixes Joomla database maintenance "one problem") - install.mysql.sql: fix idx_enabled index to use composite (profile_id, enabled) - install.mysql.sql: add restore_script_name column to profiles table - 01.43.22.sql: ALTER TABLE to add restore_script_name for existing installs - DashboardModel: order profile dropdown by ID instead of ordering column - SteppedBackupEngine: add stack trace logging around MokoRestore standalone generation to debug str_replace FATAL on SFTP profiles
2026-06-25 17:57:41 +00:00 · 2026-06-25 12:57:18 -05:00 · 2026-06-25 12:17:45 -05:00 · 2026-06-25 16:27:48 +00:00 · 2026-06-25 16:26:38 +00:00 · 2026-06-25 11:25:56 -05:00
20 changed files with 47 additions and 28 deletions
@@ -5,7 +5,7 @@
 # FILE INFORMATION
 # DEFGROUP: Gitea.Workflow
 # INGROUP: mokocli.Automation
-# VERSION: 01.43.16
+# VERSION: 01.43.23
 # BRIEF: Auto-create feature branch when an issue is opened

 name: "Universal: Issue Branch"
@@ -42,6 +42,8 @@ COM_MOKOJOOMBACKUP_DASHBOARD_STORAGE_BREAKDOWN="Storage by Profile"
 COM_MOKOJOOMBACKUP_DASHBOARD_BACKUP_TREND="Backup Trend (30 days)"

 ; Backups view
+COM_MOKOJOOMBACKUP_BACKUPS_N_ITEMS_DELETED="%d backup records deleted."
+COM_MOKOJOOMBACKUP_BACKUPS_N_ITEMS_DELETED_1="%d backup record deleted."
 COM_MOKOJOOMBACKUP_BACKUPS_TITLE="Backup Records"
 COM_MOKOJOOMBACKUP_BACKUPS_TABLE_CAPTION="Table of backup records"
 COM_MOKOJOOMBACKUP_NO_BACKUPS="No backups found. Click 'Backup Now' to create your first backup."
@@ -7,8 +7,8 @@
 -->
 <extension type="component" method="upgrade">
 	<name>MokoSuiteBackup</name>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-02</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -40,6 +40,7 @@ CREATE TABLE IF NOT EXISTS `#__mokosuitebackup_profiles` (
 	`remote_keep_local`    TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'Keep local copy after upload',
 	`encryption_password`  VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'AES-256 archive encryption password (blank = no encryption)',
 	`include_mokorestore`    VARCHAR(20) NOT NULL DEFAULT '0' COMMENT 'MokoRestore mode: 0=none, 1=wrapped, standalone',
+	`restore_script_name`   VARCHAR(100) NOT NULL DEFAULT 'restore.php' COMMENT 'Custom restore script filename',
 	`sanitize_passwords`    TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'Replace user password hashes with invalid value',
 	`preserve_super_admin`  TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'Keep super admin password when sanitizing',
 	`sanitize_emails`       TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'Replace user emails with dummy values',
@@ -113,14 +114,13 @@ CREATE TABLE IF NOT EXISTS `#__mokosuitebackup_remotes` (
 	`title`            VARCHAR(255) NOT NULL DEFAULT '',
 	`type`             VARCHAR(20) NOT NULL DEFAULT 'sftp' COMMENT 'sftp, s3, google_drive',
 	`enabled`          TINYINT(1) NOT NULL DEFAULT 1,
-	`keep_local`       TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'Keep local copy after upload',
-	`config`           MEDIUMTEXT NOT NULL COMMENT 'JSON — type-specific settings',
+	`params`           MEDIUMTEXT COMMENT 'JSON: type-specific settings',
 	`ordering`         INT(11) NOT NULL DEFAULT 0,
 	`created`          DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
 	`modified`         DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
 	PRIMARY KEY (`id`),
 	KEY `idx_profile` (`profile_id`),
-	KEY `idx_enabled` (`enabled`)
+	KEY `idx_enabled` (`profile_id`, `enabled`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

 -- Insert default backup profile (IGNORE prevents duplicate key error on update)
@@ -0,0 +1 @@
+/* 01.43.19 — no schema changes */
@@ -0,0 +1 @@
+/* 01.43.20 — no schema changes */
@@ -0,0 +1,5 @@
+-- 01.43.22 — Add restore_script_name to profiles, align remotes schema
+
+ALTER TABLE `#__mokosuitebackup_profiles`
+  ADD COLUMN `restore_script_name` VARCHAR(100) NOT NULL DEFAULT 'restore.php' COMMENT 'Custom restore script filename'
+  AFTER `include_mokorestore`;
@@ -0,0 +1 @@
+/* 01.43.23 — no schema changes */
@@ -394,8 +394,14 @@ class SteppedBackupEngine
 			$restoreScriptName = MokoRestore::sanitizeScriptName($restoreScriptName);
 			$restoreDir = dirname($session->archivePath);
 			$session->restoreScriptPath = $restoreDir . '/' . $restoreScriptName;
-			MokoRestore::generateStandalone($session->restoreScriptPath);
-			$session->log('Standalone ' . $restoreScriptName . ' generated');
+
+			try {
+				MokoRestore::generateStandalone($session->restoreScriptPath);
+				$session->log('Standalone ' . $restoreScriptName . ' generated');
+			} catch (\Throwable $e) {
+				$session->log('MokoRestore error: ' . $e->getMessage() . ' in ' . $e->getFile() . ':' . $e->getLine());
+				$session->log('Stack trace: ' . $e->getTraceAsString());
+			}
 		}

 		// Update record
@@ -29,7 +29,10 @@ class SshKeyField extends FormField
 		$id    = $this->id;
 		$name  = $this->name;

-		$hasKey = !empty($value) && str_contains($value, 'PRIVATE KEY');
+		$decoded = !empty($value) ? (base64_decode($value, true) ?: '') : '';
+		$hasKey = !empty($value) && ($value === '__KEEP_EXISTING__'
+			|| str_contains($value, 'PRIVATE KEY')
+			|| str_contains($decoded, 'PRIVATE KEY'));

 		$html = '<div id="' . htmlspecialchars($id) . '-wrapper">';

@@ -294,7 +294,7 @@ class DashboardModel extends BaseDatabaseModel
 			->select($db->quoteName(['id', 'title', 'backup_type']))
 			->from($db->quoteName('#__mokosuitebackup_profiles'))
 			->where($db->quoteName('published') . ' = 1')
-			->order($db->quoteName('ordering') . ' ASC');
+			->order($db->quoteName('id') . ' ASC');
 		$db->setQuery($query);

 		return $db->loadObjectList() ?: [];
@@ -8,8 +8,8 @@
 -->
 <extension type="module" client="administrator" method="upgrade">
 	<name>mod_mokosuitebackup_cpanel</name>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-23</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -7,8 +7,8 @@
 -->
 <extension type="plugin" group="actionlog" method="upgrade">
 	<name>Action Log - MokoSuiteBackup</name>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-04</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -7,8 +7,8 @@
 -->
 <extension type="plugin" group="console" method="upgrade">
 	<name>Console - MokoSuiteBackup</name>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-04</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -7,8 +7,8 @@
 -->
 <extension type="plugin" group="content" method="upgrade">
 	<name>Content - MokoSuiteBackup</name>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-04</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -1,8 +1,8 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="quickicon" method="upgrade">
 	<name>Quick Icon - MokoSuiteBackup</name>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-02</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -7,8 +7,8 @@
 -->
 <extension type="plugin" group="system" method="upgrade">
 	<name>System - MokoSuiteBackup</name>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-02</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -7,8 +7,8 @@
 -->
 <extension type="plugin" group="task" method="upgrade">
 	<name>Task - MokoSuiteBackup</name>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-02</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -7,8 +7,8 @@
 -->
 <extension type="plugin" group="webservices" method="upgrade">
 	<name>Web Services - MokoSuiteBackup</name>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-02</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
@@ -8,8 +8,8 @@
 <extension type="package" method="upgrade">
 	<name>Package - MokoSuiteBackup</name>
 	<packagename>mokosuitebackup</packagename>
-	<version>01.43.16</version>
-	<version>01.43.16</version>
+	<version>01.43.23</version>
+	<version>01.43.23</version>
 	<creationDate>2026-06-02</creationDate>
 	<author>Moko Consulting</author>
 	<authorEmail>hello@mokoconsulting.tech</authorEmail>
Author	SHA1	Message	Date
gitea-actions[bot]	b4cc529cbd	chore(version): pre-release bump to 01.43.23-dev [skip ci]	2026-06-25 17:57:41 +00:00
jmiller	a177dfdcf9	fix: align remotes table schema, add restore_script_name column, profile ordering Universal: Pre-Release / Build Pre-Release (${{ inputs.stability \|\| github.ref_name }}) (push) Successful in 10s Details - install.mysql.sql: rename `config` → `params` and drop `keep_local` from remotes table to match update file 01.41.00 and RemoteTable.php code (fixes Joomla database maintenance "one problem") - install.mysql.sql: fix idx_enabled index to use composite (profile_id, enabled) - install.mysql.sql: add restore_script_name column to profiles table - 01.43.22.sql: ALTER TABLE to add restore_script_name for existing installs - DashboardModel: order profile dropdown by ID instead of ordering column - SteppedBackupEngine: add stack trace logging around MokoRestore standalone generation to debug str_replace FATAL on SFTP profiles	2026-06-25 12:57:18 -05:00
jmiller	93f0fa0a47	fix: SSH key indicator detection and missing delete language key Universal: Pre-Release / Build Pre-Release (${{ inputs.stability \|\| github.ref_name }}) (push) Successful in 9s Details - SshKeyField: detect base64-encoded keys from DB so the "Key loaded" badge displays correctly after initial upload - Add COM_MOKOJOOMBACKUP_BACKUPS_N_ITEMS_DELETED language keys for Joomla's AdminController delete feedback message	2026-06-25 12:17:45 -05:00
gitea-actions[bot]	268b3d54d7	chore(version): pre-release bump to 01.43.20-dev [skip ci]	2026-06-25 16:27:48 +00:00
jmiller	1cfe7c6c6e	Merge pull request 'fix: add SQL update file to match manifest version' (#153 ) from fix/schema-version-file-2 into dev Universal: Auto Version Bump / Version Bump (push) Has been skipped Details Universal: Pre-Release / Build Pre-Release (${{ inputs.stability \|\| github.ref_name }}) (push) Successful in 19s Details fix: add SQL update file to match manifest version	2026-06-25 16:26:38 +00:00
jmiller	f0da0c02b4	fix: add SQL update file to match manifest version Universal: PR Check / Branch Policy (pull_request) Successful in 1s Details Universal: PR Check / Secret Scan (pull_request) Successful in 6s Details Universal: PR Check / Validate PR (pull_request) Failing after 4s Details RC Revert / Rename rc/ back to dev/ (pull_request) Has been skipped Details Branch Cleanup / Delete merged branch (pull_request) Successful in 2s Details Universal: Pre-Release / Build Pre-Release (${{ inputs.stability \|\| github.ref_name }}) (push) Failing after 7s Details Joomla: Metadata Validation / Validate Joomla Metadata (pull_request) Successful in 46s Details Universal: PR Check / Build RC Package (pull_request) Has been cancelled Details Universal: PR Check / Report Issues (pull_request) Has been cancelled Details Joomla's Database view requires a SQL update file matching the manifest version. Missing file causes persistent schema version mismatch warning.	2026-06-25 11:25:56 -05:00
gitea-actions[bot]	2f8a65388c	chore(version): pre-release bump to 01.43.19-dev [skip ci]	2026-06-25 16:13:23 +00:00
gitea-actions[bot]	9978622960	chore(version): pre-release bump to 01.43.18-dev [skip ci]	2026-06-25 16:13:03 +00:00
jmiller	35e5fc1503	Merge pull request 'fix(db): add 01.43.11 schema update file' (#152 ) from fix/schema-version-file into dev Universal: Auto Version Bump / Version Bump (push) Has been skipped Details Universal: Pre-Release / Build Pre-Release (${{ inputs.stability \|\| github.ref_name }}) (push) Successful in 23s Details	2026-06-25 16:12:46 +00:00
gitea-actions[bot]	2338ba5197	chore(version): pre-release bump to 01.43.17-dev [skip ci] RC Revert / Rename rc/ back to dev/ (pull_request) Has been skipped Details Branch Cleanup / Delete merged branch (pull_request) Successful in 2s Details	2026-06-25 16:12:33 +00:00
jmiller	e67eedbc93	fix(db): add 01.43.11 schema update file to resolve version mismatch Universal: Pre-Release / Build Pre-Release (${{ inputs.stability \|\| github.ref_name }}) (push) Successful in 10s Details Joomla's database checker requires a SQL update file matching the manifest version. Missing file caused schema version to stay at 01.41.00.	2026-06-25 11:12:22 -05:00
gitea-actions[bot]	d812aca832	chore(version): pre-release bump to 01.43.15-dev [skip ci]	2026-06-25 16:00:54 +00:00
gitea-actions[bot]	4315f36c6a	chore(version): pre-release bump to 01.43.14-dev [skip ci]	2026-06-25 15:59:41 +00:00
jmiller	10467835ac	Merge pull request 'fix: UI cleanup, custom restore script name, version bump 01.43.11-dev' (#150 ) from fix/ui-cleanup-restore-name into dev Universal: Auto Version Bump / Version Bump (push) Has been skipped Details Universal: Pre-Release / Build Pre-Release (${{ inputs.stability \|\| github.ref_name }}) (push) Successful in 10s Details	2026-06-25 15:59:30 +00:00
gitea-actions[bot]	f26d58504e	chore(version): pre-release bump to 01.43.13-dev [skip ci] Branch Cleanup / Delete merged branch (pull_request) Successful in 1s Details RC Revert / Rename rc/ back to dev/ (pull_request) Has been skipped Details	2026-06-25 15:58:38 +00:00