MySQL ошибка 1067 Битрикс
MySQL ошибка 1067 Битрикс Возникла проблема с сайтом.
версия 10.3.15-MariaDB-1:10.3.15+maria~bionic
при попытке исправить
лечится
ALTER TABLE `b_seo_sitemap` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_perf_cluster` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_perf_history` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_catalog_store` CHANGE `DATE_MODIFY` `DATE_MODIFY` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_catalog_contractor` CHANGE `DATE_MODIFY` `DATE_MODIFY` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_event_message` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_group` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_user` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_user_field_confirm` CHANGE `DATE_CHANGE` `DATE_CHANGE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_module` CHANGE `DATE_ACTIVE` `DATE_ACTIVE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_module_to_module` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_file` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_event_log` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_user_hit_auth` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
версия 10.3.15-MariaDB-1:10.3.15+maria~bionic
при попытке исправить
лечится
ALTER TABLE `b_seo_sitemap` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_perf_cluster` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_perf_history` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_catalog_store` CHANGE `DATE_MODIFY` `DATE_MODIFY` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_catalog_contractor` CHANGE `DATE_MODIFY` `DATE_MODIFY` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_event_message` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_group` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_user` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_user_field_confirm` CHANGE `DATE_CHANGE` `DATE_CHANGE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_module` CHANGE `DATE_ACTIVE` `DATE_ACTIVE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_module_to_module` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_file` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_event_log` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ALTER TABLE `b_user_hit_auth` CHANGE `TIMESTAMP_X` `TIMESTAMP_X` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
Комментарии (2)
Спасибо, сработало!
17 ноября, 2021 в 18:36Спасибо, очень выручили!
03 февраля, 2020 в 13:10