Forumlar / National / Russian / Тех. поддержка / Ошибка при апдейте

Snake07
#42886 2017-05-23 20:08

Members

При осуществлении апдейта движка с 0.9.13 на 0.9.19 на VPS с PHP 7.0, mysql 5.7 (работающий через docker) бьет следующую ошибку

Fatal error

2017-05-23 20:00

SQL error 22007: Invalid datetime format: 1292 Incorrect date value: '0000-00-00' for column 'user_birthdate' at row 1

#0  cot_diefatal(SQL error 22007: Invalid datetime format: 1292 Incorrect date value: '0000-00-00' for column 'user_birthdate' at row 1) called at [/var/www/sigma/data/www/sigma/system/database.php:582]
#1  CotDB->query(UPDATE `sed_users` SET `user_birthdate`=NULL  WHERE `user_birthdate`='0000-00-00') called at [/var/www/sigma/data/www/sigma/system/database.php:524]
#2  CotDB->runScript(
UPDATE `cot_users` SET `user_birthdate`=NULL  WHERE `user_birthdate`='0000-00-00';
ALTER TABLE `cot_users` CHANGE `user_birthdate` `user_birthdate` DATE NULL DEFAULT NULL;) called at [/var/www/sigma/data/www/sigma/system/extensions.php:81]
#3  cot_apply_patches(modules/users/setup, 0.9.4.3) called at [/var/www/sigma/data/www/sigma/system/extensions.php:496]
#4  cot_extension_install(users, 1, 1) called at [/var/www/sigma/data/www/sigma/modules/install/inc/install.update.php:279]
#5  include(/var/www/sigma/data/www/sigma/modules/install/inc/install.update.php) called at [/var/www/sigma/data/www/sigma/install.php:137]