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 Levine jason@wiredhosting.com wrote:
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" jason@wiredhosting.com 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/