Unable to create new contact item in mssql

[adrianfso]

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

[brianteeman]

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.

[adrianfso]

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.

[nicksavov]

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.

[jissues-bot]

Set to "closed" on behalf of @brianteeman by The JTracker Application at issues.joomla.org/joomla-cms/4671

[brianteeman]

Please see proposed solution #4686