We have a Problem by using limesurvey with MSSQL. We test it with MariaDB/MYSQL and don´t have this Problem. But we have to run it with MSSQL in Production.
With MSSQL The Basic Installation works fine without any Errors. Tables are created by the Installation Process.
I can create a new Survey and new Surveygroup. But when I add a new Question to this group and click "save and new" I got a error that the question is not created. But it is.
When I create another question and click just "save", then I got a empty site and the question ID is not shown in the URL. When I go backup the backend Limesurvey say again, that the question is not created. But its there.
So with MySQL we don´t have this Problem but with MSSQL. I can´t see any PHP Error´s or Apache Error´s. Debug is set to "1"
Hello, I have the same problem, did you report the bug?
I also tried to run all the queries from the debug output but there are missing parameters
for example:
Code:
SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN[INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name =:table AND k.table_schema =:schema. Bound with :table='ls_surveys',:schema='dbo'
It would be of great help having all the queries to get to the error easily, I think it is a query that did not run.
Topic Author
