View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
04734Bug reportsInstallationpublic2010-11-11 16:162010-11-17 01:03
Reporteruser10628Assigned Toc_schmitz  
PrioritylowSeverityminor 
Status closedResolutionfixed 
Product Version1.90+ 
Fixed in Version1.90+ 
Summary04734: Integrity Check fails on PostgreSQL
Description

When running 1.90+ on PostgreSQL, the Data Integrity Check will just produce "Couldn't get list of conditions from database" along with the SQL Error.

This is caused because PostgreSQL doesn't know the "SHOW TABLES"

Steps To Reproduce

Install LimeSurvey on PostgreSQL and try running the data integrity check.

TagsNo tags attached.
Bug heat10
Complete LimeSurvey version number (& build)9459
I will donate to the project if issue is resolvedNo
BrowserFirefox 4b6
Database type & versionPostgreSQL 8.4.2
Server OS (if known)Gentoo 4.3.4p1.0
Webserver software & version (if known)Apache2
PHP Version5.3.3-pl1-gentoo

Relationships

Relationship GraphDependency Graph
has duplicate 04738 closedc_schmitz Database check returns SQL error on MSSQL 

Users monitoring this issue

There are no users monitoring this issue.

Activities

user10628

2010-11-11 16:21

  ~13503

Solution#1 (works for me):
In the file admin/integritycheck.php change the two occurences of '$sQuery = "show tables like...' to conditionally set

$sQuery = "select * from information_schema.tables where tableschema like '{$dbprefix}survey\%' and table_type='BASE TABLE'";

AND (further down)

$sQuery = "select * from information_schema.tables where tableschema like '{$dbprefix}tokens\%' and table_type='BASE TABLE'";

whenever the database type is set to strtolower('postgresql') in config.
c_schmitz

c_schmitz

2010-11-12 23:38

administrator   ~13515

Fixed in rev. 9477
c_schmitz

c_schmitz

2010-11-17 01:03

administrator   ~13542

Fix released in latest 1.90+ version.

Issue History

Date Modified Username Field Change
2010-11-11 16:16 user10628 New Issue
2010-11-11 16:21 user10628 Note Added: 13503
2010-11-12 01:56 c_schmitz Priority high => low
2010-11-12 22:32 c_schmitz Assigned To => c_schmitz
2010-11-12 22:32 c_schmitz Status new => assigned
2010-11-12 23:38 c_schmitz Note Added: 13515
2010-11-12 23:38 c_schmitz Status assigned => resolved
2010-11-12 23:38 c_schmitz Fixed in Version => 1.90+
2010-11-12 23:38 c_schmitz Resolution open => fixed
2010-11-14 18:24 c_schmitz Relationship added has duplicate 04738
2010-11-17 01:03 c_schmitz Note Added: 13542
2010-11-17 01:03 c_schmitz Status resolved => closed