Roundcube Community Forum

 

Add contact with plus sign

Started by henlon, October 09, 2009, 04:00:31 AM

Previous topic - Next topic

henlon

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

Its working for me, what browser are you using?

stevetamis

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


henlon

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

SKaero

Is there anything in you error log?

henlon

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', '[email protected]')]
[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

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

This is a new installation of 0.3.3
I use MySQL 5.0

SKaero

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

Quote from: henlon;22001This 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', '[email protected]')]
[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

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

olesj

Quote from: skaero;22550In 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

#13
Quote from: olesj;22961Can 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