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/
