Topic: Unknown column 'unchecked_lovers_maps' in 'policy'
==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
======== Required information ====
- iRedMail version: 0.8.4
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Linux/BSD distribution name and version: Centos 5.5
- Related log if you're reporting an issue:
====
While upgrading to 0.8.5 I have applied the patch to "Fix incorrect SQL column name in Amavisd database" but this the output of my operation:
mysql> USE amavisd;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> ALTER TABLE policy CHANGE unchecked_lovers_maps unchecked_lover CHAR(1) DEFAULT NULL;
ERROR 1054 (42S22): Unknown column 'unchecked_lovers_maps' in 'policy'
mysql> exit
Bye
I have just updated amavisd-new from 2.6.4-3 to 2.8.0-1 using yum and dag repo.
Attached to this post the amavisd.conf file and the print of policy table.
Thanks for your collaboration,
Cocco
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.