View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
15005 | Bug reports | Central participant database | public | 2019-06-26 16:56 | 2020-03-09 15:34 |
Reporter | visionit | Assigned To | p_teichmann | ||
Priority | none | Severity | block | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.17.x | ||||
Fixed in Version | 3.17.x | ||||
Summary | 15005: Viewing Central Participant database results in error when using Postgres | ||||
Description | When viewing the Central Participant database after creating a Central Participant, the application (with Postgres) crashes with: CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer | ||||
Steps To Reproduce |
| ||||
Additional Information | Reproducable with docker-compose file: https://github.com/martialblog/docker-limesurvey/blob/master/docker-compose.pgsql.yml | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 3.17.5+190604 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Mozilla Firefox 67.0.4 | ||||
Database type & version | postgres (PostgreSQL) 10.9 (Debian 10.9-1.pgdg90+1) | ||||
Server OS (if known) | Debian 9.9 x86_64 4.15.0-52-generic | ||||
Webserver software & version (if known) | Apache 2.4.25-3+deb9u6 | ||||
PHP Version | PHP 7.2.16 (cli) (built: Mar 27 2019 01:46:25) ( NTS ) | ||||
fixed in https://github.com/LimeSurvey/LimeSurvey/commit/6c6f350774974ce6b6bab514c50d54cbded78598 |
|
Awesome! Thanks |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2019-06-26 16:56 | visionit | New Issue | |
2019-07-01 11:08 | ollehar | Assigned To | => p_teichmann |
2019-07-01 11:08 | ollehar | Status | new => assigned |
2019-07-03 14:26 | p_teichmann | Status | assigned => resolved |
2019-07-03 14:26 | p_teichmann | Resolution | open => fixed |
2019-07-03 14:26 | p_teichmann | Fixed in Version | => 3.17.x |
2019-07-03 14:26 | p_teichmann | Note Added: 52690 | |
2019-07-04 17:14 | visionit | Note Added: 52736 | |
2020-03-09 15:34 | c_schmitz | Status | resolved => closed |