> 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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> >> To: <[email protected]> >> 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" <[EMAIL PROTECTED]> >> >> To: "Jason Levine" <> >> >> >> Cc: <[email protected]> >> >> 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 <[EMAIL PROTECTED]> 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/ >
_______________________________________________ List info: http://lists.roundcube.net/users/
