View Issue Details

This bug affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
19554Bug reportsInstallationpublic2024-05-05 22:57
Reporterriqcles Assigned To 
PrioritynoneSeveritycrash 
Status newResolutionopen 
Product Version6.5.x 
Summary19554: Plugins - impossible to integrate plugins after migration
Description

Hi there, I noticed that I cannot install plugins after migrating from version 3.22 to 6.5.4

SQL : SQlstate [23502] : Not null violation : 7 ERROR : null value in column "active" of relation "lime_plugins" vilates not-null constraint

DETAIL: Failing row contains (8, statFonctions, null, 0.2.1, null, null, core, 0).

The following command needs to be executed: ALTER TABLE public.lime_plugins ALTER COLUMN active SET DEFAULT 0; However, this fails due to the NOT NULL constraint on the active column and the lack of a default value.

Link in French : https://forums.limesurvey.org/forum/french-forum/154570-plugins-migration-v3-22-6-5-4-et-plus#263253

Denis Chenu say :
the error comes from further away :

github.com/LimeSurvey/LimeSurvey/blob/62...s/Update_175.php#L12
github.com/LimeSurvey/LimeSurvey/blob/18...edb_helper.php#L1170

thank !

Steps To Reproduce

Steps to reproduce

update an old version to 6.5.4
go to plugins
add an existing plugin (like some of core of limesurvey)

Expected result

the plugin is added

Actual result

Crash.

TagsNo tags attached.
Attached Files
Bug heat0
Complete LimeSurvey version number (& build)LimeSurvey Community Edition Version 6.4.5+240205
I will donate to the project if issue is resolvedNo
BrowserFirefox / Chrome
Database type & versionPostgresql 15
Server OS (if known)centos 7.9
Webserver software & version (if known)Apache/2.4. (CentOS) PHP/8.2
PHP VersionPHP Version 8.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

Issue History

Date Modified Username Field Change
2024-05-05 22:57 riqcles New Issue
2024-05-05 22:57 riqcles File Added: 2024_05_03_Plugins_migration.pdf