[#7778] - SQL errors when installing extensions on MS SQL Server
- Closed
- 7 Sep 2015
- Medium
- Build: staging
- # 7778
- Diff
- tampe125:fix-mssql-ext-install
- Success The Travis CI build passed Details
User tests: Successful: Unsuccessful:
Executive summary
When Joomla is using MS SQL Server database, is not possible to install any extension. A SQL error message is shown or the user is logged out without any message.
As final result the installation is aborted and no extension is added to the site.
Test instructions
Apply the patch, then try to install any extension (a Joomla installation using MSSQL is required).
No error messages should be presented and you could use the extension without any issue.
Technical information
The main problem is caused by columns flagged as NOT NULL, we have to prime them with empty data.
An error occurred while updating site menu entries, too, due a syntax error in the query
Backwards compatibility
This PR does not affect backwards compatibility
Translation impact
This PR does not add, remove or modify any language strings
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Labels |
Added:
?
|
||
zero-24
- | Category | ⇒ | MS SQL |
wilsonge
- | Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-09-07 19:29:19 |
| Closed_By | ⇒ | wilsonge |
| Milestone |
Added: |
||
Look at #7145