Author Topic: Add contact with plus sign (Read 6910 times)

henlon · « **on:** October 09, 2009, 04:00:31 AM »

In my two latest installations of RC (0.2.2 and 0.3) the brilliant function to add addresses to the addressbook by clicking the plus-sign doesent work.
When I press the plus sign RC tells me that it can't save the address?

Any suggestions how to solv this problem?

SKaero · « **Reply #1 on:** October 09, 2009, 04:56:17 AM »

Its working for me, what browser are you using?

stevetamis · « **Reply #2 on:** October 09, 2009, 05:33:39 AM »

Hi Everyone!

This is nice experience to being part of this site actually this topic.We can express our self with the help of this type of site.Good nice topic......

henlon · « **Reply #3 on:** October 09, 2009, 07:12:31 AM »

I'm using IE 8

henlon · « **Reply #4 on:** October 09, 2009, 07:16:12 AM »

I have tried with firefox on a ubuntu mashine and it is the same.

SKaero · « **Reply #5 on:** October 09, 2009, 12:31:52 PM »

Is there anything in you error log?

henlon · « **Reply #6 on:** October 10, 2009, 04:58:31 AM »

This is the error message i receive in the error log:

[10-Oct-2009 10:46:41] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: INSERT INTO contacts
(user_id, changed, del, `name`, `email`)
VALUES (3, now(), 0, 'Info', 'info@mjhobby.se')]
[Native code: 1364]
[Native message: Field 'firstname' doesn't have a default value]

It looks like RC doesent put in a value for the 'firstname' field.
Possibly because there is no FirstName to extract from the senders emailadress.

I'll tried to set the database field value to accept empty field for 'firstname' and 'surname' and then it works fine.

Is this a bug in this versions of RC?

SKaero · « **Reply #7 on:** October 10, 2009, 05:36:58 AM »

I tried it with a fresh install of version 3 and it works for me. Did you upgrade form a older version of RoundCube? What database are you using?

henlon · « **Reply #8 on:** October 10, 2009, 11:13:38 AM »

This is a new installation of 0.3.3
I use MySQL 5.0

SKaero · « **Reply #9 on:** October 10, 2009, 11:37:06 AM »

RoundCube is only at version 0.3 not 3.3. I can't reproduce it, but if it happens again report it to Roundcube Webmail

olesj · « **Reply #10 on:** October 26, 2009, 06:38:17 PM »

Quote from: henlon;22001

This is the error message i receive in the error log:

[10-Oct-2009 10:46:41] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: INSERT INTO contacts
(user_id, changed, del, `name`, `email`)
VALUES (3, now(), 0, 'Info', 'info@mjhobby.se')]
[Native code: 1364]
[Native message: Field 'firstname' doesn't have a default value]

It looks like RC doesent put in a value for the 'firstname' field.
Possibly because there is no FirstName to extract from the senders emailadress.

I'll tried to set the database field value to accept empty field for 'firstname' and 'surname' and then it works fine.

Is this a bug in this versions of RC?

What was you change and in witch file .

I tried to reinstall the MySql database and the rc031 still the same error .

SKaero · « **Reply #11 on:** October 27, 2009, 03:15:19 AM »

In the database you need to add a blank default value for the 'firstname' and 'surnam' columns in the contacts table.

olesj · « **Reply #12 on:** November 09, 2009, 05:55:10 PM »

Quote from: skaero;22550

In the database you need to add a blank default value for the 'firstname' and 'surnam' columns in the contacts table.

Can you tell me how to add this field to the database

olesj · « **Reply #13 on:** November 09, 2009, 06:01:44 PM »

Quote from: olesj;22961

Can you tell me how to add this field to the database

I found the solution .....

I had to set the firstname and surename to accept NULL in MYSQL database