View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
07144Bug reportsOtherpublic2013-01-09 21:45
ReporterTheLink Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07144: Checking Data Integrity does not work
Description

I'm using postgresql with limesurvey 2.00+ Build 130103. When I click "Check data integrity", I get the following output:

Couldn't make backup of the survey table. Please try again. The database reported the following error:
exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42P01]: Undefined table: 7 FEHLER: Relation »lime_survey« existiert nicht' in /var/www/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/limesurvey/framework/db/CDbCommand.php(1263): CDbCommand->execute() #1 /var/www/limesurvey/application/controllers/admin/checkintegrity.php(369): CDbCommand->renameTable('{{survey}}', '{{old_survey__2...') #2 /var/www/limesurvey/application/controllers/admin/checkintegrity.php(39): CheckIntegrity->_checkintegrity() #3 [internal function]: CheckIntegrity->index() #4 /var/www/limesurvey/framework/web/actions/CAction.php(107): ReflectionMethod->invokeArgs(Object(CheckIntegrity), Array) #5 /var/www/limesurvey/application/core/Survey_Common_Action.php(100): CAction->runWithParamsInternal(Object(CheckIntegrity), Object(ReflectionMethod), Array) #6 /var/www/limesurvey/framework/web/CController.php(309): Survey_Common_Action->runWithParams(Array) #7 /var/www/limesurvey/framework/web/CController.php(287): CController->runAction(Object(CheckIntegrity)) #8 /var/www/limesurvey/framework/web/CController.php(266): CController->runActionWithFilters(Object(CheckIntegrity), Array) #9 /var/www/limesurvey/application/controllers/AdminController.php(169): CController->run('checkintegrity') #10 /var/www/limesurvey/framework/web/CWebApplication.php(276): AdminController->run('checkintegrity') #11 /var/www/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('admin/checkinte...') #12 /var/www/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #13 /var/www/limesurvey/index.php(178): CApplication->run() #14 {main}

Steps To Reproduce

Click "Check data integrity"

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130103
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 8.4.13
Server OS (if known)Debian 64bit
Webserver software & version (if known)Apache 2
PHP Version5.3.3-7+squeeze14 with Suhosin-Patch

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-01-06 13:31

administrator   ~23503

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

c_schmitz

c_schmitz

2013-01-06 13:40

administrator   ~23504

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

c_schmitz

c_schmitz

2013-01-08 22:32

administrator   ~23553

2.00+ Build 130108 released.

c_schmitz

c_schmitz

2013-01-09 21:45

administrator   ~23594

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

Related Changesets

LimeSurvey: master d4526c82

2013-01-06 12:31:40

c_schmitz

Details Diff
Fixed issue 07144: Checking data integrity does not work Affected Issues
07144
mod - application/controllers/admin/checkintegrity.php Diff File

LimeSurvey: 2.1 c2bf35f4

2013-01-06 12:31:40

c_schmitz

Details Diff
Fixed issue 07144: Checking data integrity does not work Affected Issues
07144
mod - application/controllers/admin/checkintegrity.php Diff File

LimeSurvey: master 7e1ff700

2013-01-06 12:40:31

c_schmitz

Details Diff
Fixed issue 07144: Checking data integrity does not work Affected Issues
07144
mod - application/controllers/admin/checkintegrity.php Diff File

Issue History

Date Modified Username Field Change
2013-01-05 23:13 TheLink New Issue
2013-01-06 13:31 c_schmitz Assigned To => c_schmitz
2013-01-06 13:31 c_schmitz Status new => assigned
2013-01-06 13:31 c_schmitz Changeset attached => LimeSurvey master d4526c82
2013-01-06 13:31 c_schmitz Note Added: 23503
2013-01-06 13:31 c_schmitz Resolution open => fixed
2013-01-06 13:32 c_schmitz Status assigned => resolved
2013-01-06 13:32 c_schmitz Fixed in Version => 2.00+
2013-01-06 13:40 c_schmitz Changeset attached => LimeSurvey master 7e1ff700
2013-01-06 13:40 c_schmitz Note Added: 23504
2013-01-08 22:32 c_schmitz Note Added: 23553
2013-01-08 22:32 c_schmitz Status resolved => closed
2013-01-09 21:45 c_schmitz Changeset attached => LimeSurvey 2.1 c2bf35f4
2013-01-09 21:45 c_schmitz Note Added: 23594