View Issue Details

IDProjectCategoryView StatusLast Update
14125Bug reports[All Projects] Installationpublic2019-04-30 09:10
ReporterDenisChenuAssigned ToDenisChenu 
Status closedResolutionfixed 
Product Version3.14.x 
Target VersionFixed in Version3.14.x 
Summary14125: DB user with insufficient right can show white page when installing

With IIS + SQL server : if user have insufficient right (READ/WRITE role, not db_owner) : this broke with a 500 error without any information.

Steps To Reproduce

With mysql/apache : it's better show a 500 with the DB error. Need hacking index.php for IIS

Then with mysql
create "test" DB
create "read' user
GRANT SELECT , INSERT , UPDATE , DELETE , ALTER ON test . * TO 'read'@'localhost';

Launch new install

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.14.11 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database & DB-Versionmysql + mssql (+ surely pgsql with invalid rights)
Server OS (if known)windows (and linux)
Webserver software & version (if known)IIS (but reproductible in apache)
PHP Versionnot releavant (tested in 7.2, reproduce in 5.6)




2018-10-02 17:31


index.php.html (1,661 bytes)


2018-10-03 08:18


Fix committed to master branch:

Related Changesets

LimeSurvey: master 91a5cef6

2018-10-03 08:18:48


Committer: GitHub Details Diff
Fixed issue 14125: DB user with insufficient right can show white page when installing (#1133)

Dev: fix double encoding of arrays of errors
Dev: trace is really not needed (Yii part)
Dev: didn't test with command install : create-database throw CHttpException (didn't update it)
Affected Issues
mod - application/controllers/InstallerController.php Diff File
mod - application/views/installer/dbconfig_view.php Diff File
mod - installer/create-database.php Diff File

Issue History

Date Modified Username Field Change
2018-10-02 17:31 DenisChenu New Issue
2018-10-02 17:31 DenisChenu Status new => assigned
2018-10-02 17:31 DenisChenu Assigned To => DenisChenu
2018-10-02 17:31 DenisChenu File Added: index.php.html
2018-10-03 08:18 user70560 Changeset attached => LimeSurvey master 91a5cef6
2018-10-03 08:18 user70560 Note Added: 49223
2018-10-03 08:18 user70560 Assigned To DenisChenu => user70560
2018-10-03 08:18 user70560 Resolution open => fixed
2018-10-03 08:19 DenisChenu Assigned To user70560 => DenisChenu
2018-10-03 08:19 DenisChenu Status assigned => resolved
2018-10-03 08:19 DenisChenu Fixed in Version => 3.14.x
2019-04-30 09:10 c_schmitz Status resolved => closed