Mailzu - There was an error executing your query - after 2.7.0 SQL changes

[Giovanni Bechis]

Gary V <mr88talent at gmail.com> wrote:
> I updated an SQL database per release notes in 2.7.0
> http://www.amavis.org/release-notes.txt :
> 
>  The following SQL directives can be used to add these new fields:
>    ALTER TABLE msgrcpt ADD rseqnum     integer  DEFAULT 0   NOT NULL;
>    ALTER TABLE msgrcpt ADD content     char(1)  DEFAULT ' ' NOT NULL;
>    ALTER TABLE msgrcpt ADD is_local    char(1)  DEFAULT ' ' NOT NULL;
>    ALTER TABLE msgs    ADD originating char(1)  DEFAULT ' ' NOT NULL;
> 
> and now when initially logging into Malzu, I was getting an error on
> the Summary page "There was an error executing your query:". I looked
> in the mailzu log and executed the query manually and got:
> 
I posted a patch on Mailzu tracker on Sourceforge:
http://sourceforge.net/tracker/?func=detail&aid=3365667&group_id=137277&atid=738236
 Cheers
  Giovanni