.
```
テーブル`migration_versions`に既に登録されていたため削除して再実行（これはv10.6へのアップデート時に既に登録されていたためエラーはスルーして可）。
* * *
### MariaDBエラー
```auto
mariadb | 2023-06-22 22:19:03 4 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).
mariadb | 2023-06-22 22:19:03 4 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
```
Docker Composeファイルの環境変数に- MARIADB\_AUTO\_UPGRADE=1を追加。
> **[How to fix docker MariaDB correct definition of table mysql.column\_stats:...](https://techoverflow.net/2022/06/07/how-to-fix-docker-mariadb-correct-definition-of-table-mysql-column_stats-expected-column-hist_type-at-position-9/)**
>
> Based in Munich, our engineers & laboratory helps you to develop your product from the first idea to certification & production.
```auto
$ docker-compose exec mariadb mysql_upgrade ---user=USER --password=PASSWORD
```
* * *
### `bin/console pimcore:bundle:install PimcoreAdminBundle エラー`
```auto
root@1c2aea9fb5e6:/var/www/html/pimcore10# bin/console pimcore:bundle:list
+----------------------------------+---------+-----------+-------------+---------------+----------+
| Bundle | Enabled | Installed | Installable | Uninstallable | Priority |
+----------------------------------+---------+-----------+-------------+---------------+----------+
| PimcoreAdminBundle | ✔ | ❌ | ✔ | ❌ | 0 |
| PimcoreApplicationLoggerBundle | ✔ | ✔ | ❌ | ✔ | 0 |
| PimcoreCustomReportsBundle | ✔ | ✔ | ❌ | ✔ | 0 |
| PimcoreGlossaryBundle | ✔ | ✔ | ❌ | ✔ | 0 |
| PimcoreSeoBundle | ✔ | ✔ | ❌ | ✔ | 0 |
| PimcoreSimpleBackendSearchBundle | ✔ | ❌ | ✔ | ❌ | 0 |
| PimcoreStaticRoutesBundle | ✔ | ✔ | ❌ | ✔ | 0 |
| PimcoreTinymceBundle | ✔ | ✔ | ❌ | ✔ | 0 |
| PimcoreUuidBundle | ❌ | ❌ | ❌ | ❌ | 0 |
| PimcoreWordExportBundle | ✔ | ✔ | ❌ | ✔ | 0 |
| PimcoreXliffBundle | ✔ | ✔ | ❌ | ✔ | 0 |
+----------------------------------+---------+-----------+-------------+---------------+----------+
Legend: I?: Can be installed? UI?: Can be uninstalled? UP?: Can be updated?
root@1c2aea9fb5e6:/var/www/html/pimcore10# bin/console pimcore:bundle:install PimcoreAdminBundle
[ERROR] An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry 'admin_translations' for key 'PRIMARY'
root@1c2aea9fb5e6:/var/www/html/pimcore10# bin/console pimcore:bundle:install PimcoreAdminBundle
[ERROR] An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry 'gdpr_data_extractor' for key 'PRIMARY'
root@1c2aea9fb5e6:/var/www/html/pimcore10# bin/console pimcore:bundle:install PimcoreAdminBundle
[ERROR] An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry 'admin_translations' for key 'PRIMARY'
root@1c2aea9fb5e6:/var/www/html/pimcore10# bin/console pimcore:bundle:install PimcoreAdminBundle
[ERROR] An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry 'system_appearance_settings' for key 'PRIMARY'
```
テーブル`users_permission_definitions`の項目削除
- ‘admin\_translations’
- ‘gdpr\_data\_extractor’
- ‘system\_appearance\_settings’
* * *
### System Settings, Appearance Brandingの設定
[https://pimcore.com/docs/platform/Pimcore/Tools\_and\_Features/System\_Settings/](https://pimcore.com/docs/platform/Pimcore/Tools_and_Features/System_Settings/)
‼ 移行後に以下の設定の読込みと保存が出来ない不具合
**System Settings**
**Appearance Branding**
以下の作業が必要：`config/config.yaml`
- `read_target`セクションをコメントアウト
- キャッシュをクリア`bin/console cache:clear`し読込みを無効化
- System Settings, Appearance Brandingにアクセスし設定を保存
- `read_target`セクションをアンコメント
- 再びキャッシュをクリア`bin/console cache:clear`し読込みと保存を有効化
`config/config.yaml`
```auto
pimcore:
system_settings:
write_target:
type: 'settings-store'
read_target:
type: 'settings-store'
#### Pimcore ADMIN
pimcore_admin:
admin_csp_header:
enabled: false
exclude_paths:
- '@^/admin/external_opcache@'
config_location:
admin_system_settings:
write_target:
type: 'settings-store'
read_target:
type: 'settings-store'
```
* * *
### 言語スイッチエラー
選択した言語表示に切り換わらない。
PHPコードのバグ。if条件の再定義。
新）言語切替のリンクがリストアップしたページ毎に反映されない。
```auto
if ($routeParams['newstitle'] || $routeParams['blogtitle']) {
$routeParams['_locale'] = \Locale::getPrimaryLanguage($language);
$route = $this->urlGenerator->generate($route, $routeParams);
$target = $route;
}
```
[https://github.com/pimcore/demo/issues/517](https://github.com/pimcore/demo/issues/517)
### エディターCKEditorからTinyMCEへ移行：表示エラー
**`Symfony HTML Sanitizer`** による表示制限が原因。`Sanitizer`によりデフォルトの表示エレメントが以下のように制限されているため、コード、画像、表示文字などの指定外のエレメントが非表示となってしまう。
[https://pimcore.com/docs/platform/Pimcore/Documents/Editables/WYSIWYG/#extending-symfony-html-sanitizer-configuration](https://pimcore.com/docs/platform/Pimcore/Documents/Editables/WYSIWYG/#extending-symfony-html-sanitizer-configuration)
> **[HTML Sanitizer (Symfony Docs)](https://symfony.com/doc/current/html_sanitizer.html)**
>
> The HTML Sanitizer component aims at sanitizing/cleaning untrusted HTML code (e.g. created by a WYSIWYG editor in the browser) into HTML that can be trusted. It is based on the HTML Sanitizer W3C Stan…
`vendor/pimcore/pimcore/bundles/CoreBundle/config/pimcore/default.yaml`
```auto
framework:
html_sanitizer:
sanitizers:
pimcore.wysiwyg_sanitizer:
allow_elements:
span : ['class', 'style', 'id']
div : ['class', 'style', 'id']
p: ['class', 'style', 'id']
strong: 'class'
em: 'class'
h1: ['class', 'id']
a: ['class', 'id', 'href', 'target', 'title', 'rel']
table: ['class', 'style', 'cellspacing', 'cellpadding', 'border', 'width', 'height', 'id']
colgroup: 'class'
col: ['class', 'style', 'id']
tbody: ['class', 'id']
tr: ['class', 'id']
td: ['class', 'id']
ul: ['class', 'style', 'id']
li: ['class', 'style', 'id']
ol: ['class', 'style', 'id']
pimcore.translation_sanitizer:
allow_elements:
span: ['class', 'style', 'id']
p: ['class', 'style', 'id']
strong: 'class'
em: 'class'
h1: ['class', 'id']
h2: ['class', 'id']
h3: ['class', 'id']
h4: ['class', 'id']
h5: ['class', 'id']
h6: ['class', 'id']
a: ['class', 'id', 'href', 'target', 'title', 'rel']
```
以下のファイルを作成し設定を上書き
（暫定策、 [HTML Sanitizer API](https://wicg.github.io/sanitizer-api/) を参照し細かく指定したほうが良い）。
`config/packages/html_sanitizer.yaml`
```auto
framework:
html_sanitizer:
sanitizers:
app.post_sanitizer:
# enable either of these
# allow_safe_elements: true
allow_static_elements: true
```
* * *
### 管理画面500エラー
”exception error" ダイアログが表示され設定の保存などが出来ない。
以下データベースへのデータ移行で解決。
```auto
# bin/console doctrine:migrations:migrate
```
### サイトマップライブラリ変更
`config/routes/presta_sitemap.yaml`
```auto
presta_sitemap:
resource: "@PrestaSitemapBundle/config/routing.yml"
```
**`SeoBundle, SitemapBundle`** を追加
`config/bundles.php`
```auto
['all' => true],
.....
.....
PrestaSitemapBundle::class => ['all' => true],
.....
.....
];
```
---
### Author:  [@tk-fuse](https://forum.ficusonline.com/u/tk-fuse)
#### Post date: [2023 年 7 月 7 日午前 7:37 UTC](https://forum.ficusonline.com/t/topic/331/5 "2023-07-07T07:37:45Z")
## 英文ページ表示エラー
ページの保存・削除も不可。
**エラーログ**
`var/log/prod.log`
```auto
[2023-07-07T07:28:08.928544+00:00] php.CRITICAL: Uncaught Error: Pimcore\Twig\Extension\Templating\Inc::__invoke(): Argument #1 ($include) must be of type Pimcore\Model\Document\PageSnippet|string|int, null given, called in /var/www/html/pimcore10/var/cache/prod/twig/02/02420062707554a538d97f75b202bbd5.php on line 442 {"exception":"[object] (TypeError(code: 0): Pimcore\\Twig\\Extension\\Templating\\Inc::__invoke(): Argument #1 ($include) must be of type Pimcore\\Model\\Document\\PageSnippet|string|int, null given, called in /var/www/html/pimcore10/var/cache/prod/twig/02/02420062707554a538d97f75b202bbd5.php on line 442 at /var/www/html/pimcore10/vendor/pimcore/pimcore/lib/Twig/Extension/Templating/Inc.php:47)"} []
[2023-07-07T07:28:08.930727+00:00] php.CRITICAL: Uncaught Exception: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pimcore10.http_error_log' doesn't exist {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 1146): An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pimcore10.http_error_log' doesn't exist at /var/www/html/pimcore10/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1146): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pimcore10.http_error_log' doesn't exist at /var/www/html/pimcore10/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pimcore10.http_error_log' doesn't exist at /var/www/html/pimcore10/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:121)"} []
```
原因：サイドバー（スニペット）の設定がされていなかったことによるエラー
対応：以下サイドバースニペットを表示エラーページに追加してページを保存。
* * *
**管理画面ダイアログ**
> Timestamp: Fri Jul 07 2023 20:46:40 GMT+0900 (日本標準時)
> Status: 500 | Internal Server Error
> URL: /admin/page/get-data-by-id
> Message: Cannot assign null to property Pimcore\Model\Document\Editable::$realName of type string
**エラーログ**
`var/log/prod.log`
```auto
[2023-07-07T11:42:36.201380+00:00] php.CRITICAL: Uncaught Error: Cannot assign null to property Pimcore\Model\Document\Editable::$realName of type string {"exception":"[object] (TypeError(code: 0): Cannot assign null to property Pimcore\\Model\\Document\\Editable::$realName of type string at /var/www/html/pimcore10/vendor/pimcore/pimcore/lib/Tool/Serialize.php:31)"} []
[2023-07-07T11:42:36.204626+00:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Cannot assign null to property Pimcore\Model\Document\Editable::$realName of type string" at /var/www/html/pimcore10/vendor/pimcore/pimcore/lib/Tool/Serialize.php line 31 {"exception":"[object] (TypeError(code: 0): Cannot assign null to property Pimcore\\Model\\Document\\Editable::$realName of type string at /var/www/html/pimcore10/vendor/pimcore/pimcore/lib/Tool/Serialize.php:31)"} []
```
対応：ドキュメントアイコンを一度ドラッグアンドドロップして別の場所へ移動することでファイル階層を再構築
```auto
[2023-07-08T08:35:31.588820+00:00] php.CRITICAL: Uncaught Exception: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pimcore10.http_error_log' doesn't exist {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 1146): An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pimcore10.http_error_log' doesn't exist at /var/www/html/pimcore10/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1146): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pimcore10.http_error_log' doesn't exist at /var/www/html/pimcore10/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pimcore10.http_error_log' doesn't exist at /var/www/html/pimcore10/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:121)"} []
```
対応：下記テーブル作成
`vendor/pimcore/pimcore/bundles/SeoBundle/src/Resources/install/install.sql`
```sql
CREATE TABLE IF NOT EXISTS `http_error_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uri` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`code` int(3) DEFAULT NULL,
`parametersGet` longtext,
`parametersPost` longtext,
`cookies` longtext,
`serverVars` longtext,
`date` int(11) unsigned DEFAULT NULL,
`count` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `uri` (`uri`),
KEY `code` (`code`),
KEY `date` (`date`),
KEY `count` (`count`)
) DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
```
* * *
### メンテナンススクリプト実行時エラー
[https://pimcore.com/docs/platform/Pimcore/Getting\_Started/Installation/Webserver\_Installation#5-maintenance-cron-job](https://pimcore.com/docs/platform/Pimcore/Getting_Started/Installation/Webserver_Installation#5-maintenance-cron-job)
```auto
# bin/console messenger:consume pimcore_core pimcore_maintenance pimcore_image_optimize pimcore_search_backend_message --time-limit=300
```
**エラーログ**
`var/log/prod.log`
```auto
[2023-07-12T08:00:17.514235+00:00] console.CRITICAL: Error thrown while running command "messenger:consume pimcore_core pimcore_maintenance pimcore_image_optimize pimcore_search_backend_message --time-limit=300". Message: "Message class "Pimcore\Messenger\SearchBackendMessage" not found during decoding." {"exception":"[object] (Symfony\\Component\\Messenger\\Exception\\MessageDecodingFailedException(code: 0): Message class \"Pimcore\\Messenger\\SearchBackendMessage\" not found during decoding. at /var/www/html/pimcore10/vendor/symfony/messenger/Transport/Serialization/PhpSerializer.php:117)","command":"messenger:consume pimcore_core pimcore_maintenance pimcore_image_optimize pimcore_search_backend_message --time-limit=300","message":"Message class \"Pimcore\\Messenger\\SearchBackendMessage\" not found during decoding."} []
```
---
### Author:  [@tk-fuse](https://forum.ficusonline.com/u/tk-fuse)
#### Post date: [2023 年 7 月 16 日午前 8:45 UTC](https://forum.ficusonline.com/t/topic/331/6 "2023-07-16T08:45:00Z")
## 特殊文字の表示エラー
### wysiwyg : < = ‘\<’ サニタイズにより非表示
Symfonyのサニタイズエラー：fixed
[https://github.com/pimcore/pimcore/pull/15811/files](https://github.com/pimcore/pimcore/pull/15811/files)
以下ファイル内で
> `models/DataObject/ClassDefinition/Data/Wysiwyg.php`
> `models/Document/Editable/Wysiwyg.php`
データのデコード処理を削除
修正前
```auto
sanitize(html_entity_decode($data));
```
修正後
```auto
sanitize($data);
```
[https://github.com/pimcore/pimcore/issues/15740](https://github.com/pimcore/pimcore/issues/15740)
> **[protect - Content filtering options | TinyMCE Documentation](https://www.tiny.cloud/docs/tinymce/6/content-filtering/#protect)**
>
> This option allows you to specify whether the editor should parse and keep conditional comments. | These settings change the way the editor handles the input and output of content. This will help you to create clean, maintainable and readable...
* * *
### リスト一覧ページ：' = ‘'’ 不変換
twigによるrawデータからの出力へ変更
`templates/blog/listing.html.twig`
```auto
{{ item.text[:300] | striptags | raw }} .....
```
* * *
### ドキュメント保存時のエラー
[https://github.com/pimcore/pimcore/issues/15652](https://github.com/pimcore/pimcore/issues/15652)
`lib/Tool/Text.php`
```auto
if (count($matches[2]) > 0) {
for ($i = 0; $i < count($matches[2]); $i++) {
preg_match('/[0-9]+/', $matches[2][$i], $idMatches);
preg_match('/asset|object|document/', $matches[3][$i], $typeMatches);
if (isset($idMatches[0], $typeMatches[0])) {
$elements[] = [
'id' => (int) $idMatches[0],
'type' => $typeMatches[0],
];
}
}
}
```
* * *
**アセット画像リンクエラー**
アセットからTynyMCEによるテキストエリアへドラッグ＆ドロップした画像のリンクエラー
[https://github.com/pimcore/pimcore/issues/15874](https://github.com/pimcore/pimcore/issues/15874)
#### 関連ファイル
**`public/bundles/pimcoretinymce/js/editor.js`**
```auto
if (data.elementType === "asset") {
if (data.type === "image" && textIsSelected === false) {
// images bigger than 600px or formats which cannot be displayed by the browser directly will be
// converted by the pimcore thumbnailing service so that they can be displayed in the editor
let defaultWidth = 600;
let additionalAttributes = {};
if (typeof data.imageWidth != "undefined") {
const route = 'pimcore_admin_asset_getimagethumbnail';
const params = {
id: id,
width: defaultWidth,
aspectratio: true
};
uri = Routing.generate(route, params);
if (data.imageWidth < defaultWidth
&& in_arrayi(pimcore.helpers.getFileExtension(data.text),
browserPossibleExtensions)) {
uri = data.path;
additionalAttributes = mergeObject(additionalAttributes, {pimcore_disable_thumbnail: true});
}
if (data.imageWidth < defaultWidth) {
defaultWidth = data.imageWidth;
}
additionalAttributes = mergeObject(additionalAttributes, {style: `width:${defaultWidth}px;`});
}
additionalAttributes = mergeObject(additionalAttributes, {
src: uri,
pimcore_type: 'asset',
pimcore_id: id,
target: '_blank',
alt: 'asset_image'
});
tinymce.activeEditor.selection.setContent(tinymce.activeEditor.dom.createHTML('img', additionalAttributes));
return true;
} else {
tinymce.activeEditor.selection.setContent(tinymce.activeEditor.dom.createHTML('a', {
href: uri,
pimcore_type: 'asset',
pimcore_id: id,
target: '_blank'
}, wrappedText));
return true;
}
}
```
**`vendor/pimcore/admin-ui-classic-bundle/src/Controller/Admin/Asset/AssetController.php`**
```auto
.....
.....
/**
* @Route("/get-image-thumbnail", name="pimcore_admin_asset_getimagethumbnail", methods={"GET"})
*
* @param Request $request
*
* @return StreamedResponse|JsonResponse|BinaryFileResponse
*/
public function getImageThumbnailAction(Request $request): BinaryFileResponse|JsonResponse|StreamedResponse
{
$fileinfo = $request->get('fileinfo');
$image = Asset\Image::getById((int)$request->get('id'));
.....
.....
```
**原因：**
以下PHPファイル内での項目別正規表現での条件順序が、スクリプトの項目順序と異なっていたため。
[pimcore/lib/Tool/Text.php](https://github.com/pimcore/pimcore/blob/8378d7506654cb5c8bbade9c98ef18e40e3e25a7/lib/Tool/Text.php#L194)
Line 194 in [8378d75](https://github.com/pimcore/pimcore/commit/8378d7506654cb5c8bbade9c98ef18e40e3e25a7)
> preg\_match\_all(“@\<(a img)[^\>]_(pimcore\_id="[0-9]+")[^\>]_(pimcore\_type="[asset document object]+")[^\>]\*\>@msUi”, $text, $matches);
[https://github.com/pimcore/pimcore/pull/15940](https://github.com/pimcore/pimcore/pull/15940)
`bundles/TinymceBundle/public/js/editor.js`
```auto
additionalAttributes = mergeObject(additionalAttributes, {
src: uri,
target: '_blank',
alt: 'asset_image',
pimcore_id: id,
pimcore_type: 'asset'
});
.....
.....
tinymce.activeEditor.selection.setContent(tinymce.activeEditor.dom.createHTML('a', {
href: uri,
target: '_blank',
pimcore_id: id,
pimcore_type: 'asset'
}, wrappedText));
.....
.....
tinymce.activeEditor.selection.setContent(tinymce.activeEditor.dom.createHTML('a', {
href: uri,
pimcore_id: id,
pimcore_type: 'document'
}, wrappedText));
.....
.....
if (data.elementType === "object") {
tinymce.activeEditor.selection.setContent(tinymce.activeEditor.dom.createHTML('a', {
href: uri,
pimcore_id: id,
pimcore_type: 'object'
}, wrappedText));
.....
.....
```
上記対策は11.0.9にマージ
---
### Author:  [@tk-fuse](https://forum.ficusonline.com/u/tk-fuse)
#### Post date: [2023 年 10 月 29 日午前 2:18 UTC](https://forum.ficusonline.com/t/topic/331/7 "2023-10-29T02:18:32Z")
11.1.0へのアップデート(`＃ composer update` )の際のエラー
```auto
An error occurred when executing the "/usr/local/bin/php bin/console --ansi cache:clear --no-warmup --ignore-maintenance-mode" command:
```
`pimcore/var/cache/*`の削除
[https://github.com/pimcore/pimcore/issues/16161](https://github.com/pimcore/pimcore/issues/16161)