Again I ask to remove me from your list, I do not like your junk mail
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@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@gmail.com To: users@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@gmail.com To: "Jason Levine" <>
Cc: users@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@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/
List info: http://lists.roundcube.net/users/
List info: http://lists.roundcube.net/users/