Feeling Lucky
?
[#13506] - Mssql: error when creating a category on the fly
- Closed
- 8 Jan 2017
- Medium
- Build: staging
- # 13506
Steps to reproduce the issue
Go to an article and create a category on the fly. You should get this error:
515 [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'description', table 'joomla35.dbo.#__categories'; column does not allow nulls. INSERT fails.
Expected result
Actual result
System information (as much as possible)
Additional comments
joomla-cms-bot
- | Labels |
Added:
?
|
||
waader
- comment
- 8 Jan 2017
These fields need default values in order to make this work for mssql:
[description] [nvarchar](max) NOT NULL DEFAULT '',
[params] [nvarchar](max) NOT NULL DEFAULT '',
[metadesc] [nvarchar](1024) NOT NULL DEFAULT '',
[metakey] [nvarchar](1024) NOT NULL DEFAULT '',
[metadata] [nvarchar](2048) NOT NULL DEFAULT '',
andrepereiradasilva
- comment
- 8 Jan 2017
working on it
zero-24
- | Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-01-08 15:26:03 |
| Closed_By | ⇒ | zero-24 |
similar solution to #13510