Задать вопрос
SaveLolliPoP
@SaveLolliPoP
1 / 0 = ∞
mysql

Как исправить проблему со знаками вопросов после установки?

Иероглифы меня мучают, как можно их исправить?
В гугле информация не актуальная.
При установке указал UTF-8
261fc3bd892241e48e5e27b6147d0cc4.png

Поменял в бд сравнения на utf8-general-ci с latin1_swedish_ci


ALTER TABLE `rielt2`.`modx_access_actiondom` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_actions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_category` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_context` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_elements` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_media_source` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_menus` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_namespace` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_permissions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_policies` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_policy_templates` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_policy_template_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_resources` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_resource_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_access_templatevars` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_actiondom` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_actions_fields` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_actions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_active_users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_categories_closure` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_categories` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_class_map` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_collection_resource_template` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_collection_selections` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_collection_settings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_collection_templates` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_collection_template_columns` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_content_type` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_context_resource` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_context_setting` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_context` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_dashboard_widget_placement` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_dashboard_widget` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_dashboard` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_documentgroup_names` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_document_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_element_property_sets` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_extension_packages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_fc_profiles_usergroups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_fc_profiles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_fc_sets` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_formit_forms` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_lexicon_entries` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_manager_log` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_media_sources_contexts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_media_sources_elements` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_media_sources` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_membergroup_names` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_member_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_menus` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_namespaces` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_property_set` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_register_messages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_register_queues` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_register_topics` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_session` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_shopkeeper3_config` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_shopkeeper3_orders` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_shopkeeper3_purchases` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_content` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_htmlsnippets` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_plugins` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_plugin_events` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_snippets` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_templates` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_tmplvars` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_tmplvar_access` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_tmplvar_contentvalues` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_site_tmplvar_templates` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_system_eventnames` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_system_settings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_transport_packages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_transport_providers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_user_attributes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_user_group_roles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_user_group_settings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_user_messages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_user_settings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rielt2`.`modx_workspaces` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;


Как кодировку поменял, если файл с "???????????" переименовать допустим в "Главная", то все шикарно сохраняется. Теперь вопрос как обнулить все значения?
  • Вопрос задан
  • 214 просмотров
14 комментариев
Подписаться 1 Оценить 14 комментариев
Решения вопроса 1
SaveLolliPoP
@SaveLolliPoP Автор вопроса
1 / 0 = ∞
Сделал полную переустановку. После того как создал базу поставил ей сравнение utf8_general_ci, после установил.
Установка проходила в крякозябрах, но результат желаемый (Наверное хостер что то там подкручивал тк и jino паралельно писал). Спасибо вам огромное!
Ответ написан
Комментировать
Комментировать
Пригласить эксперта
Ваш ответ на вопрос

Войдите, чтобы написать ответ

Похожие вопросы
Вакансии с Хабр Карьеры
Администратор PostgreSQL
Гринатом
До 200 000 ₽
Senior PHP Программист
Автомакон
от 287 000 до 440 000 ₽
WordPress-разработчик
div. • Ставрополь
от 50 000 до 120 000 ₽
Ещё вакансии
Заказы с Хабр Фриланса
Настроить OpenVPN на роутере Deco95
20 нояб. 2024, в 09:18
3000 руб./за проект
Настроить передачу конверсий из Bitrix24 в Google Analytics
20 нояб. 2024, в 08:51
10000 руб./за проект
Доработать\исправить поисковый widget для сайта на vue3+nuxt
20 нояб. 2024, в 06:37
12000 руб./за проект
Ещё заказы