View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
19578Bug reportsPluginspublic2024-05-31 14:522024-09-09 18:36
ReporterDenisChenu Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version5.6.x 
Summary19578: After upgrade to 5 or 6 with MSSQL : no way to access to plugin configuration.
Description

When upgrading with user plugin : no plugin have configuration

Steps To Reproduce

Steps to reproduce

Have a LS3 with plugin on MS SQL
Example with https://forums.limesurvey.org/forum/plugins/114050-plugin-addscripttoquestion-more-easy-to-javascript-to-question
Upgrade to 5
Test plugin : it work
Try to configure or access to information :

Expected result

See version and plugin configuration access

Actual result

Error : could not get plugin description : unknow tipe NULL

TagsNo tags attached.
Attached Files
image001.png (20,568 bytes)   
image001.png (20,568 bytes)   
Bug heat6
Complete LimeSurvey version number (& build) 5.6.59 or 6.5.9
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmssql
Server OS (if known)windows
Webserver software & version (if known)IIS
PHP Version8.0

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2024-05-31 14:54

developer   ~80184

It's related to DEFAULT value : https://github.com/LimeSurvey/LimeSurvey/blob/5631f3db2b0fea4cf33ce387c243edd5259ec10f/application/helpers/update/updates/Update_402.php#L11

string(6) default 'user' or string(6) NULL default 'user' didn't work, table didn't have default value.
c_schmitz

c_schmitz

2024-09-03 17:13

administrator   ~80884

NULL & DEFAULT always need to be uppercase to work with all DB types-
c_schmitz

c_schmitz

2024-09-03 17:27

administrator   ~80886

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

c_schmitz

2024-09-03 18:02

administrator   ~80888

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

LimeBot

2024-09-09 18:36

administrator   ~80939

Fixed in Release 6.6.3+240909

Related Changesets

LimeSurvey: master 82b705ef

2024-09-03 17:07:58

c_schmitz

Details Diff 		Fixed issue 19578: After upgrading to 5 or 6 with MSSQL no way to access to plugin configuration Affected Issues
19578
mod - application/helpers/update/updates/Update_401.php Diff File
mod - application/helpers/update/updates/Update_402.php Diff File
mod - application/helpers/update/updates/Update_406.php Diff File
mod - application/helpers/update/updates/Update_410.php Diff File
mod - application/helpers/update/updates/Update_411.php Diff File
mod - application/helpers/update/updates/Update_426.php Diff File
mod - application/helpers/update/updates/Update_488.php Diff File

LimeSurvey: master 716f870b

2024-09-03 17:27:07

c_schmitz

Details Diff 		Fixed issue 19578: After upgrading to 5 or 6 with MSSQL no way to access to plugin configuration
Dev DEFAULT & NULL field definition keywords need to be uppercase for MSSQL driver compatibility		 Affected Issues
19578
mod - installer/create-database.php Diff File

LimeSurvey: master 1f7450e3

2024-09-03 17:48:07

c_schmitz

Details Diff 		Fixed issue 19578: After upgrading to 5 or 6 with MSSQL no way to access to plugin configuration
Dev DEFAULT & NULL field definition keywords need to be uppercase for MSSQL driver compatibility		 Affected Issues
19578
mod - application/helpers/update/updatedb_helper.php Diff File
mod - application/helpers/update/updates/Update_133.php Diff File
mod - application/helpers/update/updates/Update_134.php Diff File
mod - application/helpers/update/updates/Update_136.php Diff File
mod - application/helpers/update/updates/Update_137.php Diff File
mod - application/helpers/update/updates/Update_141.php Diff File
mod - application/helpers/update/updates/Update_143.php Diff File
mod - application/helpers/update/updates/Update_145.php Diff File
mod - application/helpers/update/updates/Update_147.php Diff File
mod - application/helpers/update/updates/Update_148.php Diff File
mod - application/helpers/update/updates/Update_151.php Diff File
mod - application/helpers/update/updates/Update_156.php Diff File
mod - application/helpers/update/updates/Update_161.php Diff File
mod - application/helpers/update/updates/Update_169.php Diff File
mod - application/helpers/update/updates/Update_259.php Diff File
mod - application/helpers/update/updates/Update_307.php Diff File
mod - application/helpers/update/updates/Update_400.php Diff File
mod - application/helpers/update/updates/Update_407.php Diff File
mod - application/helpers/update/updates/Update_426.php Diff File
mod - application/helpers/update/updates/Update_480.php Diff File

Issue History

Date Modified Username Field Change
2024-05-31 14:52 DenisChenu New Issue
2024-05-31 14:52 DenisChenu File Added: image001.png
2024-05-31 14:54 DenisChenu Note Added: 80184
2024-05-31 14:54 DenisChenu Bug heat 0 => 2
2024-09-03 17:09 c_schmitz Assigned To => c_schmitz
2024-09-03 17:09 c_schmitz Status new => resolved
2024-09-03 17:09 c_schmitz Resolution open => fixed
2024-09-03 17:12 c_schmitz Changeset attached => LimeSurvey master 82b705ef
2024-09-03 17:13 c_schmitz Note Added: 80884
2024-09-03 17:13 c_schmitz Bug heat 2 => 4
2024-09-03 17:27 c_schmitz Changeset attached => LimeSurvey master 716f870b
2024-09-03 17:27 c_schmitz Note Added: 80886
2024-09-03 18:02 c_schmitz Changeset attached => LimeSurvey master 1f7450e3
2024-09-03 18:02 c_schmitz Note Added: 80888
2024-09-09 18:36 LimeBot Note Added: 80939
2024-09-09 18:36 LimeBot Status resolved => closed
2024-09-09 18:36 LimeBot Bug heat 4 => 6