View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
17249 | Bug reports | Database design | public | 2021-04-15 15:20 | 2021-04-15 15:58 |
Reporter | ollehar | Assigned To | ollehar | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | no change required | ||
Target Version | 4.x.0-dev | ||||
Summary | 17249: Never use the boolean database type | ||||
Description | They are implemented differently in MySQL and Postgres. Leads to troubles. Two left in create-database.php: installer/create-database.php: 'alwaysavailable' => "boolean NULL", | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | latest master | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | - | ||||
Database type & version | - | ||||
Server OS (if known) | - | ||||
Webserver software & version (if known) | - | ||||
PHP Version | - | ||||
Why you say it didn't woirk ? I check alwaysavailable with pgsql i made test on mariadb and pgsql. |
|
And if you want to update to another type : |
|
Well, it's a character "t" or "f" in Postgres, so compare would be wrong. |
|
Validation for question theme:
Fails. |
|
alwaysavailable system work without issue with pgsql :/ tracevar($model->getAttributes()); |
|
|
|
Let me check... |
|
core_theme = true |
|
OK, so maybe enough to remove the validation rule for question attribute model? |
|
What is the validation ? I use boolean for SurveysGroup model. |
|
array('owner_id, core_theme', 'numerical', 'integerOnly' => true), This is the validation. Testing with removing it. |
|
array('core_theme', 'boolan'), If you use a boolean : it muts be a boolean : i don't see issue here … |
|
Right. |
|
Sorry for the noise. :| |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2021-04-15 15:20 | ollehar | New Issue | |
2021-04-15 15:21 | ollehar | Description Updated | |
2021-04-15 15:34 | DenisChenu | Note Added: 63961 | |
2021-04-15 15:35 | DenisChenu | Note Added: 63962 | |
2021-04-15 15:35 | ollehar | Note Added: 63963 | |
2021-04-15 15:37 | ollehar | Note Added: 63964 | |
2021-04-15 15:40 | DenisChenu | Note Added: 63965 | |
2021-04-15 15:40 | DenisChenu | File Added: Capture d’écran_2021-03-30_09-14-09.png | |
2021-04-15 15:40 | DenisChenu | File Added: Capture d’écran_2021-03-30_08-20-37.png | |
2021-04-15 15:40 | DenisChenu | File Deleted: Capture d’écran_2021-03-30_09-14-09.png | |
2021-04-15 15:40 | DenisChenu | File Deleted: Capture d’écran_2021-03-30_08-20-37.png | |
2021-04-15 15:40 | DenisChenu | Note Added: 63966 | |
2021-04-15 15:40 | DenisChenu | File Added: Capture d’écran_2021-04-15_15-39-36.png | |
2021-04-15 15:40 | DenisChenu | File Added: Capture d’écran_2021-04-15_15-39-54.png | |
2021-04-15 15:41 | ollehar | Note Added: 63967 | |
2021-04-15 15:43 | ollehar | Note Added: 63968 | |
2021-04-15 15:43 | ollehar | Note Edited: 63968 | |
2021-04-15 15:43 | ollehar | Note Added: 63969 | |
2021-04-15 15:45 | DenisChenu | Note Added: 63970 | |
2021-04-15 15:45 | ollehar | Note Added: 63971 | |
2021-04-15 15:46 | DenisChenu | Note Added: 63972 | |
2021-04-15 15:48 | ollehar | Note Added: 63973 | |
2021-04-15 15:58 | ollehar | Assigned To | => ollehar |
2021-04-15 15:58 | ollehar | Status | new => closed |
2021-04-15 15:58 | ollehar | Resolution | open => no change required |
2021-04-15 15:58 | ollehar | Note Added: 63974 |