Opened 3 years ago
Closed 3 years ago
#1486459 closed Bugs (fixed)
Adding contacts error on mysql
| Reported by: | alec | Owned by: | |
|---|---|---|---|
| Priority: | 5 | Milestone: | 0.4-beta |
| Component: | Database | Version: | 0.3.1 |
| Severity: | normal | Keywords: | mysql addressbook |
| Cc: |
Description
[28-Jan-2010 00:54:11] 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 (1, now(), 0, 'EMAIL', 'email@email.com')] [Native code: 1364] [Native message: Field 'firstname' doesn't have a default value]
Change History (2)
comment:1 Changed 3 years ago by alec
comment:2 Changed 3 years ago by alec
- Resolution set to fixed
- Status changed from new to closed
Fixed in [951c07b1].
Note: See
TracTickets for help on using
tickets.

The same with MSSQL. 'Firstname' and 'surname' columns could be "DEFAULT NULL", maybe 'name' too.