12784: Pgsql : unable to install on same DB with another prefix

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

12784	Bug reports	Installation	public	2017-10-13 08:19	2017-10-25 11:12

Reporter	DenisChenu	Assigned To	c_schmitz
Priority	none	Severity	minor
Status	closed	Resolution	fixed
Product Version	2.7x.x
Fixed in Version	3.0.0-beta.x

Summary	12784: Pgsql : unable to install on same DB with another prefix
Description	When install with another prefix : duplicate relation (see html file with error)
Steps To Reproduce	Install on pgsql with lime prefix. Remove config.php Install on pgsql with lime2 or ls_ prefix
Additional Information	Think we must add prefix too for relation
Tags	No tags attached.
Attached Files	PGSQL_InstallError.html (34,735 bytes) <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <meta name="author" content=""> <link rel="shortcut icon" href="http://lspg.sondages.pro/styles/admin/favicon.ico" type="image/x-icon"> <link rel="icon" href="http://lspg.sondages.pro/index.phpstyles/admin/favicon.ico" type="image/x-icon"> <link rel="icon" href="http://lspg.sondages.pro/images/favicon.ico"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" type="text/css" href="PGSQL_InstallError_fichiers/font-awesome.css"> <link rel="stylesheet" type="text/css" href="PGSQL_InstallError_fichiers/bootstrap.css" media="screen"> <link rel="stylesheet" type="text/css" href="PGSQL_InstallError_fichiers/yiistrap.css" media="screen"> <link rel="stylesheet" type="text/css" href="PGSQL_InstallError_fichiers/lime-admin-colors.css"> <link rel="stylesheet" type="text/css" href="PGSQL_InstallError_fichiers/lime-admin-common.css"> <link rel="stylesheet" type="text/css" href="PGSQL_InstallError_fichiers/main.css"> <link rel="stylesheet" type="text/css" href="PGSQL_InstallError_fichiers/fonts.css"> <script type="text/javascript" src="PGSQL_InstallError_fichiers/jquery-2.js"></script> <script type="text/javascript" src="PGSQL_InstallError_fichiers/jquery-ui-1.js"></script> <title>Installation de LimeSurvey</title> </head> <body> <div class="container"> <div class="row"><div class="span12"> <h1>Installation de LimeSurvey</h1> </div></div> <div class="row"> <div class="col-md-3"> <h2 class="maintitle">Progression</h2> <p>40% complétés</p> <div class="progress progress-striped active"><div class="progress-bar" style="width: 40%"></div></div><ol> <li class="off"> Bienvenue </li> <li class="off"> Licence </li> <li class="off"> Contrôle pré-installation </li> <li class="on" style="color: rgb(11, 85, 196);"> Configuration </li> <li class="off"> Paramètres de la base de données </li> <li class="off"> Paramètres optionnels </li> </ol> </div> <div class="col-md-9"> <form class="form-horizontal" action="/index.php?r=installer/database" method="post"> <input value="RlBvb0pTTzdfXzVuVVNNdGduVFpsbEQwd0ZVOVM0bHqbJUGi60awChoM4kWG38TxmJgotz2qrlbR_OYaXZ7O9g==" name="YII_CSRF_TOKEN" type="hidden"> <h2>Paramètres de la base de données</h2> <p>Veuillez entre les paramètres de la base de données que vous souhaitez utiliser pour LimeSurvey :</p> <div class="alert alert-danger"> <div class="errors"><p>Veuillez corriger les erreurs de saisie:</p> <ul> <li>Des erreurs sont survenues en tentant de remplir la base de données : <p></p><ul><li>Executing: create index answers_idx2 on lime2_answers (sortorder); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « answers_idx2 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index assessments_idx2 on lime2_assessments (sid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « assessments_idx2 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index assessments_idx3 on lime2_assessments (gid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « assessments_idx3 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index conditions_idx2 on lime2_conditions (qid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « conditions_idx2 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index conditions_idx3 on lime2_conditions (cqid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « conditions_idx3 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index groups_idx2 on lime2_groups (sid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « groups_idx2 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index question_attributes_idx2 on lime2_question_attributes (qid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « question_attributes_idx2 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index question_attributes_idx3 on lime2_question_attributes (attribute); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « question_attributes_idx3 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index questions_idx2 on lime2_questions (sid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « questions_idx2 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index questions_idx3 on lime2_questions (gid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « questions_idx3 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index questions_idx4 on lime2_questions (type); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « questions_idx4 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index quota_idx2 on lime2_quota (sid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « quota_idx2 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index saved_control_idx2 on lime2_saved_control (sid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « saved_control_idx2 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index parent_qid_idx on lime2_questions (parent_qid); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « parent_qid_idx » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create index labels_code_idx on lime2_labels (code); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « labels_code_idx » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: create unique index permissions_idx2 ON lime2_permissions (entity_id, entity, uid, permission); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « permissions_idx2 » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li><li>Executing: CREATE INDEX notif_hash_index ON lime2_notifications USING btree (hash); failed! Reason: exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42P07]: Duplicate table: 7 ERREUR: la relation « notif_hash_index » existe déjà' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/db/CDbCommand.php:358 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(999): CDbCommand->execute() #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(969): InstallerController->_executeSQLFile('/home/sondages....', 'lime2_') #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/sondages....') #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/framework/base/CApplication.php(185): CWebApplication->processRequest() #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/index.php(214): CApplication->run() #8 {main}</li></ul></li> </ul></div> </div> <p>Note : les champs marqués d'une astérisque () sont obligatoires.</p> <legend>Paramètres de la base de données</legend> <div class="form-group"><label class="control-label col-sm-2 required" for="InstallerConfigForm_dbtype">Type de base de données <span class="required"></span></label><div class="controls col-sm-8"><select required="required" class="form-control" autofocus="autofocus" name="InstallerConfigForm[dbtype]" id="InstallerConfigForm_dbtype"> <option value="mysql" selected="selected">MySQL</option> <option value="pgsql">PostgreSQL</option> </select><p class="help-block">Type de votre système de gestion de base de données</p></div></div><div class="form-group"><label class="control-label col-sm-2 error required" for="InstallerConfigForm_dblocation">Emplacement de la base de données <span class="required"></span></label><div class="controls col-sm-8"><input required="required" class="form-control error" name="InstallerConfigForm[dblocation]" id="InstallerConfigForm_dblocation" value="localhost" type="text"><p class="help-block">Paramètre d'accès au serveur de la base de données. Dans la plupart des cas, "localhost" convient. Vous pouvez utiliser une adresse IP, une adresse internet ou le chemin du nœud Unix. Si votre base de données utilise un port personnalisé, indiquez-le en utilisant deux-points. Exemple : db.host.com:5431</p></div></div><div class="form-group"><label class="control-label col-sm-2 error required" for="InstallerConfigForm_dbuser">Utilisateur de la base de données <span class="required"></span></label><div class="controls col-sm-8"><input required="required" autocomplete="off" class="form-control error" name="InstallerConfigForm[dbuser]" id="InstallerConfigForm_dbuser" type="text"><p class="help-block">Le nom d'utilisateur pour votre serveur de base de données.Dans la plupart des cas, "root" convient.</p></div></div><div class="form-group"><label class="control-label col-sm-2 error" for="InstallerConfigForm_dbpwd">Mot de passe de la base de données</label><div class="controls col-sm-8"><input autocomplete="off" class="form-control error" name="InstallerConfigForm[dbpwd]" id="InstallerConfigForm_dbpwd" type="password"><p class="help-block">Le mot de passe au serveur de base de données.</p></div></div><div class="form-group"><label class="control-label col-sm-2 required" for="InstallerConfigForm_dbname">Nom de la base de données <span class="required"></span></label><div class="controls col-sm-8"><input required="required" autocomplete="off" class="form-control" name="InstallerConfigForm[dbname]" id="InstallerConfigForm_dbname" type="text"><p class="help-block">La base de données sera créée si elle n’existe pas encore (vérifiez que l’utilisateur de votre base de données a les permissions nécessaires). Par contre, s’il existe déjà des tables LimeSurvey dans la base de données, elles seront automatiquement mises à jour après l’installation.</p></div></div><div class="form-group"><label class="control-label col-sm-2" for="InstallerConfigForm_dbprefix">Préfixe des tables</label><div class="controls col-sm-8"><input value="lime_" autocomplete="off" class="form-control" name="InstallerConfigForm[dbprefix]" id="InstallerConfigForm_dbprefix" type="text"><p class="help-block">Si votre base de données est partagée, il est recommandé d'utiliser le préfixe de tables "lime_". Sinon vous pouvez laisser de champ vide.</p></div></div> <br> <div class="row"> <div class="col-md-4"> <input class="btn btn-default" value="Précédent" onclick="javascript: window.open('/index.php?r=installer/precheck', '_top')" type="button"> </div> <div class="col-md-4" style="text-align: center;"> </div> <div class="col-md-4" style="text-align: right;"> <input class="btn btn-default" name="yt0" value="Suivant" type="submit"> </div> </div> </form> </div> </div> <div class="row" style="margin-top: 30px;"> <div class="span12" style="text-align: center;"> <img src="PGSQL_InstallError_fichiers/poweredby.png" alt="Powered by LimeSurvey"> </div> </div> </div> <script type="text/javascript" src="PGSQL_InstallError_fichiers/bootstrap.js"></script> <script type="text/javascript"> /<![CDATA[/ jQuery('body').popover({'selector':'a\x5Brel\x3Dpopover\x5D'}); jQuery('body').tooltip({'selector':'a\x5Brel\x3Dtooltip\x5D'}); jQuery(function($) { $(function() { $('.on').animate({ color: '#0B55C4' }, 1000 ); $('.demo').find('a:first').button().end(). find('a:eq(1)').button().end(). find('a:eq(2)').button(); }); }); /]]>*/ </script> </body></html> PGSQL_InstallError.html (34,735 bytes)

Bug heat	4
Complete LimeSurvey version number (& build)	20171013
I will donate to the project if issue is resolved	No
Browser	not relevant
Database type & version	9.1.24lts2
Server OS (if known)	debian
Webserver software & version (if known)	apache
PHP Version	PHP5.6

User List	There are no users monitoring this issue.

DenisChenu 2017-10-13 08:23 developer ~44642	There are some issue with value in the form : prefix is never keep with this error : all form are resetted

c_schmitz 2017-10-19 10:22 administrator ~44728	Fix committed to develop branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=24178

c_schmitz 2017-10-25 11:12 administrator ~44825	3.0.0-RC1 Build 171025 released

LimeSurvey: develop a3e111f4 2017-10-19 10:22:34 c_schmitz Details Diff	Fixed issue 12784: Unable to install on same DB with another prefix when using Postgres	Affected Issues 12784
	mod - application/helpers/update/updatedb_helper.php	Diff File
	mod - installer/php/create-database.php	Diff File

Date Modified	Username	Field	Change
2017-10-13 08:19	DenisChenu	New Issue
2017-10-13 08:19	DenisChenu	File Added: PGSQL_InstallError.html
2017-10-13 08:23	DenisChenu	Note Added: 44642
2017-10-19 10:22	c_schmitz	Assigned To	=> c_schmitz
2017-10-19 10:22	c_schmitz	Status	new => assigned
2017-10-19 10:22	c_schmitz	Changeset attached	=> LimeSurvey develop a3e111f4
2017-10-19 10:22	c_schmitz	Note Added: 44728
2017-10-19 10:22	c_schmitz	Resolution	open => fixed
2017-10-19 10:23	c_schmitz	Status	assigned => resolved
2017-10-19 10:23	c_schmitz	Fixed in Version	=> 3.0.0-beta.x
2017-10-25 11:12	c_schmitz	Note Added: 44825
2017-10-25 11:12	c_schmitz	Status	resolved => closed

View Issue Details

Users monitoring this issue

Activities

Related Changesets

Issue History