11-12-2016, 04:55 PM
I move my coreBOS from a centOS cloud to Ubuntu 16.10 local server
All user not login any more .. i think is a md5 problem ..
I try changed password with a coreBOS documentation
http://corebos.org/documentation/doku.php?id=en:adminmanual:faq#how_can_i_reset_the_admin_user
When
UPDATE vtiger_users SET user_password='$1$ad$hsl2KFybNRnbXBa.b.WWv.', crypt_type='MD5' WHERE id=1;
System show me
MySQL error: Incorrect datetime value: '0000-00-00 00:00:00' for column 'logout_time' at row 1
All user not login any more .. i think is a md5 problem ..
I try changed password with a coreBOS documentation
http://corebos.org/documentation/doku.php?id=en:adminmanual:faq#how_can_i_reset_the_admin_user
When
UPDATE vtiger_users SET user_password='$1$ad$hsl2KFybNRnbXBa.b.WWv.', crypt_type='MD5' WHERE id=1;
System show me
MySQL error: Incorrect datetime value: '0000-00-00 00:00:00' for column 'logout_time' at row 1