Hi Group ,
Clicking on the "+" sign next to an email address to add them as a contact generates the following error in a red bar at the top of the page :
"Could not save the contact address"
It does check to see if it is already an address, because when I try to add an address that is already in my address book it says
"A Contact with this email address already exists"
So I am guessing I might be having a problem writing from this page to the contact tbale...any ideas ?
Thanks, Jason
List info: http://lists.roundcube.net/users/
Here is the message in the erro log that is generated when I try to add a contact from a message :
[17-Jan-2008 14:20:17 -0800] DB Error: DB Error: unknown error Query: INSERT INTO contacts (user_id, changed, del, name, email) VALUES ('1', now(), 0, 'Users', 'users@lists.roundcube.net') [nativecode=1364 ** Field 'firstname' doesn't have a default value] in D:\roundmail\roundcubemail-0.1-rc2\program\include\rcube_db.inc on line 505
Thanks, Jason
----- Original Message ----- From: Jason Levine To: users@lists.roundcube.net Sent: Thursday, January 17, 2008 2:18 PM Subject: [RCU] Unable to save email addresses from messages into contacttable
Hi Group ,
Clicking on the "+" sign next to an email address to add them as a contact generates the following error in a red bar at the top of the page :
"Could not save the contact address"
It does check to see if it is already an address, because when I try to add an address that is already in my address book it says
"A Contact with this email address already exists"
So I am guessing I might be having a problem writing from this page to the contact tbale...any ideas ?
Thanks, Jason
List info: http://lists.roundcube.net/users/
List info: http://lists.roundcube.net/users/
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
----- Original Message ----- From: Jason Levine To: users@lists.roundcube.net Sent: Thursday, January 17, 2008 2:22 PM Subject: Re: [RCU] Unable to save email addresses from messages intocontacttable
Here is the message in the erro log that is generated when I try to add a contact from a message :
[17-Jan-2008 14:20:17 -0800] DB Error: DB Error: unknown error Query: INSERT INTO contacts (user_id, changed, del, name, email) VALUES ('1', now(), 0, 'Users', 'users@lists.roundcube.net') [nativecode=1364 ** Field 'firstname' doesn't have a default value] in D:\roundmail\roundcubemail-0.1-rc2\program\include\rcube_db.inc on line 505
Thanks, Jason
----- Original Message -----
From: Jason Levine
To: users@lists.roundcube.net
Sent: Thursday, January 17, 2008 2:18 PM
Subject: [RCU] Unable to save email addresses from messages into contacttable
Hi Group ,
Clicking on the "+" sign next to an email address to add them as a contact generates the following error in a red bar at the top of the page :
"Could not save the contact address"
It does check to see if it is already an address, because when I try to add an address that is already in my address book it says
"A Contact with this email address already exists"
So I am guessing I might be having a problem writing from this page to the contact tbale...any ideas ?
Thanks,
Jason
_______________________________________________
List info: http://lists.roundcube.net/users/
List info: http://lists.roundcube.net/users/
List info: http://lists.roundcube.net/users/
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/
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/
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/
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/
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/
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/
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/
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/
You might have missed this is the monthly mailings :
In addition to the URL interfaces, you can also use email to make such changes. For more info, send a message to the '-request' address of the list (for example, mailmanrc-request@lists.roundcube.net) containing just the word 'help' in the message body, and an email message will be sent to you with instructions.
That would mean you should send a message to "users-
request@lists.roundcube.net" with the word "help" in the body.
You should get back instructions on how to remove yourself from the
list.
Charles Dostale System Admin - Silver Oaks Communications http://www.silveroaks.com/ 824 17th Street, Moline IL 61265
List info: http://lists.roundcube.net/users/
I'm thinking that what "you people" need to do is make it much more difficult to subscribe to the list in the first place. That way, we could insure that if you're smart enough to subscribe to the list, you're going to be smart enough to unsubscribe. As it stands, there's always someone who's smart enough to get onto the list but not smart enough to get off the list.
geez.
On Jan 23, 2008 11:51 AM, Bud Eastridge bud@bearcreekstoves.com wrote:
Again I ask to remove me from your list, I do not like your junk mail
,
List info: http://lists.roundcube.net/users/
Agreed. How did someone like this get on the list to begin with?
Proof positive that the internet is just too "high speed" for some folks...
On Jan 23, 2008 3:43 PM, Kenn Murrah kennmurrah@gmail.com wrote:
I'm thinking that what "you people" need to do is make it much more difficult to subscribe to the list in the first place. That way, we could insure that if you're smart enough to subscribe to the list, you're going to be smart enough to unsubscribe. As it stands, there's always someone who's smart enough to get onto the list but not smart enough to get off the list.
geez.
On Jan 23, 2008 11:51 AM, Bud Eastridge bud@bearcreekstoves.com wrote:
Again I ask to remove me from your list, I do not like your junk mail
,
List info: http://lists.roundcube.net/users/
-
Bud Eastridge -
chasd -
Eric -
Jason Levine -
Kenn Murrah -
kmnair -
Tommy