| 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 |
|---|
