| @@ -38,9 +38,10 @@ | ||
| 38 | 38 | `active` tinyint(4) NOT NULL DEFAULT 0, |
| 39 | 39 | PRIMARY KEY (`id`), |
| 40 | 40 | INDEX `index_#__acym_mailbox_action1`(`name` ASC) |
| 41 | 41 | ) |
| 42 | - ENGINE = InnoDB;' | |
| 42 | + ENGINE = InnoDB | |
| 43 | + /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci*/;' | |
| 43 | 44 | ); |
| 44 | 45 | } |
| 45 | 46 | |
| 46 | 47 | private function updateFor810(): void |
| @@ -272,9 +273,10 @@ | ||
| 272 | 273 | REFERENCES `#__acym_mail`(`id`) |
| 273 | 274 | ON DELETE NO ACTION |
| 274 | 275 | ON UPDATE NO ACTION |
| 275 | 276 | ) |
| 276 | - ENGINE = InnoDB;' | |
| 277 | + ENGINE = InnoDB | |
| 278 | + /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci*/;' | |
| 277 | 279 | ); |
| 278 | 280 | } |
| 279 | 281 | |
| 280 | 282 | private function updateFor862(): void |
| @@ -295,8 +297,9 @@ | ||
| 295 | 297 | AND mail.type = '.acym_escapeDB(MailClass::TYPE_STANDARD) |
| 296 | 298 | ); |
| 297 | 299 | |
| 298 | 300 | if (!empty($mailsToClean)) { |
| 301 | + acym_arrayToInteger($mailsToClean); | |
| 299 | 302 | $this->updateQuery('DELETE FROM #__acym_mail_archive WHERE mail_id IN ('.implode(',', $mailsToClean).')'); |
| 300 | 303 | $mailClass = new MailClass(); |
| 301 | 304 | $mailClass->delete($mailsToClean); |
| 302 | 305 | } |
| @@ -360,8 +363,9 @@ | ||
| 360 | 363 | if ($this->isPreviousVersionAtLeast('8.7.0')) { |
| 361 | 364 | return; |
| 362 | 365 | } |
| 363 | 366 | |
| 367 | + // Replace backslashes by slashes in the upload folder option | |
| 364 | 368 | $uploadFolder = $config->get('uploadfolder'); |
| 365 | 369 | if (!empty($uploadFolder) && strpos($uploadFolder, '\\') !== false) { |
| 366 | 370 | $uploadFolder = str_replace('\\', '/', $uploadFolder); |
| 367 | 371 | $config->saveConfig(['uploadfolder' => $uploadFolder]); |
