Ticket #1483820 (closed Bugs: fixed)
database error saving contact after LDAP query
| Reported by: | estadtherr@… | Owned by: | estadtherr |
|---|---|---|---|
| Priority: | 3 | Milestone: | 0.1-rc1 |
| Component: | Database | Version: | 0.1-beta |
| Severity: | normal | Keywords: | |
| Cc: |
Description
The following error comes up when trying to save a contact returned from an LDAP query to the address book:
DB Error in /Library/WebServer/SecureDocuments/roundcube/program/include/rcube_db.inc (478): DB Error: syntax error Query: INSERT INTO contacts (user_id, name, email VALUES (1,' <contact name> ',' <contact e-mail> ') [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUES (1,' <contact name> ',' <contact e-mail> ')' at line 3]
The error is a missing ')' in the INSERT statement in program/steps/addressbook/save.inc line 154
