1 Topic by dsp3

  • dsp3
  • Member
  • Offline
  • Registered: 2015-12-23
  • Posts: 104

Topic: Sql error on 0.9.9 upgrade

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


I have run into this error

mysql vmail < /root/iredmail.mysql

ERROR 1091 (42000) at line 4: Can't DROP 'local_part'; check that column/key exists

----

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: Sql error on 0.9.9 upgrade

Where did you download this "iredmail.mysql"? i suppose there's no "local_part" column involved in iRedMail-0.9.9.

3 Reply by dsp3

  • dsp3
  • Member
  • Offline
  • Registered: 2015-12-23
  • Posts: 104

Re: Sql error on 0.9.9 upgrade

ZhangHuangbin wrote:

Where did you download this "iredmail.mysql"? i suppose there's no "local_part" column involved in iRedMail-0.9.9.

https://bitbucket.org/zhb/iredmail/raw/ … mail.mysql

4 Reply by dsp3 (edited by dsp3 2018-12-17 20:33:23)

  • dsp3
  • Member
  • Offline
  • Registered: 2015-12-23
  • Posts: 104

Re: Sql error on 0.9.9 upgrade

My bad. Was in wrong directory! Close