1 (edited by mr.cocco 2014-12-27 19:56:34)

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

Post's attachments

amavisd.conf 24.2 kb, file has never been downloaded. 

table_policy.pdf 17.68 kb, 1 downloads since 2014-12-27 

You don't have the permssions to download the attachments of this post.

----

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

2

Re: Unknown column 'unchecked_lovers_maps' in 'policy'

Did you upgrade amavisd sql database after upgraded amavisd package?

3

Re: Unknown column 'unchecked_lovers_maps' in 'policy'

ZhangHuangbin wrote:

Did you upgrade amavisd sql database after upgraded amavisd package?

Ops I didn't.
Could you please paste a link to a some tutorial?

4

Re: Unknown column 'unchecked_lovers_maps' in 'policy'

mr.cocco wrote:

Could you please paste a link to a some tutorial?

You can remove old Amavisd database first, then create a new one with correct SQL template file. You can find template file used by iRedMail here: https://bitbucket.org/zhb/iredmail/src/ … s/amavisd/ (file 'amavisd-2.7.0.[mysql,pgsql] work with Amavisd-2.7.0 - 2.10.x).