Roundcube Community Forum

 

Can not add anybody to my address book. MYSQL db error I'm sure...

Started by wetjet43, February 07, 2007, 01:20:13 AM

Previous topic - Next topic

wetjet43

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.


wetjet43

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!

Farkhod

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

rosali

Regards,
Rosali