View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
07990Bug reportsInstallationpublic2013-10-23 14:40
Reporterjjxice46 Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.05 RC 
Fixed in Version2.05 RC 
Summary07990: Error when installing limesurvey
Description

When trying to install limesurvey build 2.05 130702 you receive the following error after selecting populate database

Database was populated but there were errors:
•Executing: CREATE TABLE [lime_plugins] ([id] int(11) NOT NULL identity(1,1),[name] varchar(50) NOT NULL,[active] int(1) NOT NULL default '0',PRIMARY KEY (id)); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ''.' in C:\inetpub\wwwroot\limesurvey\framework\db\CDbCommand.php:357 Stack trace: #0 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(947): CDbCommand->execute() #1 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(917): InstallerController->_executeSQLFile('C:\inetpub\wwwr...', 'lime_') #2 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(561): InstallerController->_setup_tables('C:\inetpub\wwwr...') #3 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(78): InstallerController->stepPopulateDb() #4 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(282): InstallerController->run('populatedb') #5 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 C:\inetpub\wwwroot\limesurvey\framework\base\CApplication.php(169): CWebApplication->processRequest() #7 C:\inetpub\wwwroot\limesurvey\index.php(190): CApplication->run() #8 {main} •Executing: CREATE TABLE [lime_plugin_settings] ([id] int(11) NOT NULL IDENTITY(1,1),[plugin_id] int(11) NOT NULL,[model] varchar(50) NULL,[model_id] int(11) NULL,[key] varchar(50) NOT NULL,[value] text NULL,PRIMARY KEY (id),); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ''.' in C:\inetpub\wwwroot\limesurvey\framework\db\CDbCommand.php:357 Stack trace: #0 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(947): CDbCommand->execute() #1 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(917): InstallerController->executeSQLFile('C:\inetpub\wwwr...', 'lime') #2 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(561): InstallerController->_setup_tables('C:\inetpub\wwwr...') #3 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(78): InstallerController->stepPopulateDb() #4 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(282): InstallerController->run('populatedb') #5 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 C:\inetpub\wwwroot\limesurvey\framework\base\CApplication.php(169): CWebApplication->processRequest() #7 C:\inetpub\wwwroot\limesurvey\index.php(190): CApplication->run() #8 {main}
•Executing: CREATE TABLE [lime_survey_links] ([participant_id] varchar(50) NOT NULL,[token_id] int NOT NULL,[survey_id] int NOT NULL,[date_created] datetime,[date_invited] datetime,[date_completed] datetimePRIMARY KEY ([participant_id],[token_id],[survey_id])); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'KEY'.' in C:\inetpub\wwwroot\limesurvey\framework\db\CDbCommand.php:357 Stack trace: #0 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(947): CDbCommand->execute() #1 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(917): InstallerController->executeSQLFile('C:\inetpub\wwwr...', 'lime') #2 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(561): InstallerController->_setup_tables('C:\inetpub\wwwr...') #3 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(78): InstallerController->stepPopulateDb() #4 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(282): InstallerController->run('populatedb') #5 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 C:\inetpub\wwwroot\limesurvey\framework\base\CApplication.php(169): CWebApplication->processRequest() #7 C:\inetpub\wwwroot\limesurvey\index.php(190): CApplication->run() #8 {main}
•Executing: create unique index [permissions_idx2] ON [lime_permissions] ([entity_id], [entity_name], [uid], [permission]); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Column name 'entity_name' does not exist in the target table or view.' in C:\inetpub\wwwroot\limesurvey\framework\db\CDbCommand.php:357 Stack trace: #0 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(947): CDbCommand->execute() #1 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(917): InstallerController->executeSQLFile('C:\inetpub\wwwr...', 'lime') #2 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(561): InstallerController->_setup_tables('C:\inetpub\wwwr...') #3 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(78): InstallerController->stepPopulateDb() #4 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(282): InstallerController->run('populatedb') #5 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 C:\inetpub\wwwroot\limesurvey\framework\base\CApplication.php(169): CWebApplication->processRequest() #7 C:\inetpub\wwwroot\limesurvey\index.php(190): CApplication->run() #8 {main}

So far this issue happens if you attempt to have limesurvey make a database in sql or if you make a blank database in sql server before hand

Steps To Reproduce

attempt to install limesurvey on fresh windows server 2012 with SQL Server 2012 running
after you get to the step that asks about populating database your receive the error

Additional Information

This happens so far only on SQL Server 2012 when on Windows Server 2012

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130702
I will donate to the project if issue is resolvedNo
Browser
Database type & versionSQL Server 2012
Server OS (if known)Windows Server 2012
Webserver software & version (if known)Windows Server 2012
PHP Version5.3.24

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-10-11 12:04

administrator   ~26712

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

c_schmitz

c_schmitz

2013-10-23 14:40

administrator   ~26958

2.05RC3 released.

Related Changesets

LimeSurvey: 2.05 2501cc02

2013-10-11 10:03:52

c_schmitz

Details Diff
Fixed issue 07990: Blocking error when installing on MSSQL Affected Issues
07990
mod - application/models/LSActiveRecord.php Diff File
mod - installer/sql/create-mssql.sql Diff File

Issue History

Date Modified Username Field Change
2013-07-09 19:02 jjxice46 New Issue
2013-07-10 16:35 jjxice46 Issue Monitored: jjxice46
2013-10-11 11:55 c_schmitz Assigned To => c_schmitz
2013-10-11 11:55 c_schmitz Status new => assigned
2013-10-11 12:04 c_schmitz Changeset attached => LimeSurvey 2.05 2501cc02
2013-10-11 12:04 c_schmitz Note Added: 26712
2013-10-11 12:04 c_schmitz Resolution open => fixed
2013-10-11 12:04 c_schmitz Status assigned => resolved
2013-10-11 12:04 c_schmitz Fixed in Version => 2.05 RC
2013-10-11 12:04 c_schmitz Issue End Monitor: jjxice46
2013-10-23 14:40 c_schmitz Note Added: 26958
2013-10-23 14:40 c_schmitz Status resolved => closed