View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 08334 | Bug reports | Installation | public | 2013-11-04 17:26 | 2013-11-25 15:39 |
| Reporter | wehr | Assigned To | c_schmitz | ||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.05 RC | ||||
| Target Version | 2.05+ | Fixed in Version | 2.05+ | ||
| Summary | 08334: Fix for create unique index permissions_idx2 ON lime_permissions with PostgreSQL backend | ||||
| Description | I have a git based (2.05 branch) installation which shows an error when installing on a PostgreSQL database. PostgreSQL Version 9.1.9 Undefined column: 7 FEHLER: Spalte »entity_name« existiert nicht' It looks like there is a small bug in the create script "installer/sql/create-pgsql.sql" "entity_name" should be named "entity" according to the "prefix_permissions" table | ||||
| Additional Information | 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[42703]: Undefined column: 7 FEHLER: Spalte »entity_name« existiert nicht' in /var/www/LimeSurvey/framework/db/CDbCommand.php:358 Stack trace: #0 /var/www/LimeSurvey/application/controllers/InstallerController.php(949): CDbCommand->execute() #1 /var/www/LimeSurvey/application/controllers/InstallerController.php(919): InstallerController->executeSQLFile('/var/www/LimeSu...', 'lime') #2 /var/www/LimeSurvey/application/controllers/InstallerController.php(563): InstallerController->_setup_tables('/var/www/LimeSu...') #3 /var/www/LimeSurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/LimeSurvey/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /var/www/LimeSurvey/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /var/www/LimeSurvey/framework/base/CApplication.php(180): CWebApplication->processRequest() #7 /var/www/LimeSurvey/index.php(190): CApplication->run() #8 {main} | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 5c3f4ff37d103a9cbfbb0ca67b9c | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox 25 | ||||
| Database type & version | PostgreSQL 9.1.9 | ||||
| Server OS (if known) | Debian 7.1 | ||||
| Webserver software & version (if known) | Apache 2.2 | ||||
| PHP Version | 5.4.4 | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-11-04 17:26 | wehr | New Issue | |
| 2013-11-04 20:41 | c_schmitz | Assigned To | => c_schmitz |
| 2013-11-04 20:41 | c_schmitz | Status | new => assigned |
| 2013-11-08 09:22 | c_schmitz | Note Added: 27148 | |
| 2013-11-08 09:22 | c_schmitz | Status | assigned => resolved |
| 2013-11-08 09:22 | c_schmitz | Fixed in Version | => 2.05+ |
| 2013-11-08 09:22 | c_schmitz | Resolution | open => fixed |
| 2013-11-08 09:25 | c_schmitz | Changeset attached | => LimeSurvey 2.05 d30338d9 |
| 2013-11-08 09:25 | c_schmitz | Note Added: 27149 | |
| 2013-11-22 11:28 | c_schmitz | Target Version | => 2.05+ |
| 2013-11-25 15:39 | c_schmitz | Note Added: 27385 | |
| 2013-11-25 15:39 | c_schmitz | Status | resolved => closed |
