View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
08518Bug reportsInstallationpublic2014-01-08 15:532014-01-16 16:45
Reporteri_meyer Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08518: Error during fresh installation on PostgreSQL-Backend "Undefined table 'lime_permissions'"
Description

Error occuring during installation and choosing NO praefix for tablenames:

Executing: create unique index permissions_idx2 ON lime_permissions (entity_id, entity, 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/limesurvey205-build131219/framework/db/CDbCommand.php:358
Stack trace:
#0 /var/www/limesurvey205-build131219/application/controllers/InstallerController.php(949): CDbCommand->execute()
#1 /var/www/limesurvey205-build131219/application/controllers/InstallerController.php(919): InstallerController->_executeSQLFile('/var/www/limesu...', '')
#2 /var/www/limesurvey205-build131219/application/controllers/InstallerController.php(563): InstallerController->_setup_tables('/var/www/limesu...')
#3 /var/www/limesurvey205-build131219/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb()
#4 /var/www/limesurvey205-build131219/framework/web/CWebApplication.php(282): InstallerController->run('populatedb')
#5 /var/www/limesurvey205-build131219/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...')
#6 /var/www/limesurvey205-build131219/framework/base/CApplication.php(180): CWebApplication->processRequest()
#7 /var/www/limesurvey205-build131219/index.php(190): CApplication->run()
#8 {main}

Steps To Reproduce

Start a new installation on an already (but empty) PostgreSQL-database with choosing no praefix for tablenames (instead of "lime_").

Additional Information

With leaving the default "lime_" it works.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)131219
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionPostgreSQL 9.1
Server OS (if known)Ubuntu-Linux
Webserver software & version (if known)Apache 2
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-01-09 23:30

administrator   ~27797

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

c_schmitz

2014-01-16 16:45

administrator   ~27918

2.05+ Build 140116 released

Related Changesets

LimeSurvey: master 5266d862

2014-01-09 22:30:20

c_schmitz

Details Diff 		Fixed issue 08518: Error during fresh installation on PostgreSQL/MSSQL and using a non-default table prefix Affected Issues
08518
mod - installer/sql/create-mssql.sql Diff File
mod - installer/sql/create-pgsql.sql Diff File

Issue History

Date Modified Username Field Change
2014-01-08 15:53 i_meyer New Issue
2014-01-09 23:28 c_schmitz Assigned To => c_schmitz
2014-01-09 23:28 c_schmitz Status new => assigned
2014-01-09 23:30 c_schmitz Status assigned => resolved
2014-01-09 23:30 c_schmitz Fixed in Version => 2.05+
2014-01-09 23:30 c_schmitz Resolution open => fixed
2014-01-09 23:30 c_schmitz Changeset attached => LimeSurvey master 5266d862
2014-01-09 23:30 c_schmitz Note Added: 27797
2014-01-16 16:45 c_schmitz Note Added: 27918
2014-01-16 16:45 c_schmitz Status resolved => closed