[#4671] - Unable to create new contact item in mssql
- Closed
- 16 Oct 2014
- Medium
- Build: master
- # 4671
Steps to reproduce the issue
Create a new contact item, click "Save."
Expected result
A new contact item is successfully created.
Actual result
An error is thrown, showing that the "checked_out" field does not allow nulls.
System information (as much as possible)
J!3.3.6, IIS server, MS-SQL database.
Additional comments
Proposed solution is to update the database to accept "0" as the default for the checked_out database field.
ALTER TABLE dbo.#__contact_details ADD CONSTRAINT DF_#__contact_details_checked_out DEFAULT 0 FOR checked_out
| Title |
|
||||||
Not 100% clear on how to do that properly, but I've created the pull request.
#4686
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4671.
| Labels |
Added:
?
|
||
We tested this in an Apache server with MySQL and everything works for us. So it must be isolated to MS SQL or Postgres on IIS.
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4671.
zero-24
- | Status | New | ⇒ | Closed |
| Rel_Number | ⇒ | 4686 | |
| Relation Type | ⇒ | Related to |
Set to "closed" on behalf of @brianteeman by The JTracker Application at issues.joomla.org/joomla-cms/4671
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-10-16 17:04:59 |
| Labels |
Added:
?
|
||
Changed the title
Please can you submit a pull request with your changes
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4671.