View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 12
IDProjectCategoryView StatusDate SubmittedLast Update
19016Bug reportsInstallationpublic2023-08-07 11:142026-09-17 13:12
Reporterzufolo441 Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version6.2.0-dev 
Summary19016: unable to create tables in MS SQL Server during install using dblib
Description

Hi,
I tried to install LimeSurvey in a Debian server,
I installed php_sybase driver (dblib)
During installation LS accepts credentials and connect to DB, it says everything ok, but it didn't create tables in DB, so it fails creating users step.
I had to make a second, temporary, install on Windows+IIS+PHP, complete installation on the same database and then connect to it from Debian installation. In this way it works.

Steps To Reproduce

try to install from Debian with MSL Sql server and php_sybase (dblib) driver.

TagsNo tags attached.
Bug heat12
Complete LimeSurvey version number (& build)6.2.0
I will donate to the project if issue is resolvedNo
BrowserFirefox 116
Database type & versionMicrosoft SQL Server 2012 (SP3-GDR) (KB4019092) - 11.0.6251.0 (X64)
Server OS (if known)Debian 12
Webserver software & version (if known)nginx + php-fpm
PHP Version8.2

Users monitoring this issue

lmserique

Activities

ollehar

ollehar

2023-08-07 11:26

reporter   ~76449

What's Sybase? It says on php.net that the extension was removed in PHP 7.0.
zufolo441

zufolo441

2023-08-07 12:10

reporter   ~76450

Hi,
In Debian I have to install php_sybase package in order to see "Microsoft SQL server (dblib)" option in LimeSurvey setup.
Except for database schema creation, it works.
zufolo441

zufolo441

2023-08-07 12:14

reporter   ~76451

Immagine.png (6,016 bytes)   
Immagine.png (6,016 bytes)   
ollehar

ollehar

2023-08-07 13:51

reporter   ~76455

Does Yii 1.1 support that driver?
lmserique

lmserique

2023-08-23 16:36

reporter   ~76689

Sybase and MsSql uses the same protocol (Tabular Data Stream Protocol), so when zufolo441 installed the sybase driver, he actually met the limesuvey dependency for pdo_dblib.

Anyway, I´m with the same issue. Populate DB process goes green but no tables or records actually created.

LimeSurvey 6.2.3

Apache HTTPD

system2.png (4,903 bytes)   
system2.png (4,903 bytes)   
system.png (41,974 bytes)   
system.png (41,974 bytes)   
zufolo441

zufolo441

2023-08-25 16:48

reporter   ~76726

The only way I found to get ms-sql working from linux is using ODBC driver instead of dblib. see 19050
c_schmitz

c_schmitz

2026-09-14 16:37

administrator   ~85734

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=40331
LimeBot

LimeBot

2026-09-17 13:12

administrator   ~85822

Fixed in Release 7.1.2+260917

Related Changesets

LimeSurvey: master 1eb7eff2

2026-09-14 16:37

c_schmitz


Details Diff		 Fixed issue 19016: Unable to create tables in MS SQL Server during install using dblib Affected Issues
19016
mod - application/core/db/DbConnection.php Diff File
add - application/core/db/LimeSurveyMssqlPdoAdapter.php Diff File
mod - application/models/InstallerConfigForm.php Diff File

Issue History

Date Modified Username Field Change
2023-08-07 11:14 zufolo441 New Issue
2023-08-07 11:26 ollehar Note Added: 76449
2023-08-07 11:26 ollehar Bug heat 0 => 2
2023-08-07 11:26 ollehar Assigned To => ollehar
2023-08-07 11:26 ollehar Status new => feedback
2023-08-07 12:10 zufolo441 Note Added: 76450
2023-08-07 12:10 zufolo441 Bug heat 2 => 4
2023-08-07 12:10 zufolo441 Status feedback => assigned
2023-08-07 12:14 zufolo441 Note Added: 76451
2023-08-07 12:14 zufolo441 File Added: Immagine.png
2023-08-07 13:51 ollehar Note Added: 76455
2023-08-07 15:03 ollehar Priority none => normal
2023-08-07 15:03 ollehar Status assigned => feedback
2023-08-23 16:24 lmserique Issue Monitored: lmserique
2023-08-23 16:24 lmserique Bug heat 4 => 6
2023-08-23 16:36 lmserique Note Added: 76689
2023-08-23 16:36 lmserique File Added: system2.png
2023-08-23 16:36 lmserique File Added: system.png
2023-08-23 16:36 lmserique Bug heat 6 => 8
2023-08-25 16:48 zufolo441 Note Added: 76726
2023-08-25 16:48 zufolo441 Status feedback => assigned
2024-09-04 09:41 c_schmitz Summary unable to create tables in MS SQL Server during install => unable to create tables in MS SQL Server during install using dblib
2024-09-04 09:41 c_schmitz Assigned To ollehar => c_schmitz
2026-09-14 16:37 c_schmitz Changeset attached => LimeSurvey master 1eb7eff2
2026-09-14 16:37 c_schmitz Note Added: 85734
2026-09-14 16:37 c_schmitz Status assigned => resolved
2026-09-14 16:37 c_schmitz Resolution open => fixed
2026-09-14 16:37 c_schmitz Bug heat 8 => 10
2026-09-17 13:12 LimeBot Note Added: 85822
2026-09-17 13:12 LimeBot Status resolved => closed
2026-09-17 13:12 LimeBot Bug heat 10 => 12