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/