1 Topic by mirono+red

  • mirono+red
  • Member
  • Offline
  • Registered: 2018-12-12
  • Posts: 6

Topic: Issue during upgrade from 0.9.7 to 0.9.8

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No - iRedAdmin (not pro)
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

While performing the step:
root@ognius:~# mysql vmail < /root/iredmail.mysql

I get the following error:
ERROR 1292 (22007) at line 4: Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastlogindate' at row 1
root@ognius:~#

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,091

Re: Issue during upgrade from 0.9.7 to 0.9.8

You missed upgrade tutorial for iRedMail-0.9.6:
file:///Users/zhb/projects/docs/html/upgrade.iredmail.0.9.5.1-0.9.6.html#fix-invalid-default-datetime-value-for-some-sql-columns-in-vmail-database