New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Отсутствует текстовый формат: 4 #698

Closed
mbaev opened this Issue Oct 2, 2017 · 4 comments

Comments

Projects
None yet
1 participant
@mbaev
Contributor

mbaev commented Oct 2, 2017

Существует ошибка, которая была привнесена с переходом на Drupal 7 и невидима для пользователей, но влияет на работу сайта.
image

Из-за этой ошибки на сайте отсутствуют некоторые старые материалы. Пример, http://drupal.ru/node/616

Соответственно с точки зрения SEO пропала часть постов.

Необходимо для всех текстовых форматов "4" в базе проставить новый текстовый формат "BBCode + HTML" (id: 1)

@mbaev mbaev self-assigned this Oct 2, 2017

@mbaev mbaev added Bug SEO labels Oct 2, 2017

@mbaev mbaev added this to the 6-ое ноября 2017 milestone Oct 2, 2017

@mbaev

This comment has been minimized.

Show comment
Hide comment
@mbaev

mbaev Oct 23, 2017

Contributor

Всего на сайте 49 нод с ошибочными текстовыми форматами.

mysql> select count(body_format) from field_data_body where body_format = 4;
+--------------------+
| count(body_format) |
+--------------------+
|                 49 |
+--------------------+
1 row in set (0.03 sec)

mysql> select entity_id, body_format from field_data_body where body_format = 4;
+-----------+-------------+
| entity_id | body_format |
+-----------+-------------+
|        37 | 4           |
|        42 | 4           |
|        90 | 4           |
|       358 | 4           |
|       359 | 4           |
|       360 | 4           |
|       368 | 4           |
|       372 | 4           |
|       373 | 4           |
|       385 | 4           |
|       436 | 4           |
|       514 | 4           |
|       526 | 4           |
|       566 | 4           |
|       573 | 4           |
|       593 | 4           |
|       596 | 4           |
|       603 | 4           |
|       605 | 4           |
|       610 | 4           |
|       616 | 4           |
|       617 | 4           |
|       618 | 4           |
|       619 | 4           |
|       679 | 4           |
|       756 | 4           |
|       809 | 4           |
|       811 | 4           |
|       814 | 4           |
|       842 | 4           |
|       855 | 4           |
|       879 | 4           |
|      1047 | 4           |
|      1058 | 4           |
|      1149 | 4           |
|      1157 | 4           |
|      1159 | 4           |
|      1189 | 4           |
|      1226 | 4           |
|      1274 | 4           |
|      1374 | 4           |
|      1441 | 4           |
|      1519 | 4           |
|      1535 | 4           |
|      3644 | 4           |
|      4546 | 4           |
|      4941 | 4           |
|      5793 | 4           |
|      9230 | 4           |
+-----------+-------------+
49 rows in set (0.05 sec)

Contributor

mbaev commented Oct 23, 2017

Всего на сайте 49 нод с ошибочными текстовыми форматами.

mysql> select count(body_format) from field_data_body where body_format = 4;
+--------------------+
| count(body_format) |
+--------------------+
|                 49 |
+--------------------+
1 row in set (0.03 sec)

mysql> select entity_id, body_format from field_data_body where body_format = 4;
+-----------+-------------+
| entity_id | body_format |
+-----------+-------------+
|        37 | 4           |
|        42 | 4           |
|        90 | 4           |
|       358 | 4           |
|       359 | 4           |
|       360 | 4           |
|       368 | 4           |
|       372 | 4           |
|       373 | 4           |
|       385 | 4           |
|       436 | 4           |
|       514 | 4           |
|       526 | 4           |
|       566 | 4           |
|       573 | 4           |
|       593 | 4           |
|       596 | 4           |
|       603 | 4           |
|       605 | 4           |
|       610 | 4           |
|       616 | 4           |
|       617 | 4           |
|       618 | 4           |
|       619 | 4           |
|       679 | 4           |
|       756 | 4           |
|       809 | 4           |
|       811 | 4           |
|       814 | 4           |
|       842 | 4           |
|       855 | 4           |
|       879 | 4           |
|      1047 | 4           |
|      1058 | 4           |
|      1149 | 4           |
|      1157 | 4           |
|      1159 | 4           |
|      1189 | 4           |
|      1226 | 4           |
|      1274 | 4           |
|      1374 | 4           |
|      1441 | 4           |
|      1519 | 4           |
|      1535 | 4           |
|      3644 | 4           |
|      4546 | 4           |
|      4941 | 4           |
|      5793 | 4           |
|      9230 | 4           |
+-----------+-------------+
49 rows in set (0.05 sec)

@mbaev

This comment has been minimized.

Show comment
Hide comment
@mbaev

mbaev Oct 23, 2017

Contributor

Исправлено.

mysql> update field_data_body set body_format=3 where body_format = 4;
Query OK, 49 rows affected (1.80 sec)
Rows matched: 49  Changed: 49  Warnings: 0
Contributor

mbaev commented Oct 23, 2017

Исправлено.

mysql> update field_data_body set body_format=3 where body_format = 4;
Query OK, 49 rows affected (1.80 sec)
Rows matched: 49  Changed: 49  Warnings: 0

@mbaev mbaev closed this Oct 23, 2017

@mbaev

This comment has been minimized.

Show comment
Hide comment
@mbaev

mbaev Oct 23, 2017

Contributor

Тупанул. 1, конечно же...

mysql> update field_data_body set body_format=1 where entity_id in (37, 42, 90, 358, 359, 360, 368, 372, 373, 385, 436, 514, 526, 566, 573, 593, 596, 603, 605, 610, 616, 617, 618, 619, 679, 756, 809, 811, 814, 842, 855, 879, 1047, 1058, 1149, 1157, 1159, 1189, 1226, 1274, 1374, 1441, 1519, 1535, 3644, 4546, 4941, 5793, 9230);
Query OK, 49 rows affected (0.01 sec)
Rows matched: 49  Changed: 49  Warnings: 0
Contributor

mbaev commented Oct 23, 2017

Тупанул. 1, конечно же...

mysql> update field_data_body set body_format=1 where entity_id in (37, 42, 90, 358, 359, 360, 368, 372, 373, 385, 436, 514, 526, 566, 573, 593, 596, 603, 605, 610, 616, 617, 618, 619, 679, 756, 809, 811, 814, 842, 855, 879, 1047, 1058, 1149, 1157, 1159, 1189, 1226, 1274, 1374, 1441, 1519, 1535, 3644, 4546, 4941, 5793, 9230);
Query OK, 49 rows affected (0.01 sec)
Rows matched: 49  Changed: 49  Warnings: 0
@mbaev

This comment has been minimized.

Show comment
Hide comment
@mbaev

mbaev Oct 23, 2017

Contributor

Ещё ревизии

mysql> select count(body_format) from field_revision_body where body_format=4;
+--------------------+
| count(body_format) |
+--------------------+
|                 96 |
+--------------------+
1 row in set (0.05 sec)

Фикс

mysql> update field_revision_body set body_format=1 where body_format = 4;
Query OK, 96 rows affected (5.96 sec)
Rows matched: 96  Changed: 96  Warnings: 0
Contributor

mbaev commented Oct 23, 2017

Ещё ревизии

mysql> select count(body_format) from field_revision_body where body_format=4;
+--------------------+
| count(body_format) |
+--------------------+
|                 96 |
+--------------------+
1 row in set (0.05 sec)

Фикс

mysql> update field_revision_body set body_format=1 where body_format = 4;
Query OK, 96 rows affected (5.96 sec)
Rows matched: 96  Changed: 96  Warnings: 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment