https://iphwiki.net/index.php?title=Moodle_-_%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D0%B0_Debug_info:_InnoDB_refuses_to_write_tables_with_ROW_FORMAT%3DCOMPRESSED_or_KEY_BLOCK_SIZE&feed=atom&action=history
Moodle - ошибка Debug info: InnoDB refuses to write tables with ROW FORMAT=COMPRESSED or KEY BLOCK SIZE - История изменений
2024-03-29T05:31:46Z
История изменений этой страницы в вики
MediaWiki 1.35.0
https://iphwiki.net/index.php?title=Moodle_-_%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D0%B0_Debug_info:_InnoDB_refuses_to_write_tables_with_ROW_FORMAT%3DCOMPRESSED_or_KEY_BLOCK_SIZE&diff=10450&oldid=prev
Admin iph в 07:15, 7 сентября 2021
2021-09-07T07:15:29Z
<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="ru">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Предыдущая</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Версия 07:15, 7 сентября 2021</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Строка 1:</td>
<td colspan="2" class="diff-lineno">Строка 1:</td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Файл:B_1.gif |link=https://bit.ly/3tbFsd6| Доступная цена]]</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Moodle - ошибка Debug info: InnoDB refuses to write tables with ROW FORMAT=COMPRESSED or KEY BLOCK SIZE ===</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Moodle - ошибка Debug info: InnoDB refuses to write tables with ROW FORMAT=COMPRESSED or KEY BLOCK SIZE ===</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
</table>
Admin iph
https://iphwiki.net/index.php?title=Moodle_-_%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D0%B0_Debug_info:_InnoDB_refuses_to_write_tables_with_ROW_FORMAT%3DCOMPRESSED_or_KEY_BLOCK_SIZE&diff=10449&oldid=prev
Admin iph: Новая страница: «=== Moodle - ошибка Debug info: InnoDB refuses to write tables with ROW FORMAT=COMPRESSED or KEY BLOCK SIZE === Ошибка при установке Moo...»
2021-09-07T07:15:08Z
<p>Новая страница: «=== Moodle - ошибка Debug info: InnoDB refuses to write tables with ROW FORMAT=COMPRESSED or KEY BLOCK SIZE === Ошибка при установке Moo...»</p>
<p><b>Новая страница</b></p><div>=== Moodle - ошибка Debug info: InnoDB refuses to write tables with ROW FORMAT=COMPRESSED or KEY BLOCK SIZE ===<br />
<br />
<br />
Ошибка при установке Moodle на Debian 10 с mariaDB 10.6.4:<br />
Debug info: InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.<br />
<br />
Решение - это отключить innodb_read_only_compressed в конфиге my.cnf:<br />
# vi /etc/mysql/my.cnf<br />
innodb_read_only_compressed=OFF<br />
<br />
Для проверки - перезапускаем MariaDB сервер:<br />
# systemctl restart mysql</div>
Admin iph