> >> 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/ >
_______________________________________________ List info: http://lists.roundcube.net/users/
