Bug #25960
closed
Some DB fields needs to be varchar to support MSSQL
100%
Description
There are some fields in the sys_workspace table, which are of type text at the moment. This is a problem for MSSQL, as MSSQL is not able to compare type text fields in a query like "adminusers = '5'".
Solution is to change the types of these three fields (adminusers, members, reviewers) to varchar(4000). Tested in a MSSQL database and a MySQL database, works for both.
I will attach a patch soon.
Files
Updated by Sonja Schubert about 13 years ago
- File _25960.patch _25960.patch added
Updated by Sonja Schubert almost 13 years ago
- Assignee set to Sonja Schubert
have to be varchar(255)
Updated by Mr. Hudson almost 13 years ago
Patch set 1 of change I98ff366b6857be00ae429bd750817e3329879878 has been pushed to the review server.
It is available at http://review.typo3.org/1971
Updated by Sonja Schubert almost 13 years ago
- Status changed from New to Under Review
Updated by Mr. Hudson almost 13 years ago
Patch set 2 of change I98ff366b6857be00ae429bd750817e3329879878 has been pushed to the review server.
It is available at http://review.typo3.org/1971
Updated by Sonja Schubert almost 13 years ago
- Status changed from Under Review to Resolved
Applied in changeset commit:1fa2086a1793a262ba18f1c6801ed09e5ad11a5e.
Updated by Michael Stucki over 10 years ago
- Project changed from 624 to TYPO3 Core
- Category changed from Workspaces to Workspaces
- Target version deleted (
4.5.3)
Updated by