View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
07831Bug reportsInstallationpublic2013-06-13 12:35
Reporterde_chris Assigned Toc_schmitz  
PriorityhighSeverityblock 
Status closedResolutionfixed 
Fixed in Version2.05 RC 
Summary07831: SQL error while installation
Description
Executing: CREATE TABLE lime_permissions ( id serial NOT NULL, entity varying(50) NOT NULL, entity_id varying(100) NOT NULL, uid integer NOT NULL, permission character varying(100) NOT NULL, create_p integer DEFAULT 0 NOT NULL, read_p integer DEFAULT 0 NOT NULL, update_p integer DEFAULT 0 NOT NULL, delete_p integer DEFAULT 0 NOT NULL, import_p integer DEFAULT 0 NOT NULL, export_p integer DEFAULT 0 NOT NULL, CONSTRAINT lime_permissions_pkey PRIMARY KEY (id)); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42704]: Undefined object: 7 ERROR: type "varying" does not exist LINE 1: ... lime_permissions ( id serial NOT NULL, entity varying(50... ^' in /var/www/repro/check/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/repro/check/application/controllers/InstallerController.php(947): CDbCommand->execute() #1 /var/www/repro/check/application/controllers/InstallerController.php(917): InstallerController->_executeSQLFile('/var/www/repro/...', 'lime_') #2 /var/www/repro/check/application/controllers/InstallerController.php(561): InstallerController->_setup_tables('/var/www/repro/...') #3 /var/www/repro/check/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/repro/check/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/repro/check/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/repro/check/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/repro/check/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[42P01]: Undefined table: 7 ERROR: relation "lime_permissions" does not exist' in /var/www/repro/check/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/repro/check/application/controllers/InstallerController.php(947): CDbCommand->execute() #1 /var/www/repro/check/application/controllers/InstallerController.php(917): InstallerController->_executeSQLFile('/var/www/repro/...', 'lime_') #2 /var/www/repro/check/application/controllers/InstallerController.php(561): InstallerController->_setup_tables('/var/www/repro/...') #3 /var/www/repro/check/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/repro/check/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/repro/check/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/repro/check/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/repro/check/index.php(190): CApplication->run() #8 {main}
Steps To Reproduce

Install Limesurvey on Postgresql9

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130420
I will donate to the project if issue is resolvedNo
BrowserFirefox 20
Database type & versionPostgresql 9
Server OS (if known)Ubuntu
Webserver software & version (if known)Apache
PHP Version5

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-05-13 14:43

administrator   ~25234

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

Related Changesets

LimeSurvey: 2.05 6b95c67c

2013-05-13 12:43:55

c_schmitz

Details Diff
Fixed issue 07831: SQL error while installation and using Postgres Affected Issues
07831
mod - installer/sql/create-pgsql.sql Diff File

Issue History

Date Modified Username Field Change
2013-05-13 09:55 de_chris New Issue
2013-05-13 14:43 c_schmitz Assigned To => c_schmitz
2013-05-13 14:43 c_schmitz Status new => assigned
2013-05-13 14:43 c_schmitz Changeset attached => LimeSurvey 2.05 6b95c67c
2013-05-13 14:43 c_schmitz Note Added: 25234
2013-05-13 14:43 c_schmitz Resolution open => fixed
2013-05-14 14:39 c_schmitz Status assigned => resolved
2013-05-14 14:39 c_schmitz Fixed in Version => 2.05 RC
2013-06-13 12:35 c_schmitz Status resolved => closed