View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 19110 | Bug reports | Database design | public | 2023-09-25 12:29 | 2024-10-17 20:28 |
| Reporter | zufolo441 | Assigned To | tibor.pacalat | ||
| Priority | none | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 6.2.x | ||||
| Summary | 19110: with MSSQL Lime is unable to activate survey | ||||
| Description | Hi,
I added the declaration at row 376 and it works. | ||||
| Steps To Reproduce | Steps to reproducetry to activate a survey with MSSQL backend. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 24 | ||||
| Complete LimeSurvey version number (& build) | 6.2.9 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox 117.0 | ||||
| Database type & version | Microsoft SQL Server 2012 (SP3-GDR) (KB4019092) - 11.0.6251.0 (X64) | ||||
| Server OS (if known) | Debian 12 | ||||
| Webserver software & version (if known) | nginx+php-fpm | ||||
| PHP Version | 8.2 | ||||
| has duplicate | 19229 | closed | c_schmitz | bug in mssql_drop_coulmn_with_constraints |
| has duplicate | 19566 | closed | tibor.pacalat | Database error when reactivation of deactivated survey |
|
reproduced |
|
|
need to check 5.x |
|
|
does not appear to affect 5.x |
|
|
Duplicate of https://bugs.limesurvey.org/view.php?id=19344 |
|
|
Hi, solution posted in 6.4.3 is partial. there is still an error in activate_helper.php, row 357: CONSTRAINT_NAME must be uppercased: |
|
|
Hi, this bug is still there. Is there some problem to integrate solution I posted here? Many thanks! |
|
|
Just applied another fix |
|
|
Fixed in Release 6.6.3+240909 |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-09-25 12:29 | zufolo441 | New Issue | |
| 2023-10-25 09:38 | mfavetti | Assigned To | => mfavetti |
| 2023-10-25 09:38 | mfavetti | Status | new => assigned |
| 2023-10-25 09:42 | mfavetti | Assigned To | mfavetti => |
| 2023-10-25 09:43 | mfavetti | Assigned To | => mfavetti |
| 2023-10-25 09:45 | mfavetti | Note Added: 77958 | |
| 2023-10-25 09:45 | mfavetti | File Added: LimeSurvey - Google Chrome 2023-10-25 00-44-11-converted.mp4 | |
| 2023-10-25 09:45 | mfavetti | Bug heat | 0 => 2 |
| 2023-10-25 09:45 | mfavetti | Status | assigned => confirmed |
| 2023-10-25 10:27 | mfavetti | Note Added: 77961 | |
| 2023-10-25 10:27 | mfavetti | Note Added: 77962 | |
| 2023-10-25 10:55 | mfavetti | Note Added: 77964 | |
| 2023-10-25 11:21 | mfavetti | Assigned To | mfavetti => DenisChenu |
| 2023-10-25 11:21 | mfavetti | Status | confirmed => ready for code review |
| 2023-10-26 11:47 | DenisChenu | Assigned To | DenisChenu => tibor.pacalat |
| 2023-10-26 11:47 | DenisChenu | Status | ready for code review => ready for testing |
| 2024-01-16 15:39 | tibor.pacalat | Status | ready for testing => resolved |
| 2024-01-16 15:39 | tibor.pacalat | Resolution | open => fixed |
| 2024-01-16 15:39 | tibor.pacalat | Note Added: 79184 | |
| 2024-01-16 15:39 | tibor.pacalat | Bug heat | 2 => 4 |
| 2024-01-25 08:27 | zufolo441 | Note Added: 79309 | |
| 2024-01-25 08:27 | zufolo441 | Bug heat | 4 => 6 |
| 2024-06-21 11:11 | zufolo441 | Note Added: 80410 | |
| 2024-09-03 16:58 | c_schmitz | Changeset attached | => LimeSurvey master 2d2423cb |
| 2024-09-03 16:58 | c_schmitz | Note Added: 80883 | |
| 2024-09-03 16:58 | c_schmitz | Bug heat | 6 => 8 |
| 2024-09-03 17:16 | c_schmitz | Relationship added | has duplicate 19229 |
| 2024-09-03 17:16 | c_schmitz | Bug heat | 8 => 16 |
| 2024-09-09 18:36 | LimeBot | Note Added: 80942 | |
| 2024-09-09 18:36 | LimeBot | Status | resolved => closed |
| 2024-09-09 18:36 | LimeBot | Bug heat | 16 => 18 |
| 2024-10-17 20:28 | c_schmitz | Relationship added | has duplicate 19566 |
| 2024-10-17 20:28 | c_schmitz | Bug heat | 18 => 24 |