Author Topic: Can not add anybody to my address book. MYSQL db error I'm sure...  (Read 3365 times)

Offline wetjet43

  • Jr. Member
  • **
  • Posts: 19
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', 'testuser@testdomain.net') [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.


Offline wetjet43

  • Jr. Member
  • **
  • Posts: 19
Re: Can not add anybody to my address book. MYSQL db error I'm sure...
« Reply #1 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!

Offline Farkhod

  • Newbie
  • *
  • Posts: 1
Addressbook donn't want to add contact
« Reply #2 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', 'admin@samarkand.uz', '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

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Can not add anybody to my address book. MYSQL db error I'm sure...
« Reply #3 on: November 24, 2008, 12:55:36 AM »
Is database field 'contact_id' set to auto increment?
Regards,
Rosali
__________________
MyRoundcube Project (commercial)