[#11932] - Mssql: article can´t be created
- Closed
- 19 Dec 2016
- Medium
- Build: master
- # 11932
Steps to reproduce the issue
Install current staging with or without sample data and try to create a new article. You will get this error message:
8155 [Microsoft][SQL Server Native Client 11.0][SQL Server]No column name was specified for column 1 of 'A'. SQL=SELECT * FROM ( SELECT count(id) , ROW_NUMBER() OVER (ORDER BY (select 0)) AS RowNumber FROM #__usergroups) A WHERE A.RowNumber BETWEEN 1 AND 1
Expected result
Actual result
System information (as much as possible)
Additional comments
Votes
brianteeman
- | Category | ⇒ | MS SQL |
| Labels |
Added:
?
|
||
This is quite a serious issue making Joomla using MSSQL not usable with patch 381b75d applied.
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/11932.
Any progress on this? I'm experiencing the same issue in Joomla 3.6.4.
Thank you williamsandy, I found the update that you provided on another page and that helped resolve the problem.
I'm running into this issue on my server. Is there a PR for this yet? If not, I can put one together, it's easily patched.
zero-24
- | Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-12-19 19:47:23 |
| Closed_By | ⇒ | zero-24 |
wilsonge
- 
cpfeifer
-
could it be related to this? 381b75d (wild guess)