[RCU] Unable to save email addresses from messagesintocontacttable

Eric cephelo at gmail.com
Wed Jan 23 02:39:51 CET 2008


Something like:

alter table contacts alter column firstname set default '';

(for PostgreSQL - I'm sure MySQL has something similar.)

On Jan 22, 2008 2:43 PM, Jason Levine <jason at wiredhosting.com> wrote:
> Eric ,
>
> Can you be so kind to provide me with a little more detail on how you fixed
> this ?
>
> Thanks,
> Jason
>
>
> ----- Original Message -----
> From: "Eric" <cephelo at gmail.com>
> To: <users at lists.roundcube.net>
> Sent: Tuesday, January 22, 2008 11:36 AM
> Subject: Re: [RCU] Unable to save email addresses from
> messagesintocontacttable
>
>
> > Postgres has this same issue. The default scheme is incorrect unless
> > the user enters EVERY field on the contact form. Identities has a
> > similar issue. I had to add blank defaults to all the columns
> > manually.
> >
> > On Jan 22, 2008 2:09 PM, Jason Levinewrote:
> >> If it was a permissions issue I don't think I would be allowed to add
> >> contacts at all.
> >> This only happens from the page that the user reads their email.
> >>
> >> It looks like a bug in MySQL. Is there anyone else that has encountered
> >> this
> >> issue ?
> >>
> >>
> >> ----- Original Message -----
> >> From: "kmnair" <kmnair at gmail.com>
> >> To: "Jason Levine" <>
>
> >> Cc: <users at lists.roundcube.net>
> >> Sent: Thursday, January 17, 2008 7:31 PM
> >> Subject: Re: [RCU] Unable to save email addresses from messages
> >> intocontacttable
> >>
> >>
> >>
> >> > On 1/18/08, Jason Levine <jason at wiredhosting.com> wrote:
> >> >>
> >> >> OK..I narrowed it down to this.
> >> >> If I comment this line out in the my.ini file I am able to add my
> >> >> contacts :
> >> >>
> >> >> # Set the SQL mode to strict
> >> >> # sql-
> >> >> mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
> >> >> I don't know what damage I am doing elsewhere by commenting this out,
> >> >> so
> >> >> maybe someone might have a less inrusive suggestion for me ?
> >> >>
> >> >>
> >> >> Thanks,
> >> >> Jason
> >> >
> >> >
> >> > Looks like there is a user permission error on the db. Please check
> >> > what are the permissions that you have given to the roundcube user on
> >> > the database. See the trac for the permissions required.
> >> >
> >> > kmnair
> >> >
> >>
> >> _______________________________________________
> >> List info: http://lists.roundcube.net/users/
> >>
> > _______________________________________________
> > List info: http://lists.roundcube.net/users/
> >
>
> _______________________________________________
> List info: http://lists.roundcube.net/users/
>
_______________________________________________
List info: http://lists.roundcube.net/users/



More information about the users mailing list