Roundcube Community Forum

Release Support => Pending Issues => Topic started by: wetjet43 on February 07, 2007, 01:20:13 AM

Title: Can not add anybody to my address book. MYSQL db error I'm sure...
Post by: wetjet43 on February 07, 2007, 01:20:13 AM
When I try to add a user to my rc addressbook, I get an error that pops up. It says "An error occured while saving"

The error logs display:

[06-Feb-2007 22:13:23 -0800] DB Error: DB Error: unknown error Query: INSERT INTO contacts (user_id, changed, del, name, firstname, surname, email) VALUES ('1', now(), 0, 'Joe', 'Shmo', 'Joe Shmo', '[email protected]') [nativecode=1364 ** Field 'vcard' doesn't have a default value] in E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\program\include\rcube_db.inc on line 501

I think it's a mysql db error, but I'm not sure. I've changed the real names and email address of course to joe shmo.

Title: Re: Can not add anybody to my address book. MYSQL db error I'm sure...
Post by: wetjet43 on February 07, 2007, 01:34:49 AM
Never mind, I fixed that one too. I simply deleted the column "vcard" out of the mysql database under contacts/columns and presto! All is well!
Title: Addressbook donn't want to add contact
Post by: Farkhod on November 22, 2008, 03:33:15 AM
I've such problem:

[22-Nov-2008 13:27:56 +0500] DB Error: DB Error: unknown error Query:
INSERT INTO contacts (user_id, changed, del, `name`, `email`, `firstname`,
`surname`) VALUES ('8', now(), 0, 'rr', '[email protected]', 'Farkhod',
'dfdf') [nativecode=1364 ** Field 'contact_id' doesn't have a default value]
 in D:\HTML\apache\htdocs\email\program\include\rcube_db.inc on line 521

if somebody knows the metter please let me know!!!thanks a lot
Title: Can not add anybody to my address book. MYSQL db error I'm sure...
Post by: rosali on November 24, 2008, 12:55:36 AM
Is database field 'contact_id' set to auto increment?